How many types of tables are there in oracle?
"primary key=unique+null" is equal,reson?not,reason?
Explain what are the advantages of views?
What is a Tablespace?
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 much memory your 10g xe server is using?
Anyone have the Latest Oracle Dumbs?While u have please forard to narain1411@gmail.com
What is a user role in oracle?
What are dml statements in oracle?
does the query needs a hint to access a materialized view?
How would you design a database for an e-commerce website?
What is difference between Rename and Alias?
What is the difference between implicit index and explicit index?