What are the set operators union, union all, minus & intersect meant to do?
- 0 Answers
- 554 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
 How to use an oracle sequence generator in a mapping?
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.......
how do get database name at sql prompt?
How can windows applications connect to oracle servers?
what is Single Byte Overhead...?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3
Explain what are the characteristics of data files?
what are pseudocolumns?
How to get execution statistics reports on query statements?
Explain the importance of .pll extension in oracle?
How to turn on or off recycle bin for the session?
How to see free space of each tablespace?
Oracle General 
