Re: [SQL] FUNCTIONS PROBLEM

2003-03-23 Thread Rajesh Kumar Mallah
CREATE TYPE can be used as well i think in that case "as (val1 int, val2 int, val3 real, val4 char);" need not be done while selecting. regds mallah On Monday 24 Mar 2003 4:48 am, David Witham wrote: > Hi Mario, > > I have used a record type to do this: > > create myfunc() returns record as '

Re: [SQL] FUNCTIONS PROBLEM

2003-03-23 Thread David Witham
Hi Mario, I have used a record type to do this: create myfunc() returns record as ' declare return_val record; col1int; col2int; col3real; col4char; col1 := 5; col2 := 10; col3 :

Re: [SQL] newline character in SQL

2003-03-23 Thread Sethi Tarun-ETS017
Mallah, The "replace" didn't work. The lines still showup on multiple lines. I like to confirm if Oracle (I am using 8.0.6) recognizes the '\n'? Any other ideas from anyone? Appreciate the help. Regards, Tarun -Original Message- From: Rajesh Kumar Mallah [mailto:[EMAIL PROTECTED] Sent