shorter to write)
trunc(a)||':'||to_char(trunc(sysdate)+a-trunc(a), 'HH24:MI:SS')
You could get away with using
to_char(a+to_date('31-Dec-00'), 'DD:HH24:MI:SS')
if you can ensure that 1 = a 32
--
T.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tommy Wareing
INET
B.proc_call;
EXCEPTION
WHEN STATE_DISCARDED THEN
B.proc_call;
END;
...
END;
Tedious though...
--
T.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tommy Wareing
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538
too_many_rows then null;
end;
foo(y);
end;
C)
declare
y number;
cursor c is
select x into y from z;
begin
open c;
fetch c into y;
close c;
foo(y);
end;
--
Tommy Wareing
Oxford English Dictionary
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author
in ('A','R','L','2')
and fldchar is not null
order by a.cifkey
can it be optimizer ???
--
T.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tommy Wareing
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego
CPAN.
--
Tommy Wareing
Oxford English Dictionary
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tommy Wareing
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing