Skip navigation.

Kris Rice

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

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  sqlcl-4.2.0.15.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

ORDS - Auto REST table feature

Thu, 2015-06-04 14:17
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',

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 {

REST Data Services and SQL Developer

Tue, 2015-05-05 07:48
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:        https://blogs.oracle.com/otn/entry/news_oracle_updates_development_tools        https://blogs.oracle.com/datamining/entry/oracle_data_miner_4_1   REST Data Services now with SODA        https://blogs.oracle.com/otn/entry/

Logstash and Oracle Database

Fri, 2015-05-01 13:09
    For anyone that doesn't know what Logstash is head over to http://logstash.net/ and watch the video on the home page.  Mark Rittman has done a great blog post on the full ELK stack with OBIEE.     This blog post is a first cut at an input filter for Logstash to gather metrics, logs, or anything that can be expressed in sql.  A huge caution that this is a 0.01 attempt and will get better as I

Repeating another SQLCL EA release

Fri, 2015-04-17 06:57
    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.