1.select (distinct) valueA ,valueB ... from table,...:
2.别名则在选取后面空格分开,同时要用引号,如:valueA "ColumA" ;
3.连接操作:Select ename || job As "Employee" from emp;
或则 Select ename || " is a " || job As "Employee Detail" from emp;
4.Null 操作: NVL(valueA ,0),此函数可以将Null值转换成将要设定的值;
5.标结构:Describe tableName;
6.GET filename , STS[ART] filename :@filename;
7.比较运算符:= ,> , >= ,< ,<= , <> ,或则 != ,Between ... And ... ,IN , LIke ,(% 代表多个字符, _代表一个字符 , ESCAPE 转义 ) ,IS NULL;
8.ORDER by valueA ,valueB... [asc][desc], 按valueA排序,,然后再按照valueB排序;