if you ctreate table identity
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between Sleep and Wait? (Java)
1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error
How to insert multiple rows with one insert statement in oracle?
How to fetch the row which has the max value for a column?
What is an oracle and why it is used?
Explain a data segment?
Why do we need integrity constraints in a database?
diff between DELETE and TRUNCATE?.
14 Answers HCL, Yalamanchili Software,
create or replace procedure show_tab_rec ( P_tab VARCHAR2 ) IS cmd varchar2(50); begin cmd := 'select * from '|| P_tab; for int in ( execute immediate cmd ) loop dbms_output.put_line ( int.ename||' '||int.deptno); end loop; end; when i m compling this procedure i m getting this error PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following: . ( ) , * @ % & | = - + < / > at in is mod remainder not range rem => .. <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ PLZ solve this error give this question answer asap Thanks advance.......
What is a subquery in oracle?
What to do if the binary spfile is wrong for the default instance?