????MySQL?????????????Oracle?????????????????????????????????????????У?
????1?????????????磺
????Oracle???
????CREATE OR REPLACE procedure procedure1(TableName in varchar2) is
????MySQL??????
????CREATE procedure procedure1( in  TableName varchar??200??)
????2???????????
????Oracle?????????
????strSQL := ‘update table set field1=1’;
????MySQL??????
????Set StrSQL = ‘update table set field1=1’;????:=??У?
????3. ?Щ?????α??????????
????MySQL????????????α??????????α????????????%ROWTYPE??????????????Oracle?????Щ??????д
?????塢Job?????
????Job??Oracle?????????????????MySQL6????Event????????????ο?MySQL???
??????MySQL?????event????????????????е????????
????1?? ???MySQL???????event scheduler???У????MySql 5.1.6???????????????????SET GLOBAL event_scheduler = ON;??????????????????????my.ini?м???event_scheduler = ON???????
????2?? ????event??????????л???MySQL???????????д?Щ?????data???μ?“??????.err”????????????????????????????????flush log????????????????????event??к??????????my.ini?м????console=TRUE?????????event?????????д??????
????????????????
????Oracle??????????MySQL???н???????????????????????????????
?????????ó???????
??????????????????????o??SQL????????д??????????????????????????????SQL???????????Щ??????????????????????????????????????г???????ο???
????1??Oracle??to_char????????????????????CONCAT(14.3)???????????????ó????????????????д???
????2??Oracle??to_date?????????????????????д???????MySQL?????
????3??Oracle??decode??????????????????SELECT CASE 1 WHEN 1 THEN 'one' WHEN 2 THEN 'two' ELSE 'more' END ?????
????4)nvl???????Щ??ú?????MySQL????е???????
????select nvl(to_char(num)??'nothing') from t_equipment?????
????select case num when num then num else 'nothing' end from t_equipment
????5??instr?????????????????????????????????
????6??Oracle??sysdate?д??sysdate()?????
????7?????????????????????????????????????????xx_pack.xxx?д??xxx()
????8????????????????
????Oracle???TO_NUMBER(strTmp??'XX') TO_NUMBER??’9’??
????MySQL???CONV(strTmp??16??10) CONV(’9’??10??10) ????????????м???????????????????????
????9) ?????????????????е??????????????????????????????
????10???????????????岻????????Oracle??sysdate + 1 ?????sysdate() + interval 1 day????????д??sysdate() + 1 ?????????????????????????
???????select sysdate() + 1 from dual ??MySQL??????? 20080223153234??= 20080223153233 + 1??????
????????Oracle?л?????????????
????11) MySQL??????date?????????????????DATETIME??TIMESTAMP?????????DATE_FORMAT?????????????????
????12??select 'abc' || 'd' from dual ??????????е?????????????????????MySQL?д??selectconcat('abc' ?? 'd')?????
????13) Oracle????????????а????????select???MySQL???????????????????
????14????ЩMySQL?????????????????SQL???????????????????????select RIGHT FROM XX????select a.RIGHT FROM XX a
????15) Oracle????????????????????MySQL???????????????????aa??
????select field1 from (select sysdate() as field1 from dual) as aa