Blogspot - tkyte.blogspot.com - The Tom Kyte Blog
General Information:
Latest News:
12c - Code Based Access Control (CBAC) part 1 18 Jul 2013 | 07:12 pm
One frequently asked question posed by stored procedure developers since version 7.0 was released in 1992 has been "why do I get an ora-1031 in PL/SQL but not in SQL*Plus directly". I get this questi...
12c - Whitelists... 18 Jul 2013 | 12:20 am
Starting in Oracle Database 12c - you can limit down to the package/procedure or function level what bits of code may invoke other bits of code in the database. This process is called "white listing"...
12c - Implicit Result Sets... 11 Jul 2013 | 01:56 pm
Since version 7.2 of Oracle we've been able to return result sets from stored procedures to clients. The way we've accomplished this in the past is via a REF CURSOR. I've always liked this approach ...
12c - SQL Plus new things.... 8 Jul 2013 | 07:46 pm
SQL Plus is still my typical tool of choice to "talk" to Oracle - 25+ years and going... Oracle Database 12c has introduced a few new things in this venerable old tool Last Login Time By default, S...
In Israel... 5 Jul 2013 | 08:23 pm
I'm in Israel now getting ready for the http://www.iloug.org.il/ conference in Jerusalem next week. Looks to be a good one with Mark Rittman, Joel Kallman and many others speaking! See http://www.il...
12c - Multiple same column indexes... 5 Jul 2013 | 08:15 pm
Another new capability of Oracle Database 12c is the ability to create more than one index on the same set of attributes. That is - you can have two or more indexes on the column "X", or the set of c...
12c - flashforward, flashback or see it as of now... 3 Jul 2013 | 08:06 pm
Oracle 9i exposed flashback query to developers for the first time. The ability to flashback query dates back to version 4 however (it just wasn't exposed). Every time you run a query in Oracle it i...
12c - Silly little trick with invisibility... 2 Jul 2013 | 11:03 pm
This is interesting, if you hide and then unhide a column - it will end up at the "end" of the table. Consider: ops$tkyte%ORA12CR1> create table t ( a int, b int, c int ); Table created. ops$tkyte%...
12c - Invisible Columns... 2 Jul 2013 | 07:51 pm
Remember when 11g first came out and we had "invisible indexes"? It seemed like a confusing feature - indexes that would be maintained by modifications (hence slowing them down), but would not be use...
12c - SQL Text Expansion 1 Jul 2013 | 06:28 pm
Here is another small but very useful new feature in Oracle Database 12c - SQL Text Expansion. It will come in handy in two cases: You are asked to tune what looks like a simple query - maybe a two ...
