Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Execute Immediate Passing Date

858631Jan 8 2013 — edited Jan 14 2013
Hi friends

I can Query a data

select * from employees where hire_date > '01-JAN-1995' -- Here it returns 10 row

My doubt
BEGIN
execute immediate ' create table xxx 
as (select * from employees where  hire_date > '01-JAN-1995')' ;

END ;
I am Getting Error
PLS-00103: Encountered the symbol "01" when expecting one of the following:

Executing DDL is plsql should be passed as String but how can i pass my date datatype ?

Thanks
Suresh
This post has been answered by BluShadow on Jan 8 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 11 2013
Added on Jan 8 2013
22 comments
12,736 views