[oracle@oracledb~]sqlplus /nolog --运行sqlplus命令,进入sqlplus环境,nolog参数表示不登录;
SQL> connect system/system as sysdba 或者
SQL> connect /as sysdba --以系统管理员(sysdba)的身份连接数据库;
SQL> startup(2)启动监听
[oracle@oracledb~]lsnrctl start
(3)启动管理平台
[oracle@oracledb~]emctl start dbconsole
(4)停止数据库
[oracle@oracledb~]sqlplus /nolog
SQL> connect system/system as sysdba
SQL> shutdown
(5)停止监听
[oracle@oracledb~]lsnrctl stop
(6)停止管理平台
[oracle@oracledb~]emctl stop dbconsole
SQL> shutdown immediate #关闭数据库实例
SQL> select * from tab; #查看所有表
SQL> select name from v$datafile #查看数据库存放目录
SQL> show parameter service #查看服务名
SQL> select * from v$instance; #查看实例名
SQL> select name from v$database; #查看数据库名
SQL> select * fromdba_users; #查看所有用户信息
SQL> select username,password from dba_users; #只查询用户和密码
SQL> select * fromv$pwfile_users; #查看具有sysdba权限的用户
SQL> select * fromdba_ustats; #查看当前用户信息
SQL> select * fromuser_sys_privs #查看当前用户系统权限
SQL> select * fromuser_role_privs #查看当前用户角色
SQL> select * fromdba_sys_privs #查看指定用户所具有的系统权限
SQL> select * fromv$version #查看oracle版本
SQL> select * fromuser_views #查看视图信息
SQL> show user //查看当前登录的用户名
USER is "SYS"
SQL> alter user sys identified by 123456; //更改用户密码
User altered.
SQL> describe student; //查看表结构
Name Null? Type
----------------------------------------- -------- ----------------------------
STUDENT_ID NOT NULL NUMBER
STUDENT_NAME VARCHAR2(20)
STUDENT_AGE NUMBER
查询当前用户的所有表的三种方法:
SQL> select table_name from tabs; //第一种
TABLE_NAME
------------------------------
STUDENT
HVR_STINLIANLU02_ODB02
HVR_STISLIANLU02_ODB02
HVR_STBULIANLU02_ODB02
SQL> select table_name from user_tables; //第二种
TABLE_NAME
------------------------------
STUDENT
HVR_STINLIANLU02_ODB02
HVR_STISLIANLU02_ODB02
HVR_STBULIANLU02_ODB02
SQL> select tname from tab; //第三种
TNAME
------------------------------
BIN$YMOePJEo4wvgUKjAFgOPyg==$0
BIN$YMOePJEs4wvgUKjAFgOPyg==$0
BIN$YNJ1p99VWxzgUKjAFgOeoQ==$0
BIN$YNJ1p99fWxzgUKjAFgOeoQ==$0
BIN$YNJ1p99lWxzgUKjAFgOeoQ==$0
BIN$YNJyvto/JQbgUKjAFgOeew==$0
BIN$YNJyvto1JQbgUKjAFgOeew==$0
BIN$YNJyvtpFJQbgUKjAFgOeew==$0
HVR_STBULIANLU02_ODB02
HVR_STINLIANLU02_ODB02
HVR_STISLIANLU02_ODB02
TNAME
------------------------------
STUDENT
12 rows selected.
SQL>
SQL> select table_name from all_tables where owner='HVR'; //查询某用户名下的所有表,单引号中的用户名要大写
TABLE_NAME
------------------------------
STUDENT
HVR_STINLIANLU02_ODB02
HVR_STBULIANLU02_ODB02
HVR_STISLIANLU02_ODB02