Blog: Dermot ONeill

213 blogs updated: 48 min. ago
SQLcl Alias Example For Dropping Multiple Objects.
SQLcl allows you to define "named" scripts or statements using the ALIAS command. Jeff has a neat example on his blog.I created the followin...
13-10-2017 04:07:54 Dermot ONeill Oracle
A REST Enabled SQL View!
I put together a small Oracle PL/SQL package which demonstrates how to access REST Enabled SQL service and standard REST end points through ...
14-09-2017 16:32:39 Dermot ONeill Oracle
Getting Started with REST Enabled SQL
POST a query or DML or DDL or even a short script over HTTPS to ORDS and have ORDS run that on your Oracle Database and have the results ret...
07-09-2017 17:11:01 Dermot ONeill Oracle
New! REST Enabled SQL for ORDS
The Oracle REST Data Service provides REST access to your Oracle Database. Tables, predefined queries and PL/SQL blocks can be exposed as RE...
07-09-2017 10:38:29 Dermot ONeill Oracle
Temporarily Disable a Generated Always As Identity Column
Oracle Database 12c allows you to define a column to be an IDENTITY column. It can be either GENERATED ALWAYS or BY DEFAULT. A GENERATED ALW...
05-04-2017 13:44:16 Dermot ONeill Oracle
SQLcl Aliases & The Invisible Column Trick
SQLcl is the bee's knees. ProblemToday I had a common problem. I wanted to reposition a column within a table."Oh you should use views!" "Ne...
11-11-2015 18:28:00 Dermot ONeill Oracle

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.