Find out nth highest salary from emp table
Difference between procedure and function.
Whet are the difference between primary key and foreign key?
What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?
Difference between database triggers and form triggers?
Display Odd/ Even number of records
Which datatype is used for storing graphics and images?
What is difference between SQL and SQL*PLUS?
Can you use a commit statement within a database trigger?
What is difference between SUBSTR and INSTR?
Which is more faster - IN or EXISTS?
What is an UTL_FILE.What are different procedures and functions associated with it?
What WHERE CURRENT OF clause does in a cursor?
What is a cursor?
What is the purpose of a cluster?
Difference between an implicit & an explicit cursor.
Differentiate between TRUNCATE and DELETE
There is a % sign in one field of a column. What will be the query to find it?
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
What a SELECT FOR UPDATE cursor represent.
Can a primary key contain more than one columns?
minvalue.sql Select the Nth lowest value from a table
Can a function take OUT parameters. If not why?
Display the number value in Words?
How you will avoid your query from using indexes?
What is difference between Rename and Alias?
What are various joins used while writing SUBQUERIES?
Difference between NO DATA FOUND and %NOTFOUND
What is syntax for dropping a procedure and a function .Are these operations possible?
What are various privileges that a user can grant to another user?
What is OCI. What are its uses?
What is difference between a formal and an actual parameter?
Can the default values be assigned to actual parameters?
Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?
How do you find the number of rows in a Table ?
What are different modes of parameters used in functions and procedures?
How you were passing cursor variables in PL/SQL 2.2?
What is a pseudo column. Give some examples?
Display the records between two range?
What are ORACLE PRECOMPILERS?
How will you delete duplicating rows from a base table?
When do you use WHERE clause and when do you use HAVING clause?
maxvalue.sql Select the Nth Highest value from a table
There is a string 120000 12 0 .125 , how you will find the position of the decimal place?
What is difference between UNIQUE and PRIMARY KEY constraints?
What are various constraints used in SQL?
What are different Oracle database objects?
Explain Difference between database triggers and form triggers?
what is a index?with example? what is subquery with example? what is deadlock in SQL with example? what is cursor advantatage?
How you will avoid duplicating records in a query?
The maximum number of columns a table can have in oracle SQL ?
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
How you open and close a cursor variable.Why it is required?
Explain What is difference between SUBSTR and INSTR?
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?
How to pass cursor variables in PL/SQL 2.2?
What is a view?
Explain What is difference between SQL and SQL*PLUS?
What are cursor attributes?
Explain Which datatype is used for storing graphics and images?
No comments:
Post a Comment