create one table to capture an employee details with a primary key.

1 Answers   CTS,

---

What is bulk load in oracle?

0 Answers  

---

how to delete all duplicate records from a table using subquery?

7 Answers   ABC, Cap Gemini,

---

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,

---

How to create tables for odbc connection testing?

0 Answers  

---

What is the use of Redo Log Information ?

2 Answers  

---

Without giving condition how to retrieve the unmatched records from table.

1 Answers   TCS,

---

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

0 Answers  

---

How to sort the query output in oracle?

0 Answers  

---

What are the uses of synonyms?

0 Answers  

---

How to assign query results to variables?

0 Answers  

---

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

0 Answers  

---