崇尚狼性的专栏

 mysql:        select * from 表名 where pid=0 limit ((当前页-1)*每页显示多少), 每页显示多少oracle:    select * from(      select rownum as rn,source.* from(        sql语句     ) source where rownum    ) result  

1、序列定义       ORACLE:                CREATE SEQUENCE           INCREMENT BY               START WITH            MAXVALUE / NOMAXVALUE           MINVALUE / NOMINVALUE              CYCLE /

1. ASCII: 返回与指定的字符对应的十进制数; SQL> select ascii(A) A,ascii(a) a,ascii(0) zero,ascii() space from dual;     A A ZERO SPACE    --------- --------- --------- ---------    65 97 48  2. CHR:给出整数,返回对应的