What are the components of logical database structure in oracle database?
No Answer is Posted For this Question
Be the First to Post Answer
Does rowid change in oracle?
Query to retrieve record for a many to many relationship ?
How is it different from a normal table?
Can we insert data in view oracle?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
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 to invoke the data pump export utility?
Explain the use of log option in exp command.
What happens if the imported table already exists?
What is oracle server autotrace in oracle?
How to create a table interactively?
What is key preserved table?