How to find the duplicate rows count from employees table in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
what r routers?
how to i write the query 'NISHI' TO N I S H I
4 Answers Attra, Metric Stream,
What is a nested table?
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.......
What are cursor?where are they used?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How to start a specific oracle instance?
What is STATSPACK tool?
What is the database name in oracle?
Explain the use of file option in exp command.
What WHERE CURRENT OF clause does in a cursor?
What is a data lock in oracle?