(Jeff Smith) If you know how to edit your code in SQL*Plus, you already know how to do it in SQLcl. But I get asked this a lot, do you support EDIT? Do you support CHANGE? And what does SQLcl offer over those?
Tag: Oracle
Those pesky dates as strings
(connormcdonald) You might be thinking “Nothing is more frustrating that encountering a string column that is full of dates”.
Data Recovery Advisor (11g)
(Hemant K Chitale) Here’s my YouTube video on using the 11g Data Recovery Advisor from the RMAN command line.
Unique constraint WWV_FLOW_WORKSHEET_RPTS_UK violated
(Jeffrey Kemp) If your Apex application import log shows something like this:
Understanding query slowness after platform change
(Bobby Durrett) We are moving a production database from 10.2 Oracle on HP-UX 64 bit Itanium to 11.2 Oracle on Linux on 64 bit Intel x86. So, we are upgrading the database software from 10.2 to 11.2.
Oracle BPM 12c: Browsing the SOAINFRA
(Jan Kettenis) In this article I discuss some tables from the SOAINFRA schema that might be most interesting to use when trying to find out why you don’t see in Enterprise Manager what you expect.
Using External Table on Windows RAC ACFS
(Zohar Elkayam) One of my customer is using Oracle RAC (11.2.0.3) on Windows 2012. This is might not be the most ideal setup I’ve ever seen, but it works and we’ll leave it by that.
Oracle Management Cloud – Log Analytics
(Marco Gralike) In this last overview post I will give you a first glance of the Oracle Management Cloud offering called “Log Analytics“ as I experienced it in an Oracle demo environment.
SQL Developer Data Modeler: Adding Journaling Tables
(Jeff Smith) You may want to audit or ‘journal’ changes to your data.
Using a Sparse Index
(Michael McLaughlin) My vacation from my blog is officially over. The question that I’m answering today is: How can you pass a set of non-sequential ID values to a function and return a result set? You can solve the problem by passing an ADT (Attribute Data Type) or UDT (User Defined Type) variable
