"Or if you give me email address of Tom Kyte, i may request him personally."

I think we can assume that there was a reason Tom opts to keep his blog and email private. They are not "owned" by Oracle or AskTOM, it is his own.

Any reference to blog articles from AskTOM have been copied to the AskTOM server and links updated accordingly.

I'll dig around and see what I can find out.

Please check back in a couple of days.

NP, thanks for digging this out anyway.

That will be corrected soon.

Tom deleted that post before we migrated it over. It's no longer there.

Sorry.

Here you go

12c-code-based-access-control-cbac-part.html
12c-whitelists.html
all-about-security-sql-injection-redux.html
all-about-security-sql-injection.html
another-of-day.html
archive-log-mode.html
back-from-oracle-openworld.html
building-better-website-and-logic.html
constraints-have-bad-name.html
csv.html
CTime.html
DateDiff.html
dreaded-others-then-null-strikes-again.html
flash-forward.html
free.html
gripe-sheet.html
how-cool-is-this.html
how-to-ask-questions.html
httpasktomoraclecomtkyteflat.html
httpasktomoraclecomtkyteunindex.html
i-believe-strongly-there-are-only-two.html
im-speak.html
instrumentation.html
LargeStrings.html
motivation.html
MoveLongs.html
next-book-part-ii.html
NLSDateFormat.html
nodataneeded-something-i-learned.html
OCI-N-Tier.html
ok-so-what-happened-up-there-on-stage.html
order-in-court.html
ouch-that-hurts.html
Passwords.html
pokemon-and-when-others.html
Random.html
random.sql
reader-asks.html
RolesAndProcedures.html
see-you-just-cannot-make-this-stuff-up.html
slow-by-slow.html
something-about-nothing.html
something-different-part-i-of-iii.html
something-i-recently-unlearned.html
something-new-i-learned-about-estimated.html
SpellANumber.html
sqltracetrue-part-two.html
stuck-in-rut.html
su.html
success.html
the-keys-to-oracle.html
tuning-with-sqltracetrue.html
use-null-for-unknonw-data.html
varying-in-lists.html
what-about-mathematics.html
what-attributes.html
what-i-learned-new-about-total-recall.html
when-explanation-doesn-sound-quite.html
why-do-people-do-this.html
why.html

we've only got a subset - I will dig around and see what I can find

I located it, and will get it updated on the list, but in the interim

12c - SQL Plus new things....
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
$ sqlplus /

SQL*Plus: Release 12.1.0.1.0 Production on Sun Jul 7 13:53:15 2013

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Last Successful login time: Wed Jul 03 2013 14:30:14 -04:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

ops$tkyte%ORA12CR1>

By default, SQL Plus will display your last login time - if you don't want that, just use -nologintime.

More on invisible columns
I recently wrote about invisible columns and how they wouldn't be displayed via a DESCRIBE command. That is - SQL Plus won't show them by default. However, there is a SET command that will display them:

ops$tkyte%ORA12CR1> create table t
2 ( x int,
3 y int invisible
4 );

Table created.

ops$tkyte%ORA12CR1> desc t
Name Null? Type
---------------------------------------- -------- ----------------------------
X NUMBER(38)

ops$tkyte%ORA12CR1> show colinvisible
colinvisible OFF
ops$tkyte%ORA12CR1> set colinvisible ON
ops$tkyte%ORA12CR1> desc t
Name Null? Type
---------------------------------------- -------- ----------------------------
X NUMBER(38)
Y (INVISIBLE) NUMBER(38)


Support for Pluggable Databases
There is support for starting pluggable databases from a container database, as well as three new SHOW commands to see what pluggable databases there are and information about the current pluggable database you are connected to:

sys%ORCL> startup pluggable database pdborcl;
Pluggable Database opened.

sys%ORCL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBORCL READ WRITE NO



sys%ORCL> connect scott/tiger@pdborcl
Connected.

scott%PDBORCL> show con_id

CON_ID
------------------------------
3

scott%PDBORCL> show con_name

CON_NAME
------------------------------
PDBORCL

I don't think it was on his blog - it was in his book Effective Oracle by Design