execute immediate ('create table temp as select * from emp where emp_name='ABC'
but it can't work.
can anyone correct me
Syntax error, try:
execute immediate 'create table temp as select * from emp where emp_name=''ABC''';
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
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.
Click Here to Expand Forum to Full Width