Originally posted by lgaorcl
Padders: Thank you very much! I test the script, it seems it worked.

One more question: How can select a from date_table where full_date='11/30/2004'? full_date column datatype is date.

I really appreciate your help!
where full_date = to_date('11/30/2004','DD/MM/YYYY')