How do we create privileges in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
How to convert characters to dates in oracle?
How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?
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 write a query with a left outer join in oracle?
What is a oracle database?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
How to establish administrator authentication to the server?
What is the difference between view and materialized view in Oracle?
What is oracle update statement with inner join ?
What do you mean by cdb and pdb in oracle 12c?
Is oracle an open source?
How to define an oracle sub procedure?