↓
 

EvROCS

Completing the puzzle

EvROCS
  • 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 bind

Tag Archives: bind

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

  • English
  • Nederlands (Dutch)

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

  • 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

Twitter feed is not available at the moment.
©2023 - EvROCS - Weaver Xtreme Theme
↑