↓
 

EvROCS

Completing the puzzle

EvROCS
  • Home
  • Evenementen
    • = Lijst van evenementen =
    • KScope
      • KScope Algemeen
      • KScope15, Hollywood Florida
      • KScope14, Seattle
      • KScope13, New Orleans
      • KScope12, San Antonio
    • Kerstmis 2013
    • OPP 2007
  • CV
  • Quotes
  • Contact
  • EScope
  • Downloads
    • Query KScope Sessies
  • Blog
Home→Tags Read Client File

Tag archieven: Read Client File

A Person who won’t read has no advantage over one who can’t read

EvROCS Geplaatst op 2020-08-19 door Erik van Roon2020-08-23

This post is the second one of three that together are an introduction to scripting in SQLcl.Also read part 1 and part 3. The title of this blogpost is (supposedly) a quote from Mark Twain, and I completely agree with it.I was reminded of this quote when I was working on the subject of this blogpost. In SQL*Plus you can’t read the contents of a client file.Well, to be honest, you can do “get scriptname.sql” to place the contents of a SQL script in the execution buffer.Or you could copy the file you want to read to the server and use utl_file or an external table definition.But other than that, nothing.No way to just read the contents of any client file. Ok, SQL*Plus is limited, no news there.Let’s turn to the favorite command line tool of the 21st century, SQLcl. SQLcl is capable of reading client files and processing them. … Lees verder →

Geplaatst in SQLcl | Getagged bind, BindVariable, Client, File, JavaScript, Read, Read Client File, Scripting, SQLcl | 3 reacties

Talen

  • Nederlands
  • English (Engels)

Zoeken

Subscribe for notification of new blogposts

Subscribe to email notifications for new blog posts

Loading

RSS

  RSS Feed Blog Posts

  RSS Feed Comments

Recente berichten

  • Your library is your paradise
  • Hit the road Jack, and don’t you come back no more….
  • Being in command
  • A Person who won’t read has no advantage over one who can’t read
  • When great just isn’t good enough

Follow me on Twitter

Erik van Roon Follow

Oracle DB Developer. Oracle ACE Pro ♠️. Rambling fool. By default assume I'm not serious. Tweeted opinions are the one & only truth, and probably unfounded.

evrocs_nl
evrocs_nl Erik van Roon @evrocs_nl ·
do 2023-01-19 15:01

Just in case people missed this critical vulnerability warning for Git....

https://thehackernews.com/2023/01/git-users-urged-to-update-software-to.html

evrocs_nl Erik van Roon @evrocs_nl ·
wo 2023-01-18 17:12

🤣😂😆😁😄😏🤨😳🥺😢

Scott the Scot @ScottRhodie

I saw someone say this and it’s haunting me:

Agile is just waterfall without a plan and it’s basically just micromanagement rebranded.

Retweet on Twitter Erik van Roon Retweeted
davorranko Davor Ranković @davorranko ·
ma 2023-01-16 13:45

SAVE THE DATE = #HrOUG & #JavaCro

2

evrocs_nl Erik van Roon @evrocs_nl ·
zo 2023-01-15 20:25

Doesn't happen often, but every once in a blue moon I'm so happy with myself 😁

Retweet on Twitter Erik van Roon Retweeted
thatjeffsmith SQL.ProductManager.Oracle.Databases 🏋️ 🥃 @thatjeffsmith ·
wo 2023-01-11 16:42

A tale of two #oracle SQL prompts

Get to know @oraclesqlcl !
Details: https://oracle.com/sqlcl

Load More...
©2023 - EvROCS - Weaver Xtreme Theme
↑