| SQL [message #343331] |
Wed, 27 August 2008 00:01  |
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  |
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 #343370 is a reply to message #343346] |
Wed, 27 August 2008 01:32 |
ThomasG
Messages: 3212
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 #343410 is a reply to message #343373] |
Wed, 27 August 2008 04:08 |
ThomasG
Messages: 3212
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 |
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
|
Senior Member |
|
|
| Quote: | I am not satisfied with the answer
|
 ahhh, the unintended humour of the misunderstood arrogance of that statement.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
