How to Truncate Table in Oracle

0 Answers   HCL,

---

What are the different types of failures that occur in Oracle database?

0 Answers   HCL,

---

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 unique key?

14 Answers   Amazon, Cap Gemini, Infosys, Wipro,

---

Which is better Oracle or MS SQL? Why?

2 Answers   Bally Technologies,

---

How view is different from a table?

0 Answers  

---

Explain the difference between replace() and translate() functions in oracle?

0 Answers  

---

What is forall Statement ?

2 Answers   Thermotech,

---

how to produce numbers from 1 to 10 using dual table

4 Answers   Genpact,

---

Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?

1 Answers   IBM,

---

What is PL/SQL ?

3 Answers  

---

How to loop through a cursor variable?

0 Answers  

---