Hi,

Use 'sysdate' - without the quotes.

example:

select sysdate from dual
/

Kate

Hi Adi, I am glad you have it figured out now.

I am not sure what your problem is being caused by, but this is the definition of ORA-01019 if you didn't know.

ORA-01019: unable to allocate memory in the user side
Cause: The user side...

Hi benjamins,

Try this:

select tbl3.tbl3_name,
tbl4.tbl4_name,
tbl3.tbl3_flag,
tbl4.tbl4_flag
from tbl2,
tbl3,

Look into the 'execute immediate' command. You can use it to drop your constraint using the value in PKNAME.

Try 'Oracle PL/SQL Programming' from O'Reilly. I have the third edition by Feuerstein & Pribyl, it covers Oracle up to version 9i. I am not sure if a new edition has been released, but the series is...