Hi all,

I want to have difference of two date columns in hours.

For example, I have a table USER_LOG

SQL> DESC USER_LOG
:
:
Call_Log_date DATE
Call_Complete_date DATE


I want difference of above two dates (type is date timestamp) in hours.


Thanks in advance.


_______________________
r e g / m a h e s h b a s a r k a r


-----Original Message-----
From: Justin Cave (DDBC) [mailto:[Email Address Removed]
Sent: Wednesday, March 31, 2004 12:13 PM
To: LazyDBA.com Discussion
Subject: RE: Need a view!!!

So far as I'm aware, table truncations aren't logged anywhere unless you're
doing some sort of auditing.


Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: Thoka, Radhakrishna (GE Transportation, non-ge)
[mailto:radhakrishna.[Email Address Removed]
Sent: Tuesday, March 30, 2004 11:29 PM
To: LazyDBA.com Discussion
Subject: Need a view!!!

Hi

Which view gives information about truncated tables in the database?

Thanks for ur information

Regards
Radhakrishna



--------
Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page