|
Question |
Rating |
View Answer |
|
Difference between NO DATA FOUND and %NOTFOUND |
|
View Answer |
|
What is a cursor for loop? |
|
View Answer |
|
What are cursor attributes? |
|
View Answer |
|
Difference between an implicit & an explicit cursor. |
|
View Answer |
|
What is a cursor? |
|
View Answer |
|
What is the purpose of a cluster? |
|
View Answer |
|
maxvalue.sql Select the Nth Highest value from a table |
|
View Answer |
|
minvalue.sql Select the Nth lowest value from a table |
|
View Answer |
|
How do you find the number of rows in a Table ? |
|
View Answer |
|
Display Odd/ Even number of records |
|
View Answer |
|
Display the number value in Words? |
|
View Answer |
|
Find out nth highest salary from emp table |
|
View Answer |
|
Display the records between two range? |
|
View Answer |
|
Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments? |
|
View Answer |
|
What is a pseudo column. Give some examples? |
|
View Answer |
|
How you will avoid your query from using indexes? |
|
View Answer |
|
What is a OUTER JOIN? |
|
View Answer |
|
Which is more faster - IN or EXISTS? |
|
View Answer |
|
When do you use WHERE clause and when do you use HAVING clause? |
|
View Answer |
|
There is a % sign in one field of a column. What will be the query to find it? |
|
View Answer |