| Other SQL PLSQL Interview Questions |
|| Asked @
|how to eliminate null values in a column i.e
1 2 3
NULL 3 4
1 5 NULL
i want output like this
1 2 3
i dnt want to use nvl is null and i dnt want replace the
NULL value with any value i.e nvl(col,o);
|Difference between DBMS and RDBMS...CODD's rules
|What is Highwatermark?
|How to find string or key value using pl/sql code?
|How can i insert data inro a table with 3 columns using
|Name the tables where characteristics of Package, procedure
and functions are stored ?
|What is the difference between anonymous block and named
block or stored procedure?
|How do you optimize SQL queries ?
|I want to know the difference between A Record Type and a Table.
|How many null values can be inserted in a coulmn whihc is unique constraint
|I have 2 Databases. How can create a table in particular
database? How can i know the list of tables presented each
database?( in oracle 10g)
|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.
|For more SQL PLSQL Interview Questions Click Here |