How would you best determine why your MVIEW couldnt FAST
REFRESH?
No Answer is Posted For this Question
Be the First to Post Answer
what are the default admin accounts in Oracle 10g ?
What is Data Dictionary Cache in Oracle?
How to write an inner join with the where clause in oracle?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
what is difference between foreign key and reference key
Explain the different normalization forms?
What is an oracle data file?
Explain the difference between replace() and translate() functions in oracle?
1) Does oracle have any table which contain all the exceptions and it's code internally?
what are the database links ?
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.......