↓
 

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 Client

Tag Archives: Client

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

  • nlNederlands (Dutch)
  • enEnglish

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

  • 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 RoonFollow

Erik van Roon
Retweet on TwitterErik van Roon Retweeted
Qualogy_newsQualogy IT News@Qualogy_news·
Thu 2021-04-15 14:15

QUALOGY SHARES KNOWLEDGE – Qualogy is hosting a new series of Meet The Oracle Masters. Featuring live #webinars from (among others) Patrick Barel, Jim Czuprynski, Jeff Smith, Menno Hoogendijk and Job Oprel. View the program and register now: https://bit.ly/2QtgHba

evrocs_nlErik van Roon@evrocs_nl·
Thu 2021-04-15 17:40

Except when you're doing DML on the database. Don't do that one change at a time, do that in bulk as much as possible 😁

Swiss Oracle User Community@swissOUC

👩‍💻SORA's Tip #86

Do one change at a time - don't change multiple things at once.

#CommunityTips #SwissOUC

Retweet on TwitterErik van Roon Retweeted
VincentvanRoonVincent van Roon@VincentvanRoon·
Wed 2021-04-14 05:35

Ik ben kandidaat-lijsttrekker voor @D66_Delft.

Omdat er nog teveel blokkades voor échte kansengelijkheid zijn en we nog grote stappen moeten zetten tegen de klimaatcrisis.

Samen kunnen we van D66 weer de grootste partij van Delft maken. Doe je mee?

http://www.vincentvanroon.nl

Retweet on TwitterErik van Roon Retweeted
mashprogrammashprogram@mashprogram·
Tue 2021-04-13 10:00

#MASHProgram step 4: Submitting the Abstract

https://mashprogram.wordpress.com/program/#submit

As a first-timer, submitting to a large well-established multi-day conference with many tracks can be like taking a dive from the tallest cliff around. Consider starting with a local or regional user group.

Retweet on TwitterErik van Roon Retweeted
swissOUCSwiss Oracle User Community@swissOUC·
Mon 2021-04-12 09:48

👩‍💻SORA's Tip #83

Agree on a set of coding guidelines with your team!

#CommunityTips #SwissOUC

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