用户权限编号类别ORACLEMYSQL注释1创建用户Create user user_name identified by user_passworddefault tablespace starSpace temporary tablespace temp;CREATE USER user_name IDENTIFIED BY user_password;1.oracle创建用户Oracle 的默认用户有..
触发器编号类别ORACLEMYSQL注释1创建触发器语句不同create or replacetrigger TG_ES_FAC_UNITbefore insert or update or deleteon ES_FAC_UNIT for each rowcreatetrigger `hs_esbs`.`TG_INSERT_ES_FAC_UNIT`BEFORE INSERTon `hs_esbs`.`es_fac_un..
函数编号类别ORACLEMYSQL注释1数字函数round(1.23456,4)round(1.23456,4)一样:ORACLE:select round(1.23456,4) value from dualMYSQL:select round(1.23456,4) value2abs(-1)abs(-1)功能:将当前数据取绝对值用法: oracle和mysql用法一样mysql: s..