(1) create table ( column1 varchar2(n) ,
column1 number(p,s),
column1 date
)
desc table_name;
alter table table_name modify(column1 datatype);
alter table table_name add ( column1 datatype);
(2) drop table table_name:
rename table_name1 to table_name2
truncate table table_name;
(3) 相关的数字字典
user_tables ;
user_objects;
user_catalog;
all_tab_comments;
comment on table table_name is ' table_name2 ';
(4) 约束条件
alter table table_name enable constraint constraint_name;
alter table table_name disable constraint constraint_name;
alter table table_name drop constraint constraint_name;
(5) create user user_name identified by password;
alter user user_name identified by password;
grant privilege ( 系统权限) to user ; -- select ,update ,delete ,session ,
-- role_sys_privs 查询角色系统权限
revoke create table from user_name;
(6) enterprise manager EM 这个来管理Oracle
http://计算机名:prot/em
(4) to_date
& 变量名 : 需要输入的值
sysdate ;
commit
savepoint name;
Rollback to savepoint;
(5) 约束
constraint constraint_name unique(column);
not null ;
constraint constraint_name Primary key(column);
constraint constraint_name _FK foreign key (column1) Reference table2(column2) ;
(6)