OCM实验-创建含特殊字段类型的表

创建具有ROWID及时间戳类型字段的表并插入数据.这个实验很简单

首先，我们需要建一个具有rowid 以及时间戳字段的表

TESTDB@PROD>create table t1 (text rowid,insert_time timestamp with local time zone);

Table created.

其次，向该表中插入一些数据

TESTDB@PROD>insert into t1 select rowid,current_timestamp from t where rownum < 200;

199 rows created.

查询表中数据

TESTDB@PROD>select * from t1;

TEXT               INSERT_TIME
------------------ ---------------------------------------------------------------------------
AAADB+AAIAAAAAUAAA 28-JAN-14 09.10.55.882652 AM
AAADB+AAIAAAAAUAAB 28-JAN-14 09.10.55.882652 AM
AAADB+AAIAAAAAUAAC 28-JAN-14 09.10.55.882652 AM
AAADB+AAIAAAAAUAAD 28-JAN-14 09.10.55.882652 AM
AAADB+AAIAAAAAUAAE 28-JAN-14 09.10.55.882652 AM
AAADB+AAIAAAAAUAAF 28-JAN-14 09.10.55.882652 AM
AAADB+AAIAAAAAUAAG 28-JAN-14 09.10.55.882652 AM
AAADB+AAIAAAAAUAAH 28-JAN-14 09.10.55.882652 AM
AAADB+AAIAAAAAUAAI 28-JAN-14 09.10.55.882652 AM
AAADB+AAIAAAAAUAAJ 28-JAN-14 09.10.55.882652 AM
AAADB+AAIAAAAAUAAK 28-JAN-14 09.10.55.882652 AM

TEXT               INSERT_TIME
------------------ ------------------------------

这个实验相对简单很多了。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11590946/viewspace-1076122/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11590946/viewspace-1076122/