Watch the Oracle video notes of Shang xuetang

Watch the Oracle video note of Shang xuetang 1. go to sqlplus: Method 1.c:\ Users \ Dell> sqlplus sys/sys as sysdba; method 2.C: \ Users \ Dell> sqlplus/nolog/* Start sqlplus */SQL> connect sys/sys as sysdba; /* connect to the database */method 3.C: \ Users \ Dell> sqlplus \ nolog; /* you will be asked to enter the password */method 4. SQL> conn sys @ orcl as sysdba/* after entering sqlplus \ nolog */The General connection format is SQL> conn user name/password; or SQL> connect user name/password; 2. view the current user: SQL> show USER; Result: user is "SYS" 3. view All parameter names: SQL> show parameters name; 4. format the display result (using show parameters name; as an example): Method 1: SQL> column name for 999,999; SQL> column type for a999; SQL> column value for 999; method 2 (recommended): SQL> set linesize 9999 SQL> set heading off;/* disable header information such as NAME, TYPE, VALUE */set the number of lines displayed on each page: SQL> set pagesize 30; 5. view the current database name: SQL> show parameter db_name; 6. user unlock: SQL> alter user scott account unlock; 7. query the table information of a user: SQL> select TABLE_NAME from user_tables; 8. simple query of table information: SQL> select * from dept; SQL> select * from emp; 9. clear Oracle screen in Window: Method 1. SQL> host cls method 2. SQL> clear screen; Method 3. SQL> clea scre; Method 4. SQL> clear scr;/* DOS environment */