on a daily basis?
The
health of the applications:
- Any
objects with status "INVALID" in DBA_OBJECTS.? Which?
Regards
Jesper
Haure Norrevang
-Oprindelig meddelelse-Fra: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] På vegne af Vidya
KalyanaramanSendt: 8. januar 200
') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesper Haure Norrevang
INET
Title: Meddelelse
Rajesh,
SYSDATE is of datatype DATE (that's what the documentation says), i.e. it
contains century, year, month, day, hour, minute and second (without
decimals).
I have made a little test. FirstIdump a
SYSDATE to see the internal representation. Then Icreate a table with
Title: Meddelelse
Sorry! I was mixingformat-masks. The last SQL should read (i.e.
instead of ):
select to_char(systimestamp, '.MM.DD
HH24:MI:SS.'), dump(systimestamp)
from dual;
/Jesper
-Oprindelig meddelelse-Fra:
[EMAIL PROTECTED] [mailto:[EMAIL