Home » SQL & PL/SQL » SQL & PL/SQL » question on return function
question on return function [message #191610] Thu, 07 September 2006 05:24 Go to next message
lohi
Messages: 2
Registered: July 2006
Junior Member
hi,

plz anybody tell me the ans for this question

difference between -

select * from tablename; and select * from tablename; return

Re: question on return function [message #191613 is a reply to message #191610] Thu, 07 September 2006 05:29 Go to previous messageGo to next message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
well, return will raise an error.
try it and see Wink
Re: question on return function [message #191633 is a reply to message #191613] Thu, 07 September 2006 06:42 Go to previous messageGo to next message
lohi
Messages: 2
Registered: July 2006
Junior Member
when given select * from tablename; - displayed all the rows.

now if we give select * from tablename; return - displayed all rows.

but if we give any sql stmt after the qury which used return it is not functioning.

select * from employees; return
select * from employees

if given like this displaying the table only once.
if given select * from employees;
select * from employees; return
select * from orders;

only emp table displayed.

so,plz can u explain clearly.

Re: question on return function [message #191643 is a reply to message #191633] Thu, 07 September 2006 07:42 Go to previous messageGo to next message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
What the heck are you doing?
Are you hitting thr return key or typing the word "return?"
Re: question on return function [message #191645 is a reply to message #191633] Thu, 07 September 2006 07:53 Go to previous message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
Quote:

so,plz can u explain clearly.

Not until you can.

Please post a copy and paste of your session and what you are doing
Previous Topic: Import Data, Sequence still at 1
Next Topic: SQL culmalative balance
Goto Forum:
  


Current Time: Thu Dec 08 14:34:39 CST 2016

Total time taken to generate the page: 0.09990 seconds