Home » SQL & PL/SQL » SQL & PL/SQL » "rows returned" versus "result set"
"rows returned" versus "result set" [message #266815] Tue, 11 September 2007 12:58 Go to next message
ValerieOKC
Messages: 1
Registered: September 2007
Junior Member
Is there a difference between those 2 terms? If so, what is it?
Re: "rows returned" versus "result set" [message #266821 is a reply to message #266815] Tue, 11 September 2007 13:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"rows returned" are rows returned from a "result set".
You may not fetch all the rows from a result set.

Just my interpretation.

Regards
Michel
Re: "rows returned" versus "result set" [message #266826 is a reply to message #266815] Tue, 11 September 2007 13:18 Go to previous messageGo to next message
Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata
Senior Member

Yes, ofcourse there is a difference.
In the rows returned method you can only get the data of table or views row nothing more than that, but in a result set method after getting the resultset you can gathered the informations about the column name,column type, record count, column count etc.

Cheers
Soumen
Re: "rows returned" versus "result set" [message #266831 is a reply to message #266826] Tue, 11 September 2007 13:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"rows returned" is more than that.
Just have a look at SQL*Plus output, rows is in this case "line" not physical rows.
Or logical for a view. By the way, what difference do you make between "rows" of select and "rows" of view? A view is just a select, no more.

Regards
Michel

[Updated on: Tue, 11 September 2007 13:22]

Report message to a moderator

Re: "rows returned" versus "result set" [message #266834 is a reply to message #266831] Tue, 11 September 2007 13:26 Go to previous message
Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata
Senior Member

I am talking based on the Oracle-Java Rows and ResultSet method.
In terms of pure oracle rows yours is currect one.

Cheers
Soumen
Previous Topic: Need help with understanding sql format
Next Topic: How to Conceal table data like (*****)
Goto Forum:
  


Current Time: Thu Dec 08 04:12:02 CST 2016

Total time taken to generate the page: 0.16101 seconds