Oracle - Whats the difference between PL/SQL and a Cursor?

GeekInterview.com > Tech FAQs > Oracle

Go To First | Previous Question | Next Question

Oracle | Question 8 of 244

Whats the difference between PL/SQL and a Cursor?

Total Answers and Comments: 4

Last Update: August 14, 2007 Asked by: priyanka aoni

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

February 16, 2006 23:07:55

Prasad Meduri

RE: Whats the difference between PL/SQL and a Cursor?

As per my knowledge

PL-SQL is language to devolop scripts for stored procedures functions triggers cursors etc..

Normally we will call it as PL-SQL block( of code).

if you are aware of this fact i can say you have to change your question.

incase if you are unaware of the above comment u can take it.

best wishes

Is this answer useful? Yes | No

November 06, 2006 04:56:57

Vivek Kumar

Whats the difference between PL/SQL and a Cursor?

PL/SQL is the procedure language and structured query language where code is written in block while cursor is a mechanism by which we can assign a name to a select statement and manipulate the information within that SQL statement.

Is this answer useful? Yes | No

August 08, 2007 07:22:35

rakesh.apps

Member Since: August 2007 Contribution: 5

RE: Whats the difference between PL/SQL and a Cursor?

PL/SQL is a procedural language which is used to make set of operations on the database.Actually the code is written in the form of PL/SQL block

And Cursor is a mechanism which is used to retrieve the data(rows) from the table.

Is this answer useful? Yes | No

August 14, 2007 02:00:13

jmriaz

Member Since: May 2007 Contribution: 7

RE: Whats the difference between PL/SQL and a Cursor?

A Pl/SQl is Procedural language extension for SQl.U can do certain things
like creating blocks procedures functions triggers etc..

A cursor is a private work area(or u can say it a place) where the query's will be
analysed executed and it will also hold the result of a query executed.

There are 2 types of cursors 1.Implicit 2.Explicit.

Implicit cursor--is one which will be created by its own and closed by itself
which a programmer does'nt have to do.It is usually created when a query in a pl/sql
block retreives a single row.

Explicit cursor--is one which a programmer has to create it is created when a query in a plsql block retreives more than one row.

Hope this information will be usefull to u.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank