One I used to love to give (really tests their ability to listen)

Whats wrong with this statement

delete colA, colB, colC from TableA
where ColA = :a and ColB = :c;

you would be very surprised at the answers, I was.

I even had one guy tell me the ":" wasn't legal syntax.

Mike

>On 06/27/2006 08:30:02 AM, dba1 mcc wrote:
>
>
>>Anyone has web site for ORACLE interview questions?
>>
>>Thanks.
>>  
>>

--
http://www.freelists.org/webpage/oracle-l