Skip navigation.

Kris Rice

Syndicate content
Educating developers on what Oracle tools and products our team makes, hopefully.
Updated: 17 hours 51 min ago

Yet another CSV -> Table but with pipleline function

Tue, 2015-08-25 08:11
Here's just one more variation on how to get a CSV into a table format.  It could have been done before but my google-fu couldn't find it anywhere. First to get some sample data using the /*csv*/ hint in sqldev. Then the results of putting it back to a table. The inline plsql is just to convert the text into a CLOB. Now the details. The csv parsing is completely borrowed(stolen) from

Connecting to DBaaS, did you know this trick?

Wed, 2015-07-15 15:10
SSHTunneling Trick The new command line is a must try, says 10 out of 10 people that built it.  The tool has sshtunneling of ports built in as described by Barry. This means you can script opening your sshtunnel from the command line and run sql very quickly.  Here's the one I used recently at Kscope15. Now the trick? is that once this port is forwarded, any tool can now use it.  In case

Publish data over REST with Node.js

Tue, 2015-07-14 09:47
Of course the best way to expose database data over REST is with Oracle REST Data Services.  If you haven't read over the Statement of Direction, it's worth the couple minutes it takes.  The auto table enablement and filtering is quite nice. For anyone interested in node.js and oracle, this is a very quick example of publishing the emp table over REST for use by anyone that would prefer REST

APEX Listener supported App Servers

Tue, 2015-07-14 09:47
     With the latest news on Glassfish, I thought it may be a good time to review the options for the APEX Listener to deploy.  The huge caveat is this is as of today, 11/6/2013 , the future can change anything however there’s nothing planned. The Licenses I'm just putting the important parts here for reference.  They are linked to the entire license. OTN License  The APEX Listener is

How to use RESTful to avoid DB Links with ā'pěks

Tue, 2015-07-14 09:47
So the question came up of avoiding a db link by using the APEX Listener's RESTful services to get at the same data.  This is all in the context of an Apex application so apex_collections is the obvious place to stuff transient data that could be used over a session. Step 1:  Make the RESTful Service. The only catch is to turn pagination off ( make it zero ).  I didn't need it for now so this

RESTful Cursor support for JSON

Tue, 2015-07-14 09:47
Just a real quick blog before I forget.  In the latest APEX Listener 2.0.4 patch, there's support for nested cursors.  There is two gotchas.  First make sure to to disable ( make 0 ) the pagination of the REST definition.  The second is this only works at the top level, so not nested nests of nests. This is a very quick example of tables and nested in each table the columns and indexes that

Chunked File loading with APEX Listener + HTML5

Tue, 2015-07-14 09:47
  I just found the HTML5 File API the other day so I had to see what I could do with the APEX Listener's RESTful services. There's a bunch of blogs on what can be done such as on HTML5rocks  .   The end result is that the new File api let's javascript get details of the file and slice it up into parts. Then I made a pretty simple REST end point to receive the chunks and put them back together

ORDS - Auto REST table feature

Tue, 2015-07-14 09:47
Got a question on how easy it is to use ORDS to perform insert | update | delete on a table.  Here's the steps. 1) Install ORDS ( cmd line or there's a new wizard in sqldev ) 2) Enable the schema and table in this case klrice.emp; ( again there's a wizard in sqldev ) BEGIN ORDS.ENABLE_SCHEMA(p_enabled => TRUE, p_schema => 'KLRICE',

REST Data Services and SQL Developer

Tue, 2015-07-14 09:47
The database tools team released 3 new GA releases and an update to our SQLCL. Official Releases are here:    SQL Developer, Modeler, and Data Miner:   REST Data Services now with SODA

New Tools releases , now with Java

Tue, 2015-06-30 10:28
What's New   For the 90%+ of people using sqldev/modeler on windows, the JDK bundled versions are back.  So no more debating what to install or worrying about conflicting Java versions.   Lots of bug fixes.    My favorite bug is now fixed so you can use emojis in your sql> prompt. RESTful CSV Loading   We wrapped he same CSV import code in SQL Developer into the REST Auto-Enablement

SQLcl , yet again

Tue, 2015-06-16 13:54
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 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

Javascript Inside the Database

Wed, 2015-06-03 14:15
Where there's a will, there's a way. Not sure on the best use of this off hand but here it is. Javascript inside an Oracle Database. Since Javascript is included in java via the ScriptEngine framework. It's fairly easy to add a java wrapper to call the javascript engine. create or replace and compile java source named "EvalScript" as import javax.script.*; public class EvalScript {