| Other SQL PLSQL Interview Questions |
|| Asked @
|overloading of stored procedure is possible in oracle?
|what is difference b/w pravite procedures and public
|pl/sql testing means what ...... explain process how to find pl/sql bugs
|What is the Difference between Procedure and Function.Can we
call a Function in a DML?
|what is difference between pass by value and eference by
value in oracle plsql
|Create a procedure to delete certain records from a table
and display the total number of records deleted in this
process. (Condition for deletion can be of ur choice, for
instance delete all records where eid='')
|Like shown below i have 3 columns(Name,No,Address). The
values in name column i want to modity.
Requirement : Keep only once space between two words
(Fname,Lname) in the Name column.
For this what is the query? Please answer me. Advance
Name No Address Reference
gowri nath -- -- --
|What are different types of refreshment techniques of
|what is purge command
explain about oracle performance tuning
|can i use global variables in stored procedure or function
|Find out the 3rd highest salary?
|I have a small PL/SQL Block
assume in this way
select * from emp where empno=100;
when others then
when no_data_found then
when too_many_rows then
The question which he asked was whether this block will get
executed normally or it will throw error ?
If errored out then what is the reason for the error ?
Could anybody please help me ?
|For more SQL PLSQL Interview Questions Click Here |