oracle数据库常用命令
1、解锁用户
命令:alter user scott account unlock;
以管理员用户进入数据库
2、查询表结构:
desc dba_users;
3、查询所有用户状态:
select username accountstatus from dba_users;
4、修改用户密码:
alter user scott identified by oracle;
5、oracle sqlplus清屏命令:
host cls-----clea scre-----clean screen---
6、查询表结构:
select column_name,data_type,data_length,data_precision,data_scale from user_tab_columns where table_name='TFA_ALARM_ACT1'
7、修改字段类型:
alter table tfa_gaia_rule_sub_alarm modify (relation varchar2(1024));