| Other SQL PLSQL Interview Questions |
|| Asked @
|What is the differnce between view and materialized view
|what are pl/sql collections?
|can i give user defined exception in a package
|Difference between a query and strored procedure?
|What is the main difference between a UNION statement and a
UNION ALL statement?
1. A UNION statement eliminates duplicate rows; a UNION
ALL statement includes duplicate rows.
2. A UNION statement can be used to combine any number of
queries; a UNION ALL statement can be used to combine a
maximum of two queries.
3. A UNION statement can only combine queries that have
parallel fields in the SELECT list; a UNION ALL statement
can combine queries with differing SELECT list structures.
4. A UNION statement cannot be used with aggregate
functions; a UNION ALL statement can be used with aggregate
5. There is no difference between the two statements; they
|Does it possible to pass object (or) table as an argument
to a remote procedure?
|What is normalization? dec 2009
|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 ?
|What are Anti joins
|Give the structure of the function ?
|What cursor type do you use to retrieve multiple recordsets?
|how to write utl file pkg in SQL
|For more SQL PLSQL Interview Questions Click Here |