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