| Other SQL PLSQL Interview Questions |
|| Asked @
|What are the new features in Oracle 10g. Compared to Oracle
|SELECT category, type, AVG(price)
FROM products GROUP BY category, type ORDER BY 1, 2
If there are three distinct categories in the "products"
table, and each one has five different types, how many rows
are returned by the query above?
1. 1 row
2. 3 rows
3. 5 rows
4. 8 rows
5. 15 rows
|What are Global Temporary tables
|write a qurey for finding the length of the sting.
|Types of cursors and explanation each of them ?
|How to recompile a already made trigger?
|Difference between NVL, NVL2 and NULLIF
|I want to create synonym for table emp but in my pc it is
giving insufficient previliges.I am using user scott.Please
|suppose we have values like 1 5 7 in a colum.Now we want
numbers like(2 3 4 6) that exists between 1 5 7.How can we
do this using sql query??
|what is the difference between pragma exception_init and
|How to come back in normal stage in Mutating Table if
mutating table is locked or update data?
|How can i insert data inro a table with 3 columns using
|For more SQL PLSQL Interview Questions Click Here |