Re: OT: Perl module question

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

Re: explain plan

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

Re: Different behavior of Too_many_rows exception in pl/sql betwe

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

Re: Invalid packages not being recompiled by Oracle

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

Re: Date / Time

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