When he (more...)
When he (more...)
Steven Feuerstein Master Class. Anti-Pattern PL/SQL Programming + 12c New PL/SQL Features, December 12 and 13 2013
12 and 13 December 2013 AMIS will host a two day masterclas with Oracle PL/SQL guru Steven Feuersten.
The Design Pattern movement reminds us that most of the code we write is similar to something written last week – or maybe even an hour ago. Once you identify a (more...)
In an earlier post, I explained the purpose and usage of the Oracle Wallet Manager. This explanation assumed that the user has the ability to use the graphical user interface to execute the OWM program included with each DBMS installation.
However, sometimes there is no graphical user interface (more...)
If you have used the UTL_HTTP package in PL/SQL to call upon external web pages or services, you might have seen following error message come by:
ORA-29273: HTTP request failed
ORA-06512: at “SYS.UTL_HTTP”, line 1130
ORA-29024: Certificate validation failure
It indicates that the web site you are trying (more...)
Please see the details of the sessions below along with the (more...)
When using SQL Developer, there is a feature called Completion Insight which help you write SQL and PL/SQL in the SQL Worksheets. It will auto-pop helpful things, like object name when typing a SELECT statement, column names if it is aware of the object which you are accessing and things (more...)
Unfortunately, immediately got an issue. It seems to me that passing a variable to FETCH (more...)
dbms_comparison package isn’t deployed when you provision a pluggable databases (PDBs) in Oracle 12c. It appears to be a simple admission. At least, it let me manually compiled the
dbms_comparison package with this syntax:
@?/rdbms/admin/dbmscmp.SQL @?/rdbms/admin/ (more...)
Hansel and Gretel are in the forest and don’t want to get lost, so Gretel leaves a trail of white pebbles to mark their way. In future adaptations of this Bros. Grimm story, the white pebbles have become ‘breadcrumbs.’
So what does this have to do with SQL Developer?
I was hoping that if inline “with” functions are in the query, so their results will be consistent with it (as operators), but unfortunately such functions returns also inconsistent results as standalone pl/sql functions.
SQL> create table t as select 1 a from dual; Table created. SQL> declare 2 j (more...)
If your schemas are like those I deal with, almost every table has a doppelgänger which serves as a journal table; an “after insert, update or delete” trigger copies each and every change into the journal table. It’s a bit of a drag on performance for large updates, isn’t it?