sqlplus

sys 在oracle中最高权限

解锁scott

alter user scott identified by  tiger account unlock;

scott 用户下有几张表

select * from tab；

连接符的用法：用查询生成批量操作的命令

select ‘drop table ‘||tname||‘;‘ from tab;

SQL> select ‘drop table ‘||tname||‘;‘ from tab;

‘DROPTABLE‘||TNAME||‘;‘
------------------------------------------
drop table BONUS;
drop table DEPT;
drop table EMP;
drop table SALGRADE;

SQL> select * from tab;

TNAME                   TABTYPE    CLUSTERID
------------------------------ ------- ----------
BONUS                   TABLE
DEPT                   TABLE
EMP                   TABLE
SALGRADE               TABLE

SQL> 

sqlplus

标签：nbsp   partition   res   close   ora   rom   tab   bsp   --