#1. dba_users;
describe dba_users;
名称 类型 是否为空值?
USERNAME VARCHAR2 NOT NULL
USER_ID NUMBER NOT NULL
PASSWORD VARCHAR2
ACCOUNT_STATUS VARCHAR2 NOT NULL
LOCK_DATE DATE
EXPIRY_DATE DATE
DEFAULT_TABLESPACE VARCHAR2 NOT NULL
TEMPORARY_TABLESPACE VARCHAR2 NOT NULL
CREATED DATE NOT NULL
PROFILE VARCHAR2 NOT NULL
INITIAL_RSRC_CONSUMER_GROUP VARCHAR2
EXTERNAL_NAME VARCHAR2
PASSWORD_VERSIONS VARCHAR2
EDITIONS_ENABLED VARCHAR2
AUTHENTICATION_TYPE VARCHAR2
SELECT * FROM dba_users where password=null;
describe dba_users;
名称 类型 是否为空值?
USERNAME VARCHAR2 NOT NULL
USER_ID NUMBER NOT NULL
PASSWORD VARCHAR2
ACCOUNT_STATUS VARCHAR2 NOT NULL
LOCK_DATE DATE
EXPIRY_DATE DATE
DEFAULT_TABLESPACE VARCHAR2 NOT NULL
TEMPORARY_TABLESPACE VARCHAR2 NOT NULL
CREATED DATE NOT NULL
PROFILE VARCHAR2 NOT NULL
INITIAL_RSRC_CONSUMER_GROUP VARCHAR2
EXTERNAL_NAME VARCHAR2
PASSWORD_VERSIONS VARCHAR2
EDITIONS_ENABLED VARCHAR2
AUTHENTICATION_TYPE VARCHAR2
SELECT * FROM dba_users where password=null;