http://taoistwar.javaeye.com/blog/359791
1.连接数据库
(1)直接连接
- conn sys/taoistwar as sysdba;
conn sys/taoistwar as sysdba;
(2)设置数据库ID
- set oracle_sid=xe;
- conn sys/taoistwar as sysdba;
set oracle_sid=xe;
conn sys/taoistwar as sysdba;
(3)直接带数据库ID
- conn sys/taoistwar@xe as sysdba;
conn sys/taoistwar@xe as sysdba;
(4)登录远程数据库ID
- conn yxuser/yxuser@192.168.1.96/yxdb
conn yxuser/yxuser@192.168.1.96/yxdb
2.查询当前用户名
- show user
show user
3.查询所有表
(1)查询当前用户的所有表
- select table_name from user_tables;
select table_name from user_tables;
(2)所有用户的表
- select table_name from all_tables;
select table_name from all_tables;
(3)所有表
- select table_name from dba_tables;
- select table_name from tab;
- select table_name from cat;
select table_name from dba_tables;
select table_name from tab;
select table_name from cat;
4.修改Oracle 10g Express Edition的字符集
- connect system as sysdba ;
- shutdown immediate ;
- startup mount ;
- alter system enable restricted session ;
- alter system set JOB_QUEUE_PROCESSES=0;
- alter system set AQ_TM_PROCESSES=0;
- alter database open ;
- alter database character set internal_use ZHS16GBK ;
- shutdown immediate ;
- startup ;
connect system as sysdba ;
shutdown immediate ;
startup mount ;
alter system enable restricted session ;
alter system set JOB_QUEUE_PROCESSES=0;
alter system set AQ_TM_PROCESSES=0;
alter database open ;
alter database character set internal_use ZHS16GBK ;
shutdown immediate ;
startup ;