Oralce惯用SQL

Oralce常用SQL
1. 创建表

create table TEST (name varchar(256), type varchar(15),op_time timestamp(6), interval varchar(10));

create table TEST1 as select * from TEST

insert into TEST (name,type,op_time,interval) values ('Rooney','MU',to_timestamp('21-FEB-12 07.42.46.733000000 PM','DD-MON-RR HH.MI.SS.FF PM'),'10')

alter table TEST modify interval varchar(100);

alter table TEST add op_time2 timestamp(6);

describe TEST

@C:\test\test.sql