| Other SQL PLSQL Interview Questions |
|| Asked @
|ename empno deptno
amar 1 10
akbar 2 20
anthonny 3 30
jonathan 4 40
write a procedure to dispaly the column values ina row
separated by a
eg - input - select ename from emp '|' output -
input - select empno from emp '@' o/p - 1@2@3@4
input - select deptno from emp '/' o/p -
Pls answer this questn.
|how can stop the sequence with mention the max value and
with out mention the max value
|How pl/sql source code can be protected?
|how to retrieve last tree records from table?
select *from emp where rownum > (select count(*)-3 from
i am using this query to get last three records from table
but its not giving any output, so please tell me what is the
error in this query.
|how to remove records from table?
|SQL Tuning, Oracle Server 10g:
Why is the following hint invalid?
SELECT /*+ first_rows parallel(table_name,paral_number)*/
|I have 2 packages A and B. Now package A references Package B
and Package B references Package A. How do you compile such
inter-dependent objects in PL/SQL
|In testing where do we use sql language and how it helps in
|If records are inserted into table without committing.How
to refer to these values in a procedure?
|What are the blocks in stored procedure?
|What is a bitmap index?
|I want to create synonym for table emp but in my pc it is
giving insufficient previliges.I am using user scott.Please
|For more SQL PLSQL Interview Questions Click Here |