oracle的常用命令

1.给表增加PK的SQL语句
ALTER TABLE 表名 ADD CONSTRAINT 约束名 PRIMARY KEY (字段名);

CREATE TABLE TEM_ORDER AS SELECT * FROM OS_ORDER_ITEM
TRUNCATE TABLE OS_ORDER_ITEM;
ALTER TABLE OS_ORDER_ITEM ADD CONSTRAINT OS_ORDER_ITEM_PK PRIMARY KEY(OS_ORDER_ITEM_ID);
INSERT INTO OS_ORDER_ITEM SELECT * FROM TEM_ORDER T; 

2.获得当前系统时间
select sysdate from dual

评论

1 楼 zhuqx1130 2008-02-15