Interested to Buy Any Domain ? << Click Here >> for more details...
How to write a query with an inner join in oracle?
- 0 Answers
- 1048 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is a View ?
How to use attributes of the implicit cursor in oracle?
Difference between pre-select and pre-query
How to estimate disk space needed for an export job?
How to export data to a csv file?
What is the function of Redo Log ?
Without giving condition how to retrieve the unmatched records from table.
What is the maximum number of triggers that can be applied to a single table?
What are the arithmetic operations?
One Table having two rows with one colomn having values Like"Male" and "Female". how to upadte these values Like "Female" and "Male" in single update statement.
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 do we display rows from the table without duplicates?
Oracle General 
