Profile cover photo
Profile photo
Kris Rice
326 followers
326 followers
About
Kris's posts

Post has attachment
How to add an NCSA style Access Log to ORDS Standalone
What ORDS Standalone is      ORDS Standalone webserver which is Eclipse Jetty, https://eclipse.org/jetty/ .  For the standalone, ORDS sends output to STDOUT, it runs on the command line.  That means there's nothing like a control commands like startup, shut...

Post has attachment
SQLcl custom Input prompt and validations
Another quick twitter inspired blog post inspired by the SQLcl account itself. Asked and answered: Do you support the ACCEPT command? YES. pic.twitter.com/NchmQ6Eegs — SQLcl (@oraclesqlcl) November 29, 2016 ACCEPT is a great way to get input but validation ...

Post has attachment
ECMA Script 6 / Nashorn / Java 9 and SQLcl
This blog post brought to you by the letter M as in Martin .  Follow @martindsouza  . He asked me on twitter if SQLcl via Nashorn could use ECMA Script 6 features yet.  The answer is yes.  So, for the brave that want to try out the latest greatest ECMA Scri...

Post has attachment
Import APEX apps now easier with SQLcl
Hopefully by now everyone knows there's the ability in SQLcl to use Javascript and the same javascript can be used to make custom commands extending what SQLcl offers out of the box. Also, I hope everyone knows we are posting examples of this to github as a...

Post has attachment
SQLcl as a library in existing programs
I got a question over the weekend if SQLcl could be leveraged as library from inside a Jython program. This may seem like it's the same thing as adding jython to SQLcl to use instead of Javascript but it's a significant difference. This method allows for t...

Post has attachment
Adding Reserved command in SQLcl
I saw Stephen's example of checking reserved words in the database from Vertan's day and figured I'd do the same in SQLcl. #595 #plsql Is it a reserved word? PL/SQL procedure to help you sort that out. Dyn PLSQL example! @oraclelivesql https://t.co/M10kVnsQ...

Post has attachment
Export APEX application with SQLcl
APEXExport has been around a long time for exporting an application and anything else like images, feedback,websheets,.. into a file system so that they can be version controlled.  This is a must if there is ever a need to rollback or see what the applicati...

Post has attachment
ORDS 3.0.7 more secure by default
Defaulting  PL/SQL Gateway Security Oracle REST Data Services 3.0.7 went out yesterday.  There's an important change that went in to better secure installations by default.  It has always been the case that we recommend customers set the validations for the...

Post has attachment
Kill DB sessions the easy way with SQLcl
Seems I can not tweet these animated GIFs anymore. So this is another very short blog post to show real case for adding a new command into SQLcl  which can be downloaded here . It's hard annoying tedious to find SID and SESSION then alter to kill that when ...

Post has attachment
SQLcl and Query Change Notification
The database has had Query Change Notification for a while but to use it required a custom program. Such as Tim outlines on his blog  https://oracle-base.com/articles/10g/dbms_change_notification_10gR2 Since SQLcl has Nashorn, now it can be integrated with ...
Wait while more posts are being loaded