i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify

Advertise your Business Here

Refer this Site

Login | Sign Up


	Do you have a collection of Interview Questions and interested to share with us!! Please send that collection to along with your userid / name. ThanQ

Categories >> Software >> Databases >> SQL PLSQL

Oracle Interview Questions

SQL Server Interview Questions

MS Access Interview Questions

MySQL Interview Questions

Postgre Interview Questions

Sybase Interview Questions

DB Architecture Interview Questions

DB Administration Interview Questions

DB Development Interview Questions

SQL PLSQL Interview Questions

Databases AllOther Interview Questions

Question

i have doubt that any one tell ref cursor comes in sql
pl/sql? pls clarify?

Question Submitted By :: Nagapawan

I also faced this Question!!

Rank

Answer Posted By

Re: i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?

Answer
# 1

Ref cursor comes in PL/SQL.
You can return a ref cursor in a function.
A ref cursor is useful while returning more values.

Is This Answer Correct ?

4 Yes

0 No

Raghu

Re: i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?

Answer
# 2

Hi ,

It will use in PL/SQL. Reusability of Cursor is nothing 
but "REF CURSOR".These are of 2 types.

1. Weak Ref cursor 2. Strong ref Cursor.

Is This Answer Correct ?

3 Yes

0 No

Sureshkumar Somayajula

Question	Asked @	Answers
Other SQL PLSQL Interview Questions


diff b/w function and procedure?	iFlex	6
Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?	eBay	2
what is a sub query?how will you calculate working days in a month using sub query?	InteQ	3
When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?		2
what is inline view?		4
How the execution will be done in exceptions?		2
How packaged procedures and functions are called from the following?		1
can we create index on index?	iFlex	3
What is magic table?		5
how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used	UST	4
Write a query to get 2nd maximum salary in an employee table ?	TCS	20
What are two parts of package ?	Infosys	2
what is the command for user data type?		2
What is Raise_application_error ?		1
what is variable in package specification		2
How One can easily select all even, odd, or Nth rows from a table using SQL queries?		3
What is TABLE SPACE?	ABB	2
Does SQL*Plus contains pl/sql Engine?	TCS	1
What is the difference between sql/pl-sql/embeded sql?		2
1 SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c, dtable d 3 ? 4 ORDER BY 1 What is the minimum number of joins that must be specified on line 3 in the sample code above to properly link the tables? Notice that the table "atable" is aliased twice: once as "a" and once as "b." 1. One join 2. Two joins 3. Three joins 4. Four joins 5. Five joins	Sonata	3

For more SQL PLSQL Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com