Oracle 10g commands start from a bit

1. unlock a user. If the user is not unlocked when the database is installed, the user can be unlocked in sqlplus, for example:

First use sys to log on, and then use alter user account unlock;

2. desc table nameTip: varchar2 () supports international languages;

3. select 10*10 from dual; select sysdate from dual; dual is an empty table for calculation.Double quotation marks are used to save the format. Oracle automatically converts lowercase letters to uppercase letters, and double quotation marks are not converted.

4. Summary of select Syntax: select deptno, max (sal) from emp

Where deptno> 10

Group by deptno

Having max (sal) & gt; 1200

Order by deptno desc;