Oracle(version 11g)
regedit = 注册表 control = 控制面板 sqlplus = 让我们和数据库进行沟通的工具
用户:
system scott
连接/切换用户:
conn 用户名/密码; conn system/etoak;
SQL = Structured Query Language = 结构化查询语言
DDL = Data Definition Language = 数据定义语言
create创建 alter修改 drop删除 truncate截断
DML = Data Manipulation Language = 数据操控语言
insert增加 delete删除 update更新
DQL = Data Query Language = 数据查询语言
select 查询
DCL = Data Control Language = 数据控制语言
grant授权 revoke 取消授权
TCL = Transaction Control Language = 事务控制语言
commit 提交 rollback 回滚 savepoint 保存点
给用户解锁:
alter user scott account unlock;
给用户加锁:
alter user scott account lock;
给用户授权:
grant dba to scott;
给用户取消授权:
revoke dba from scott;
创建新用户:
create user ET2302 identified by eroak;
给用户修改密码:
alter user ET2302 identified by et;
删除用户:
drop user ET2302;
查看当前用户:
show user;
退出sqlplus:
exit;