timestamp type column : TIMESTAMP « Data Type « Oracle PL / SQL

1. Oracle PL / SQL
2. Data Type
3. TIMESTAMP

timestamp type column

    
SQL>
SQL>
SQL> create table myTable (ts timestamp);

Table created.

SQL>
SQL> insert into myTable values (sysdate);

1 row created.

SQL>
SQL> select * from myTable;



TS
------------------------------------------------------
26-OCT-09 08.31.47.000000 AM
1 row selected.

SQL>
SQL> drop table myTable ;

Table dropped.

SQL>

   
    
    
    
  

Related examples in the same category