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.......

1 Answers   HCL,

---

what is dynamic SGA and static SGA

0 Answers   Oracle,

---

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

---

Can multiple cursors being opened at the same time?

0 Answers  

---

i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint type" this code must be in string type please help me if you want, i can give more explainings

2 Answers  

---

How can windows applications connect to oracle servers?

0 Answers  

---

acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account

2 Answers   Polaris,

---

Explain integrity constraint?

0 Answers  

---

How to list all user accounts in oracle?

0 Answers  

---

Differnce between view and index

3 Answers  

---

What is a lookup table in oracle?

0 Answers  

---

Can we create trigger on materialized view in oracle?

0 Answers  

---