[SQL] how can i return multiple values from a function

2001-09-27 Thread srinivas 

i have tried retrieving multiple values using setof function but i
couldnt solve it.when i am trying using setof iam getting this as
output.
 

  1 CREATE FUNCTION hobbies (varchar) RETURNS SETOF bank
  2 AS 'SELECT * FROM bank
  3  '
  4 LANGUAGE 'sql';


~
output:  
select hobbies('srinivas') as col;
col
---
 137462096
 137462096
(2 rows)

please let me know what is the alternative and if possible with a sample
piece of code.

cheers
chowdary.


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

[SQL] Finding table constraints

2002-10-23 Thread Jadcharla Srinivas 



Hi  , 
I have a small doubt , if any one knows how to know Constraints of a table in Oracle9i , won't you please tell me  Warm Regards
Jadcharla SrinivasViipurinkatu 1C 86,00510 HELSINKI,FINLAND.Phone:358408208487(Moblie)Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site