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 '
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 :
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