Why does Oracle not permit the use of PCTUSED with indexes?
No Answer is Posted For this Question
Be the First to Post Answer
What is PL/SQL ?
What are the differences between number and binary_float in oracle?
can we insert any row to dual table if i got the permission from DBA
what is difference between table and view? where to use views? thanks in advance!
What is the difference between postgresql and oracle?
How to use attributes of the implicit cursor in oracle?
What is an oracle table?
I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.
5 Answers Microsoft, Oracle, TCS,
How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?
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.......
Write a trigger example in oracle?
Why do you use stored procedures and state some of its disadvantages?