What is rich query?
No Answer is Posted For this Question
Be the First to Post Answer
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.......
when i run my query on yesterday it is fast but today it is slow why?
what are steps for interface? where is exchange rate defined in which table?
Display the number value in Words?
What is Java Pool in Oracle?
What are the attributes of cursor?
Explain the use of grant option in imp command.
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How to insert a new row into a table in oracle?
How to pass parameters to procedures?
what is host string in sql plus? how does it related to database?
What is the meaning of recursive hints in oracle?