|
Question |
Rating |
View Answer |
|
What is difference between SUBSTR and INSTR? |
|
View Answer |
|
What is difference between SQL and SQL*PLUS? |
|
View Answer |
|
Find out nth highest salary from emp table |
|
View Answer |
|
Difference between an implicit & an explicit cursor. |
|
View Answer |
|
There is a string 120000 12 0 .125 , how you will find the position of the decimal place? |
|
View Answer |
|
What should be the return type for a cursor variable.Can we use a scalar data type as return type? |
|
View Answer |
|
What is a pseudo column. Give some examples? |
|
View Answer |
|
What is OCI. What are its uses? |
|
View Answer |
|
maxvalue.sql Select the Nth Highest value from a table |
|
View Answer |
|
When I have 6 values for any column, in select statement I get display of 6 rows selected while if I have 5 values for one column i don't get display of 5 rows selected, how to get that display? |
|
View Answer |
|
Which datatype is used for storing graphics and images? |
|
View Answer |
|
Can a primary key contain more than one columns? |
|
View Answer |
|
Difference between NO DATA FOUND and %NOTFOUND |
|
View Answer |
|
table name stud,a mark 23,b mark 87,c mark 75,d mark 34; write the query to find 2nd highest mark in stud table? |
|
View Answer |
|
Difference between procedure and function. |
|
View Answer |
|
Display Odd/ Even number of records |
|
View Answer |
|
What is an UTL_FILE.What are different procedures and functions associated with it? |
|
View Answer |
|
minvalue.sql Select the Nth lowest value from a table |
|
View Answer |
|
What are various joins used while writing SUBQUERIES? |
|
View Answer |
|
What is difference between Rename and Alias? |
|
View Answer |