I posted this question in a review earlier ( http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:442029737684#2657519000346087952 ) However.. i am taking liberty to post it again.. just in case you want to treat it as a new question …
I posted this question in a review earlier ( http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:442029737684#2657519000346087952 ) However.. i am taking liberty to post it again.. just in case you want to treat it as a new question …
Tom Kyte, well known Oracle expert and Host of ‘AskTom.Oracle.Com’ shares his thoughts on Oracle Database 11g Release 2.
I’ll be writing about this in Oracle Magazine shortly as part of the asktom column – but thought I’d mention it here too. Recently on asktom.oracle.com, I was asked a question about the pre-defined exception NO_DATA_NEEDED. At first I thought that is was a typo – they really meant NO_DATA_FOUND – since I hadn’t heard [...]
Tom Kyte, well known Oracle expert and Host of ‘AskTom.Oracle.Com’ shares his thoughts on Oracle Database 11g Release 2. Link to the original site
The Tom Kyte Blog: http://asktom.oracle.com/tkyte/ Pointers to the material that was previously hosted on http://asktom.oracle.com/tkyte SQL Profiles [PDF] Paper about SQL Profiles by Christian Antognini Articles & Presentations by Joel Goodman A list of User Group presentations and articles that Joel wrote or co-authored and published in the past few years. Presentations were made to [...]
How Can I unload data to a flat file Many times we are asked “Does anyone know an easy way of dumping the data from an Oracle table into a delimited(comma, tab etc) ascii file?” “Does anyone know an easy way to unload data in a format for sqlldr to reload later?” Well here is [...]
How Can I find out who called me or what my name is Many times we are asked “in a procedure/function, can I find out who called me” or “can I dynamically figure out the name of the procedure or package that is currently executing”. You can find it in the call stack returned by [...]
Unindexed Foreign Keys Having Unindexed foreign keys can be a performance issue. There are two issues associated with unindexed foreign keys. The first is the fact that a table lock will result if you update the parent records primary key (very very unusual) or if you delete the parent record and the child’s foreign key [...]
Base Conversion Routines This set of routines is useful to convert between various ‘bases’ in Oracle. Once you install these functions, you will be able to perform operations such as: SQL> select to_bin( 123 ) bin, to_hex( 123 ) hex, to_oct( 123 ) oct from dual2 / BIN HEX OCT————— ————— —————1111011 7B 173 SQL>SQL> [...]