【笔记】第1、2讲：sql概述
简要笔记：查看当前用户：
SQL> show user
USER is "SYS"
查看dba_users数据字典：
SQL> desc dba_users
Name Null? Type
----------------------------------------- -------- ----------------------------
USERNAME NOT NULL VARCHAR2(30)
USER_ID NOT NULL NUMBER
PASSWORD VARCHAR2(30)
ACCOUNT_STATUS NOT NULL VARCHAR2(32)
LOCK_DATE DATE
EXPIRY_DATE DATE
DEFAULT_TABLESPACE NOT NULL VARCHAR2(30)
TEMPORARY_TABLESPACE NOT NULL VARCHAR2(30)
CREATED NOT NULL DATE
PROFILE NOT NULL VARCHAR2(30)
INITIAL_RSRC_CONSUMER_GROUP VARCHAR2(30)
EXTERNAL_NAME VARCHAR2(4000)
PASSWORD_VERSIONS VARCHAR2(8)
EDITIONS_ENABLED VARCHAR2(1)
AUTHENTICATION_TYPE VARCHAR2(8)
SQL> set lines 200
查看用户名和状态：
SQL> select username,account_status fromdba_users;
USERNAME ACCOUNT_STATUS
------------------------------------------------------------ ----------------------------------------------------------------
SYS OPEN
SYSTEM OPEN
SCOTT OPEN
OUTLN EXPIRED & LOCKED
MGMT_VIEW EXPIRED & LOCKED
FLOWS_FILES EXPIRED & LOCKED
MDSYS EXPIRED & LOCKED
ORDSYS EXPIRED & LOCKED
EXFSYS EXPIRED & LOCKED
DBSNMP EXPIRED & LOCKED
WMSYS EXPIRED & LOCKED
USERNAME ACCOUNT_STATUS
------------------------------------------------------------ ----------------------------------------------------------------
HR EXPIRED & LOCKED
SPATIAL_CSW_ADMIN_USR EXPIRED & LOCKED
SPATIAL_WFS_ADMIN_USR EXPIRED & LOCKED
36 rows selected.
帮助文档查看：
sql---13 SQL Statements:> 状态从EXPIRED & LOCKED改成open：
SQL>>
SQL>alter user hr> 验证
SQL> conn hr/hr
Connected.
SQL> show user;
USER is "HR"
在数据字典user_tables中查看所有的表：
SQL> selectTABLE_NAMEfrom user_tables;
TABLE_NAME
------------------------------------------------------------
JOBS
EMPLOYEES
COUNTRIES
LOCATIONS
DEPARTMENTS
JOB_HISTORY
REGIONS
7 rows selected.
页:
[1]