What do you mean by a tablespace?
No Answer is Posted For this Question
Be the First to Post Answer
What are the trigger associated with image items ?
Query to retrieve record for a many to many relationship ?
Explain implicit cursor.
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 the usage of analyze command in oracle?
What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
how to join query for one source type is oracle another source type is sql server ?
How to assign query results to variables?
How to run create database statement?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How do I learn what codesets are available in oracle?
What is the difference between hot backup and cold backup in oracle?