Educating developers on what Oracle tools and products our team makes, hopefully.
Updated: 14 hours 34 min ago
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
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
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
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
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
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',
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/
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
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-188.8.131.52.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
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
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.