How do we display rows from the table without duplicates?
No Answer is Posted For this Question
Be the First to Post Answer
How to convert characters to dates in oracle?
How to create index-by table in oracle?
Can group functions be mixed with non-group selection fields?
How many types of table in Oracle?
Name the three major set of files on disk that compose a database in Oracle?
a query to select maxmun 3 salaries of employee table
how can we store any pdf file in oracle
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 join two tables in a single query using oracle?
What is meant by a deadlock situation?
How to assign values to data fields in record variables?
What is open database communication (odbc) in oracle?