文档介绍:oracle:
1、利用伪列号来查询中间列和后几列:
后几列:SELECT fkfs,(SELECT mc FROM  w_jsfs WHERE dm = ) mc , COUNT(*) FROM y_khda t GROUP BY fkfs;
中间列:select * from (select rownum row_id ,wjm ,czsj ,czy FROM c_zwrz) where row_id between 5 and 9;
2、翻页的SQL语句的处理
语句一:
SELECT ID, [FIELD_NAME,...] FROM TABLE_NAME WHERE ID IN ( SELECT ID FROM (SELECT ROWNUM AS NUMROW, ID FROM TABLE_NAME WHERE 条件1 ORDER BY 条件2) WHERE NUMROW > 80 AND NUMROW < 100 ) ORDER BY 条件3;
 
语句二:
SELECT * FROM (( SELECT ROWNUM AS NUMROW, c.* from (select [FIELD_NAME,...] FROM TABLE_NAME WHERE 条件1 ORDER BY 条件2) c) WHERE NUMROW > 80 AND NUMROW < 100 ) ORDER BY 条件3;
3、
表达式:
数字表达式符号:+ - * / **
DECLARE
  result INTEGER;
BEGIN
     result := 10+3*4-20+5**2;
     ('运算结果:'||to_char(result));
     ('');
END;
字符表达式符号:||
关系表达式符号:< > = like in <= >= != between
逻辑表达式:not or and
函数:to_char to_date to_number
mit rollback savepoint
其savepoint的用法:
执行处理语句;
savepoint thispoint;
继续其他的处理语句;
rollback to thispoint;(回滚到定义thispoint处)
继续运行;
自治事务:
8i以上版本,不影响主事务。
在存储过程的is\as
后面声明PRAGMA AUTONOMOUS_TRANSACTION;
自治事务防止嵌套提交,使事务在自己的事务区内提交或回滚不会影响其他的事务。
函数的一些用法
SELECT c.*,SYSDATE,upper(concat('liu','nihao')) a,
instr('liuqiuanyi','i',1,2) b,lpad('liu',8,'hi!') c,
rtrim('   liuquanyi    ',' ') d,TRIM('liu quan yi') e,
REPLACE('you love me!','you','i') AS f,
translate('you love meu!','you',