Educating developers on what Oracle tools and products our team makes, hopefully.
Updated: 15 hours 12 min ago
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 has to happen elsewhere as there's no hooks to do something like validate a number in a range without running a sql or plsql that does
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 Script 6 features it can be done with SQLcl. This is a good reference for what's in version 6 that could be useful. The only caution is not
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/M10kVnsQ3y pic.twitter.com/XFFHOVzNCK — Steven Feuerstein (@sfonplsql) November 11, 2016 Checked if something is reserved seems like a nice add
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 application was X days ago. This is a java program that is part of the apex distribution. The catch for some folks is that it's a java program and
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 plsql gateway. There has always been a validation configuration option to lock down what procedures are accessible which was outlined in
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 needed. What if there was a simple kill command. Here a sample one that takes in the 2 options: kill sid serial# Example : kill 1 2 OR
Oracle Database 18.104.22.168 introduced JSON support. This is supported in REST Data Services already and now in the latest SQLCL. This means ORDS can serve up the access to client applications and developers can have a command line way to interact and test features/queries/... in a nut shell a shell for JSON document storage. To use this feature the database will be to have patch #20885778
The github repo for all the things the DB Tools team does will be posted here https://github.com/oracle/Oracle_DB_Tools This will include sqlcl , sqldev, modeler, ords , and who knows what other things we have up our sleeves to post. This repo is going to be made up of examples and getting started things like a new extention for sqldev, custom transformation for modeler, ords integration with
There was an idea logged over on community.oracle.com to add AskTom style print_table to sqlcl. Here's how easy it is now that there's scripting in sqlcl. This is a simple js file that loops over the rows and columns and prints them. When using the executeReturnListofList the first row is the name of the columns for reference. With that data there it's quite simple to customize any output.
Another build of SQLCL is out. This one has lots of great things in it. There's fix in there to work with Cygwin for the unlucky people that are still on windows. Now the new stuff: SCRIPT This new command can radically change things you can do in the tool. The script command runs a script that can be any language that is JSR-223 enabled. The best list I can find is here: https://
It was time for another push of the new sql command line , sqlcl. Here's the changes in the latest build. There are a number of bugs fixed relating to connecting to idle databases, alias feedback, and picking up the $ORACLE_HOME's jdbc driver when available. There is only a couple functional changes. First is that now the jdbc connect string itself can be specified. This opens up a number
A new SQLCL build was just posted go grab it and kick the tires. There are well over 100 bug fixes in there so it's better than ever. Also there's some new things. More Secure Imagine you have an api that is called and a password or something is used in the parameters. We use exec MY_API(...) and it works just fine. However consider if someone with access to v$sql they just got
By the Numbers There's a new SQLcl out for download. In case, there are too many to keep track of the build numbers are quite easy to tell if you have the latest. The build posted today is sqlcl-22.214.171.124.167.0827-no-jre.zip Here's what we are doing 4.2.0 <-- doesn't matter at all 15 <- year 167 <- day in julian 0827 <- time the build was done So yes, this build was done today at 8am
It's been a month and a lot of bugs have been fixed in that time and new features added. That adds up to time for another EA for our new sqlcl. The third sqlcl EA is out now and can be found here on the SQL Developer 4.1 download page. Not sure what this sqlcl thing is ? Check here. LOAD: Making CSV loading to the db very easy Here's a very quick example of the possibilities.