How to end the current transaction in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
What is an oracle cursor variable?
How to get the Installed Oracle Version Information ?
What does a Control file Contain ?
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 is a database table in oracle?
How to create lov dynamically at runtime & attach to text field?
Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table
What is a tns file?
Explain an exception?
What are the common oracle dba tasks?
What is a Data Dictionary ?
emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example