What is a sub query? Describe its types?
- 0 Answers
- 763 Views
- I also Faced
- E-Mail Answers
What is the data type of dual table?
Where are the settings stored for each instance in oracle?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How do we get field detail of a table?
What are named parameters?
How to write an inner join with the where clause in oracle?
Differentiate between pre-select and pre-query?
what is reindexing?
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.......
How to get the Installed Oracle Version Information ?
Can we create more than one index on particular column?
What is set operator oracle?
Oracle General 
