Oralce惯用SQL

Oralce常用SQL
1. 创建表

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

2.复制表

create table TEST1 as select * from TEST

3.插入数据

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')

4.修改column类型

alter table TEST modify interval varchar(100);

5.增加column

alter table TEST add op_time2 timestamp(6);

6.描述table

describe TEST

7.执行sql脚本

@C:\test\test.sql