How to build data dictionary view an new database?
- 0 Answers
- 640 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is a data lock in oracle?
How to connect to a remote server?
What is a read only transaction in oracle?
Differentiate between pre-select and pre-query?
various types of hints and their usage
What is connection pool in oracle?
Can a primary key contain more than one columns?
How to add a new column to an existing table 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.......
How to retrieve values from data fields in record variables?
What do you mean by merge in oracle and how can we merge two tables?
What is mean by Program Global Area (PGA) ?
Oracle General 
