Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
Choose a layout and drag widgets onto your Overview Page to customize it. Widgets placed on the page below can be configured by selecting the symbol.
Ask Tom is an online repository of over 12,800 questions and answers that have been answered by Tom Kyte. This content covers many topics related to building applications on top of Oracle Database.
Ask Tom is one of the leading sites online to learn about Oracle Database.
With Tom taking a personal leave, two deeply experienced Oracle Database experts, Connor McDonald and Chris Saxon, are stepping in take over on the Ask Tom Answers Team.
While no one else can ever be Tom Kyte, we are certain you will find yourself learning from these experts, as you did from Tom.
We also hope you will enjoy the freshened-up Ask Tom website.
This Oracle Developer Community page is not a replacement for the Ask Tom website.
Instead, use this page to offer (and vote on) ideas for any changes you would like to see on the Ask Tom website, to make it as useful as possible to you. To see or add to these ideas, click on Content.
If you post a question about Oracle Database technologies in Ideas, it will be removed.
Tom has traveled the world several times over, sharing his expertise along the way with tens of thousands of Oracle Database developers and DBAs.
In that same period, he's answered thousands of questions on AskTom.oracle.com.
Tom has now decided to take a "time out," to work on some new books on Oracle technology and spend more time on Planet Earth instead of its atmosphere.
Read Tom's Timeout and Thanks here.
Hi, I do suggest a session for best practices in Apex. BR.
No biggie, just noticed that on the page when viewing a question, the "Built with (L) using Oracle APEX" is shown twice in the footer: Whilst I'm here though, I'll ask for something else I thought about a while back. Can you put a shortcut to the "My Questions" page on the user account drop-down menu? I often go back to look at questions I've asked previously, and it would be a bit easier to access than having to go Questions > Advanced Search > Your Questions. My final pedantic mo …
> Read Tom's Timeout and Thanks here ... But, the link points to Oracle Magazine!? Regards, Zlatko Sirotic
Good afternoon, One of our client executed the code below to get rid off a slowness at the database level alter session set "_column_tracking_level"=0; What's the purpose of such command? Thank you Simon
Hi all, I would like to do the following using conditional compiling when the DB release_name is greater than 12.2.0 then a certain operation has to be performed, else not. I use the below code, it always goes to the ELSE part of the IF condition. Also, I will not be able to use dbms_db_version.ver_le_12_2 , the reason is, I am looking for release_name(from fnd_product_groups table) which has to be equal to or greater than 12.2.0 and not the database version(from v$version). Any pointers or samp …
Oracle Database 12c: Admin, Install and Upgrade Accelerated
Learn how to install and manage Oracle Database and get 7 days of content in just 5 days.
Oracle Database 12c: New Features for AdministratorsLearn the new enhanced features and options of Oracle Database 12c.
Big Data Learning Subscription
Get 24/7 access to a comprehensive set of training videos and product demos delivered by Oracle experts.