Re: Create new table as select Help PLease!!!!

Try this :

create table userid.pm_section_lg_arch
tablespace user_data
as
select *
from userid.pm_section_lg
where entry_timestamp = to_date('15-AUG-00 14:46:27','DD-MON-YY HH24:MI:SS') ;

Happy coding
AJ Received on Wed Oct 11 2000 - 21:37:16 CEST