What is analyze command used for?
No Answer is Posted For this Question
Be the First to Post Answer
How to create a stored procedure in oracle?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
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 purpose of a cluster?
How many types of tables are there in oracle?
What is the difference between normal and corelated subqueries?
What is COST-based approach to optimization ?
How to check your oracle database 10g xe installation?
How to create a new table in your schema?
why dont we assign not null constraint as table level constraint.
What is oracle and what are its different editions?
1.display list of all users from ur data base.what is the query?