| Other SQL PLSQL Interview Questions |
|| Asked @
|scope of exception handling in plsql
|SELECT emp_num, years, SUM(salary) FROM sales
SELECT emp_id, SUM(takehomepay)
What error is present in the sample code above?
1. Queries being combined with the UNION ALL statement are
not allowed to have SELECT lists with a different number of
2. You are not allowed to use aggregate functions within
two queries joined by a UNION ALL statement.
3. The UNION ALL statement incorrectly combines
the "years" result from the first query with the "SUM
(takehomepay)" result from the second query.
4. Unless the UNION ALL statement is replaced with a UNION
statement, the queries will return duplicates.
5. The "emp_id" column from the second query must be
renamed (or aliased) as "emp_num" so that it corresponds to
the column name from the first query. Otherwise, the
queries will not execute.
|What is oracle ? why we should go for oracle database
instead of diffrent databases available in the industry.
|How can I pass the inner procedure value to outer
|Wat is SGA ?
|What are different types of refreshment techniques of
|if we give update table_name set column_name= default.
what will happen?
its given in pl sql block.what will hapen?
|What are all the difference between Like and Contains ?
|1. what is the exact use of hint in sql.
2. How we can avoid index scan in sql even though index is
there in the table.
|what is meant by tuning and tk proof?
|i have doubt that any one tell ref cursor comes in sql
pl/sql? pls clarify?
|how to find the First and Last Observation from the table:
Ex: OBS Name Sal Ans like: OBS Name Sal
105 E 5000--> 105 E 5000
102 B 2000 104 D 4000
103 C 3000
101 A 1000-->
104 D 4000
|For more SQL PLSQL Interview Questions Click Here |