How to rename an index in oracle?
How to view the data files in the current database?
Display Odd/ Even number of records?
Can we use bind variables in oracle stored procedure?
How to bring a tablespace offline?
What are the differences between lov and list item?
What are the major difference between truncate and delete?
how will I find the first 5 highest salaried employees in each dept in oracle.
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.......
Indexes in oracle ?
3 Answers Keane India Ltd, L&T,
Explain what are the uses of rollback segment?
What are the factors causing the reparsing of SQL statements in SGA?
What is the difference between "as" and "is" in an oracle stored procedure?