Oracle数据库常用命令

1.cmd下登录

sqlplus sys/sys as sysdba

默认用户及密码

sqlpuls scott/tiger as sysdba

2.查看当前连接数据库的用户

show user

3.用户的切换

(1)切换管理员

conn sys/sys as sysdba;

(2)查看都有哪些表

select * from tabs;

(3)查看表、结构

select * from tab;

desc tab;

(4)跨用户查看表

select * from user.tab