| Other SQL PLSQL Interview Questions |
|| Asked @
|I want to create synonym for table emp but in my pc it is
giving insufficient previliges.I am using user scott.Please
|| ||3 |
|Can we have exception part in trigger ?
|| ||1 |
|Difference between aggregate function and analytical function?
|type type_name is table of varchar2(30) index by
for the above type you have to create a identifier...
for the above type you can use the below methods..like
first , last , prior, next , delege..etc...like this..
if you create a cursor...like
cursor cursor_name is select * from scott.emp;
is there any methods like above to use prior, fist , last ,
next , trim ,etc...
|What is diff between bulk collect and forall
|What are different types of refreshment techniques of
|| ||2 |
|how to get enames with comma seperated values by deptwise
on emp table?
|| ||5 |
|I want to know last five transactions or records from emp
table, from now?
|What is the diff between Truncate table / delete <table
|how i do the database testing of online money transactions
between two parties (client and organization).
suppose our company makes a website for our client and give
a extra feature of online money transaction with there
clients then how i test this feature in database testing
|| ||1 |
|what is overloading procedure or overloading function ?
|will function return more than one value how
|For more SQL PLSQL Interview Questions Click Here |