David, try setting numwidth in sqlplus...
(for example)
1* create table dtest (col1 varchar2(20), col2 number(20))
SQL> /
Table created.
SQL> insert into dtest values('8888888888888888888','88888888888888888888');
1 row created.
SQL> select * from dtest;
COL1 COL2
-------------------- ----------
8888888888888888888 8.8889E+19
SQL> set numwidth 20
SQL> /
COL1 COL2
-------------------- --------------------
8888888888888888888 88888888888888888888
SQL>
>>> [EMAIL PROTECTED] 03/05/03 02:29PM >>>
I try to query a report to check user activity but I could not read date
column. Is there a way to reformat the column to be readable? Date colum
calls "time_stamp" as shown below.
SQL> desc user_activity_log
Name Null? Type
----------------------------------------- -------- --------------
TIME_STAMP NOT NULL NUMBER(20)
NODE_NAME NOT NULL VARCHAR2(20)
USER_NAME NOT NULL VARCHAR2(20)
CLIENT_IP NOT NULL VARCHAR2(15)
DESCRIPTION NOT NULL VARCHAR2(2048)
SQL> select user_name,client_ip,node_name,time_stamp from user_activity_log
where user_name = 'admin'
order by time_stamp;
USER_NAME CLIENT_IP NODE_NAME TIME_STAMP
-------------------- --------------- -------------------- ----------
admin NA Insight Server 1.0397E+12
admin NA Insight Server 1.0402E+12
admin NA Insight Server 1.0433E+12
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Darrell Landrum
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
