Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Fahd.

Asked: September 22, 2017 - 5:13 am UTC

Last updated: April 02, 2024 - 5:53 am UTC

Version: 11.2.0.3.0

Viewed 10K+ times! This question is

You Asked

Hi,

What has happened to Tom Kyte's blog http://tkyte.blogspot.com/
Can you add me to white list of that blog ? Will be very great-full.

Thanks
Fahd

and Chris said...

Tom has made it private.

We've extracted the articles and loaded them here. For example:

https://asktom.oracle.com/Misc/all-about-security-sql-injection.html

Rating

  (12 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Review Tom Kyte Blog

Fahd Bahoo, September 23, 2017 - 7:04 am UTC

Hi,
Have you extracted all the articles ?
I can not find articles other then you mentioned.
Is there any way that my email address is given access of original blog ?
Or if you give me email address of Tom Kyte, i may request him personally.
Thanks
Connor McDonald
September 25, 2017 - 3:38 am UTC

"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.

link

Rajeshwaran, Jeyabal, July 11, 2018 - 10:13 am UTC

Connor McDonald
July 12, 2018 - 10:23 am UTC

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

Please check back in a couple of days.

Found requested blog post on SQL injection

Stew Ashton, July 12, 2018 - 12:53 pm UTC

My bad!

Stew Ashton, July 12, 2018 - 12:55 pm UTC

Sorry, I missed the "redux" part!

Never mind...

Regards,
Stew
Chris Saxon
July 12, 2018 - 2:37 pm UTC

NP, thanks for digging this out anyway.

thanks for the contents

Rajeshwaran Jeyabal, July 26, 2018 - 4:43 am UTC

Thanks, this link works now & able to access it.

https://asktom.oracle.com/Misc/all-about-security-sql-injection-redux.html

one more link needed

Rajeshwaran Jeyabal, November 29, 2018 - 3:19 pm UTC

Team,

Could you please help us with the content of this link?

http://tkyte.blogspot.com/2012/08/what-i-learned-new-about-total-recall.html

Tried this one - http://asktom.oracle.com/Misc/what-i-learned-new-about-total-recall.html , but doesn't work. please help.
Connor McDonald
November 30, 2018 - 6:38 am UTC

That will be corrected soon.

getting credible information link needed.

Rajeshwaran Jeyabal, June 04, 2019 - 10:16 am UTC

Team,

Could you help us with the content from this link http://tkyte.blogspot.com/2005/08/getting-credible-information.html ?

Tried this http://tkyte.blogspot.com/misc/getting-credible-information.html but doesn't work. kinldy help us.
Connor McDonald
June 05, 2019 - 12:10 am UTC

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

Sorry.

List of all Tom Kyte blogs currently available

Aag, June 05, 2019 - 5:41 pm UTC

Can we get a list of all Tom Kyte blogs that are currently available?

https://asktom.oracle.com/Misc/*


Connor McDonald
June 11, 2019 - 5:44 am UTC

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



12c sqlplus new things - from TomKyte blog

Rajeshwaran, Jeyabal, December 06, 2022 - 1:30 pm UTC

Team,

was reading this blog post

https://www.thatjeffsmith.com/archive/2015/01/are-invisible-columns-really-invisible/

that got reference to Tom's blog

https://tkyte.blogspot.com/2013/07/12c-sql-plus-new-things.html

but don't find that page listed in AskTom.oracle.com (resources tab) - so can you please get that link available there?

Connor McDonald
December 09, 2022 - 4:03 am UTC

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

12c sqlplus new things - from TomKyte blog

Rajeshwaran, Jeyabal, December 09, 2022 - 6:15 am UTC

Sure thanks a lot.

once those were added, let us know.
Connor McDonald
December 12, 2022 - 3:39 am UTC

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

free tools i use from Tom kyte web blog.

Rajeshwaran Jeyabal, March 29, 2024 - 1:19 pm UTC

Team,

there is a page in tom kytes blog where he discuss about "free tools i use" (sorry may be i remember that incorrectly) can you get those page details here ?
Connor McDonald
April 02, 2024 - 5:53 am UTC

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


free tools i use from Tom kyte web blog

Rajeshwaran, Jeyabal, April 03, 2024 - 1:39 pm UTC

the chapter#2 from book "Effective Oracle by Design" is all about "Your Performance Toolkit" - where he discuss about tools available in Oracle database for sql tuning activity.

However In his blogpost he discuss about the "free tools" he used for his day to day activity ( say for example he discuss about "Filezila" a Free FTP tool there )

More to Explore

SQL

The Oracle documentation contains a complete SQL reference.