AskTom - Hot Questions

Subscribe to AskTom - Hot Questions feed AskTom - Hot Questions
These are the questions on Ask Tom that have the most comments
Updated: 43 min 18 sec ago

Insert Direct path load

Fri, 11/06/2015 - 00:00
Hi tom, While inserting record in a table when we use append hints, it going for direct path load but when use parallel hints it is going for conventional path load.Is it correct? While insert use should always use Append hints not parallel hi...

group/partition by multiple columns

Wed, 11/04/2015 - 00:00
Hi Tom, Here is saved script: https://livesql.oracle.com/apex/livesql/file/content_CEFPWL3UZTXJIA5QI852MTYXW.html I have this table create table temp_mins ( barcode varchar2(20), w_row varchar2(3), w_col number(3,0), keyid number(4,0...

Why Does Oracle Want to Raise ORA-01403, Instead Of Returing NULL?

Wed, 10/28/2015 - 00:00
Hi Tom, I wanted to blame Oracle for raising ORA-01403 instead of returning NULL in case of no data found. Because of that, my develops code such awkward and wasting SQL: SELECT COUNT(*) INTO V1 FROM T1 WHERE C1 = 'A'; IF V1 > 0 THEN ...

Pages