1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
|
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.3.0
Connected as mni@parvatI
SQL>
SQL> create table tm(
2 a timestamp,
3 b timestamp(9),
4 c date
5 )
6 /
Table created
SQL> desc tm
Name Type Nullable Default Comments
---- ------------ -------- ------- --------
A TIMESTAMP(6) Y
B TIMESTAMP(9) Y
C DATE Y
SQL> insert into tm values (systimestamp, systimestamp, sysdate)
2 /
1 row inserted
SQL> commit
2 /
Commit complete
SQL> alter table tm modify c timestamp
2 /
Table altered
SQL> desc tm
Name Type Nullable Default Comments
---- ------------ -------- ------- --------
A TIMESTAMP(6) Y
B TIMESTAMP(9) Y
C TIMESTAMP(6) Y
SQL> |
Partager