What is the difference between "as" and "is" in an oracle stored procedure?
No Answer is Posted For this Question
Be the First to Post Answer
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
What is SYSTEM tablespace and When is it Created?
Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL
what is candidate key & super key
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?
What are named parameters?
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 difference difference between $ORACLE_HOME and $ORACLE_BASE.
What are the major difference between truncate and delete?
What is an UTL_FILE.What are different procedures and functions associated with it?
What is a Public Synonyms ?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?