↓
 

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 Scripting

Tag Archives: Scripting

Being in command

EvROCS Posted on 2020-08-19 by Erik van Roon2020-11-28

This post is the third one of three that together are an introduction to scripting in SQLcl.Also read part 1 and part 2. In the previous post I’ve created functionality for SQLcl that it doesn’t have “out of the box”.In this post I’ll continue to build on that script, but the information here is valid for any JavaScript script you develop for SQLcl. In short: I built some functionality in JavaScript that can read a client file and place the contents in a bindvariable.This script resides in a file called “file2bind.js” so we can use it by telling SQLcl we want to run a script with this name and certain parameter values.Executing that script is done using the built in command “script” As I’ve said a couple of times in that post: I’m lazy.So typing “script ” every time I want to execute this script will get on my nerves … Continue reading →

Posted in SQLcl | Tagged Alias, Command, Custom, Custom Command, Extend, JavaScript, Listener, Scripting, SQLcl | 3 Replies

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

When great just isn’t good enough

EvROCS Posted on 2020-08-19 by Erik van Roon2020-10-15

This post is the first one of three that together are an introduction to scripting in SQLcl.Also read part 2 and part 3. For many years now SQLcl is my favorite command line tool to connect to Oracle databases. (available at the bottom of the SQL Developer download page)It does (practically) everything SQL*Plus does and a whole lot more. It has many capabilities that SQL*Plus just doesn’t have.But this post is not about those goodies SQLcl delivers, it’s more or less about what is doesn’t…. No matter how good we think a tool is, and I think SQLcl is great, there will always be things missing, or not quite the way we would want them to be.SQLcl is no exception to this rule.Inevitably we run into something that makes us think “I wish it could do ….”.The team that brings us SQLcl (and SQL Developer and Datamodeler and ORDS) is … Continue reading →

Posted in SQLcl | Tagged introduction, JavaScript, Scripting, SQLcl | Leave a reply

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
↑