归纳下SQL,从最基本的开始:
dba权限登录:sqlplus / as sysdba
创建新用户:create username identified by paddword
删除用户:drop username
对用户进行授权:grant dba/connect/resource/ to username
导出:exp username/password file=:/filename.dmp
导入:imp username/password@orcl touser=touser file=D:/filename.dmp
表空间的操作
1、创建:
create table user_info(
id varchar2 (32)
);
commit;
2、为表空间添加字段:alter table tabName add clumnName
3、修改表空间字段:alter table tabName rename columm colum to newName
4、删除字段:alter table tabName drop columnName
5、插入语句:insert tabname (column...) values(...)
6、修改语句:update tabname set column = newValue where id='??'
7、删除语句:delete from tabname where id='???'