ORACLE和POSTGRESQL的SQL语句比较

oracle 方法                                                                 postgreSQL方法
select seqName.nextval from dual                            select nextval('seqname')
select seqName.currval from dual                             select currval('seqname')
long 字段                                                                    TEXT 字段
sysdate                                                                     now()
select row……                                                            select * from tbuser limit 2 offset 1
nvl(…)                                                                        coalesce(name,defaultvalue)
minus                                                                        except
instr(string1,string2)>0                                            position(string2 in string1)>0
decode(fieldname,1,'a','b')                                       (case fieldname when 1 then 'a' else 'b' end)

create table: number                                               create table: numeric
create table: varchar2(… bytes)                              create table: varchar(…)
create table: logging…                                             without logging…

ALTER TABLE DOC_SENDENTITY ADD (                      ALTER TABLE DOC_SENDENTITY ADD 
CONSTRAINT PK_DOC_SENDENTITY_ENTITYID          CONSTRAINT PK_DOC_SENDENTITY_ENTITYID
 PRIMARY KEY                                                             PRIMARY KEY
 (SENDID));"                                                               (SENDID);"
 
CREATE SEQUENCE DOC_SENDENTITYID                   "CREATE SEQUENCE DOC_SENDENTITYID
INCREMENT BY 1 START WITH 0 MAXVALUE                 INCREMENT 1   START 1
1000000000000000000000000000                            MAXVALUE 9223372036854775807
NOCYCLE NOCACHE NOORDER;                                  CACHE 1;"

 

"CREATE INDEX IDX_SENDENTITY_NDOCID                 "CREATE INDEX IDX_SENDENTITY_NDOCID
ON DOC_SENDENTITY(NDOCID)                                    ON DOC_SENDENTITY
LOGGING                                                                      (NDOCID)"

NOPARALLEL;"