↓
 

EvROCS

Completing the puzzle

  • Home
  • Events
    • = List of events =
    • KScope
      • KScope General
      • KScope15, Hollywood Florida
      • KScope14, Seattle
      • KScope13, New Orleans
      • KScope12, San Antonio
    • Christmas 2013
    • OPP 2007
  • Resume
  • Quotes
  • Contact
  • EScope
  • Downloads
    • Query KScope Sessions
  • Blog
Home→Tags File

Tag Archives: File

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

EvROCS Posted on 2020-08-19 by 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. … Continue reading →

Posted in SQLcl | Tagged bind, BindVariable, Client, File, JavaScript, Read, Read Client File, Scripting, SQLcl | 3 Replies

Talen

  • Nederlands (Dutch)
  • English

Search

Subscribe for notification of new blogposts

Subscribe to email notifications for new blog posts

Loading

RSS

  RSS Feed Blog Posts

  RSS Feed Comments

Recent articles

  • It’s so easy to pick the wrong one                                         #JoelKallmanDay
  • 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

Follow me on Twitter

Erik van Roon Follow

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

evrocs_nl
Retweet on Twitter Erik van Roon Retweeted
poug_org ORA-600 @poug_org ·
Fri 2025-04-25 09:03

It's time to break the silence. #POUG2025 is not just a fun conference. It can be dangerous.
@evrocs_nl Van Roon was the first to speak loudly about the consequences of attending our event.
https://poug.org/edycja/poug-2025/

Retweet on Twitter Erik van Roon Retweeted
ora600pl Kamil Stawiarski @ora600pl ·
Sat 2025-04-12 14:10

Who wants to simulate OCI on premises to play with 23ai at home?

https://blog.ora-600.pl/2025/04/12/simulate-oracle-cloud-on-kvm-olvm/

Retweet on Twitter Erik van Roon Retweeted
poug_org ORA-600 @poug_org ·
Fri 2025-04-04 10:06

Vergiss langweilige Konferenzen mit Verkaufsmaschen und null Mehrwert 🙄

Komm zu einem 100 % Tech-Event direkt hinter der Grenze - und werde Teil einer einzigartigen Community. #POUG2025 wartet im September auf dich! 🔥

https://poug.org/en/

evrocs_nl Erik van Roon @evrocs_nl ·
Thu 2025-03-20 16:02

#APEXWorld25 by @nl_OUG
One of the wonderful events that values new speakers and thus actively advertises for the @mashprogram
Thanks guys!

Retweet on Twitter Erik van Roon Retweeted
nl_oug nlOUG @nl_oug ·
Fri 2025-03-14 09:00

On March 20, we will celebrate 15 years of APEX World with an evening of entertainment. Prepare for an evening to remember! You just might win a prize!

Get your tickets for APEX World so you can join in on the fun! https://nloug.nl/events/apex-world-2025/

#orclAPEX #aw25

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