Explain the difference between replace() and translate() functions in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
How to Truncate Table in Oracle
What is a Private Synonyms ?
can any one help me with import/export options in oracle............
What is the difference between substr and instr?
interview questions with answer for cts
I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.
What is the difference between a vector and an Array? (Java)
What is a cluster?
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 are the predefined tablespaces in a database?
What is hot backup and logical backup?
What are the different types of modules in oracle forms?