| Other SQL PLSQL Interview Questions |
|| Asked @
|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.
|Types of joins ?
|What is Referential Integrity?
|Can i possible to see Table Details ?
Table Name Date Time User
Emp May/18/2010 12:59pm Scott
|Types of cursors and explanation each of them ?
|If we have n no of columns in a table, can we add new
column in that table with not null constraint?
|How will you select unique values from a list of records?
|can we delete the trigger in a view? if yes why if not why?
|what is global temporary tables and how use that tables in
|What is the default value of CHAR type?
|can i use global variables in stored procedure or function
|what is Hash join?how it is different from inner join?what
is the sign used for inner join?(eg: like the (+) sign used
for outer join)?
|For more SQL PLSQL Interview Questions Click Here |