execute immediate

hello all,

declare
begin
execute immediate ('create table temp as select * from emp where emp_name='ABC'
')
;
end

but it can't work.

can anyone correct me


regards,
Ash

Syntax error, try:
execute immediate 'create table temp as select * from emp where emp_name=''ABC''';

Why are you even using declare if there is nothing to declare? Is this a homework problem?

Thanks a lot PAVB for yr quick replay.