How to write a query with a full outer join in oracle?
What do you understand by a database object? Can you list a few of them?
what is trigger?
What is the difference between "as" and "is" in an oracle stored procedure?
How to use regular expression in pattern match conditions in oracle?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
Can the query output be sorted by multiple columns in oracle?
How translate command is different from replace?
select trunc(round(156.00,-1),-1) from dual;
How can we Update a table with out using UPDATE command?
What is oracle database 10g express edition?
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 drop a stored procedure in oracle?