Home » Other » Training & Certification » SQL
SQL [message #343331] Wed, 27 August 2008 00:01 Go to next message
ygsunilkumar
Messages: 100
Registered: August 2008
Senior Member
What are two methods of retrieving SQL?
Re: SQL [message #343342 is a reply to message #343331] Wed, 27 August 2008 00:32 Go to previous messageGo to next message
flyboy
Messages: 1903
Registered: November 2006
Senior Member
I would be interested too, as the only way for retrieving SQL executed in database I know is querying V$SQL view (directly or using some tool extracting that).

But maybe you wanted to ask something totally different.
My bet is on "how to retrieve data for an application using stored procedure". But, this is just a wild guess.
Re: SQL [message #343346 is a reply to message #343342] Wed, 27 August 2008 00:38 Go to previous messageGo to next message
ygsunilkumar
Messages: 100
Registered: August 2008
Senior Member
I am not satisfied with the answer. Somewhere I read that two methods are Select and Cursor. Any please tell me the correct answer.

[Updated on: Wed, 27 August 2008 00:38]

Report message to a moderator

Re: SQL [message #343370 is a reply to message #343346] Wed, 27 August 2008 01:32 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Since neither "select" nor "cursor" are "methods to retrieve SQL" I'm not satisfied with your question either.

Please ask a question that makes sense.
Re: SQL [message #343373 is a reply to message #343370] Wed, 27 August 2008 01:38 Go to previous messageGo to next message
ygsunilkumar
Messages: 100
Registered: August 2008
Senior Member
Small correction in Question.
The Question is What are two methods of retrieving data?
Re: SQL [message #343410 is a reply to message #343373] Wed, 27 August 2008 04:08 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Retrieving data from where to where in what context.

At the low-level database level for example there are different methods Oracle used to retrieve data from the data files, for example db file scattered read or db file sequential read.

At the SQL level there is basically only one way to retrieve the result data, namely FETCH.

Then there are dozens of different ways to retrieve data in the PL/SQL level, like cursors, arrays, etc....

And still dozen more ways to retrieve data on the network / driver level.

You need to give more information about in what context your question is asked.

Re: SQL [message #343488 is a reply to message #343346] Wed, 27 August 2008 07:14 Go to previous message
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
Senior Member
Quote:
I am not satisfied with the answer
Laughing ahhh, the unintended humour of the misunderstood arrogance of that statement.
Previous Topic: Suggestion OCA certification
Next Topic: 1Z1-146
Goto Forum:
  


Current Time: Thu Mar 28 23:34:55 CDT 2024