Friday, 21 March 2014

How to create table with system time stamp?

CREATE TABLE X(x1 TIMESTAMP);
Table created.

SQL> INSERT INTO x VALUES (SYSTIMESTAMP);
1 row created.

SQL> SELECT * FROM x;
x1
---------------------------
23-FEB-14 7.32.47.797201 PM


Thanks 
Ur's Hari 

No comments:

Post a Comment