↓
 

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 JavaScript

Tag Archives: JavaScript

Your library is your paradise

EvROCS Posted on 2021-05-28 by Erik van Roon2022-04-22

Update 14-07-2021 I just tried SQLcl latest version 21.2. First results: The registering of my custom commands with below library doesn’t work anymore. Could be my bad, in which I’ll try to fix it, could be something in SQLcl. I don’t know yet, have to investigate as soon as I have the time. For now: Either don’t use this library, or stick to 21.1.1 until the root cause is fixed. Update 08-10-2021The above mentioned problem was not due to my code, so the library can be safely used. It’s caused by new stuff inside SQLcl.So, if you run javascript code and only receive one of these messages:“!ScriptCommand.1!”“JS Language engine not found”The quickest way to solve it is to install JDK. (Or better yet: GraalVM. See next update.) Update 14-04-2022On 07-04-2022 version 22.1 of SQLcl was released which ends support for Java 8.So, as of that version Java 11 is the … Continue reading →

Posted in Uncategorized | Tagged Command, Custom, Custom Command, Extend, JavaScript, library, register, Scripting, SQLcl, unregister | Leave a reply

Hit the road Jack, and don’t you come back no more….

EvROCS Posted on 2021-05-28 by Erik van Roon2021-05-28

In my blogpost “Being in command“, about custom commands I said that I couldn’t find a way to unregister  a registered custom command, other than restarting SQLcl.That is still true. I couldn’t.But Philipp Salvisberg could. He was able to find a way to do just that. That means that with his hard work as input, we are now able to Unregister a previously registered custom command.That makes it possible to register the command in an edited new version without the need to restart SQLcl. So, like Jack in the famous song, let’s try to kick a registered custom command out of our SQLcl house. Go straight to Introduction First of all: this post will deal with the code needed to unregister a custom command.In my humble opinion just, like registering a command, it takes too much code and effort to be considered user friendly.In my next blog post I will … Continue reading →

Posted in Uncategorized | Tagged Command, Custom, Custom Command, Extend, JavaScript, register, Scripting, SQLcl, unregister | Leave a reply

Being in command

EvROCS Posted on 2020-08-19 by Erik van Roon2021-05-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

  • 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
Retweet on Twitter Erik van Roon Retweeted
thatjeffsmith SQL.ProductManager.Oracle.Databases 🏋️ 🥃 @thatjeffsmith ·
Fri 2022-08-12 10:56

Today's follow rec is @sqldaily

Daily #SQL tips from our SQL maestro @ChrisRSaxon

If you already follow, do me a solid and RT.

Retweet on Twitter Erik van Roon Retweeted
kibeha Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺 @kibeha ·
Thu 2022-08-11 09:19

Want to catch up on new features in #OrclDB over the versions?

Database New Features Guide
12.2: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/newft/toc.htm
18: https://docs.oracle.com/en/database/oracle/oracle-database/18/newft/toc.htm
19: https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/toc.htm

Learning Database New Features
21: https://docs.oracle.com/en/database/oracle/oracle-database/21/nfcon/toc.htm

You'll find things you didn't know😉 https://twitter.com/kibeha/status/1557654930516754432

Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺 @kibeha

@mib1906 Interesting - if you take my 19c URL and replace "19/newft" with "21/newft" - it redirects to "21/nfcon".

So the "nfcon" doc "Learning Database New Features" is the new upgraded version of the old "newft" doc "Database New Features Guide".

Retweet on Twitter Erik van Roon Retweeted
kibeha Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺 @kibeha ·
Thu 2022-08-11 07:05

TIL the "Learning Database New Features" guide in the 21c docs:

https://docs.oracle.com/en/database/oracle/oracle-database/21/nfcon/toc.htm

One stop to learn about all new features of the release.

Good idea - HT to whomever thought of this 👍

Retweet on Twitter Erik van Roon Retweeted
geraldvenzl Gerald Venzl 🚀 @geraldvenzl ·
Tue 2022-08-09 13:01

I found a hidden gem that explains #Oracle #Database character sets and its sophisticated globalization support. A must read for anybody who always wanted to know what's behind $NLS_LANG. http://geraldonit.com/2022/08/09/everything-you-always-wanted-to-know-about-oracle-database-nls_lang-and-character-sets/

Retweet on Twitter Erik van Roon Retweeted
mikedietrichde Mike Dietrich @mikedietrichde ·
Mon 2022-08-08 10:07

Virtual Patching – the biggest nonsense I’ve ever heard about https://mikedietrichde.com/2022/08/08/virtual-patching-the-biggest-nonsense-ive-ever-heard-about/

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