oracleÏòmysqlÒÆÖ²
ÓÐһЩûÓÐʹÓÃÊý¾Ý¿âÖмä¼þµÄÈí¼þ¿ÉÄÜ»áÅöµ½ÔÚ²»Í¬µÄÓ¦Óó¡¾°ÐèÒªÓò»Í¬µÄÊý¾Ý¿â£¬ÕâÑù¿ÉÄܾÍÐèÒª½«Êý¾Ý¿â´úÂë×öÒÆÖ²£¬ÎÒÕâÀïÕûÀíÁËһЩ´Óoracleµ½mysqlµÄÒÆÖ²¹ý³ÌÖеÄ×¢ÒâÊÂÏ
1¡£sequenceÉú³É
¿ÉÒÔÓÃÀàËƵĶ«Î÷À´×ö,ÈçÏ£º
create table myseq ( seq varchar(8));
insert into myseq values('0');
update myseq set seq = last_insert_id(seq+1);
select last_insert_id();
ÕⶫÎ÷ÍêÈ«¸úoracleµÄsequenceÒ»Ö¡£¼´Ê¹ÔÚupdateÖ®ºó£¬select֮ǰÓÐÆäËüsessionÒ²updateÁË£¬±¾sessionµÃµ½µÄ£¬ÈÔÈ»ÊÇ×Ô¼ºupdateµÄÄÇÒ»¸öÖµ¡£
2¡£sysdateתΪsysdate()
3.substr×°»»£¬»ù±¾²»ÐèҪת»»
4¡£nvlת»»Îªifnull
5¡£Êý×Öת»»Îª×Ö·û´®µÄto_charº¯Êý²»Óã¬Ö±½ÓÓü´¿É£¬²»Óú¯Êýת»»
6¡£ÈÕÆÚ¸ñʽµÄto_charת»»Îªdate_format
oracle: to_char(sysdate,'yyyy-mm-dd hh24:mi:ss')
mysql: select date_format(now(),'%Y-%m-%d %H-%i-%S')
7.to_date()×°»»£¬É¾³ýת»»£¬mysqlÖ§³Ö×Ô¶¯×ª»»
8¡£decode£¨£©×ª»»£¬
case when flag=0 then '³É¹¦' else 'ʧ°Ü' end
9¡£rownumת»»£¬·Öҳת»»
querySql = "select * from ( select rownum rnm, a.* from ( " + strQuery
// + ") a where rownum <= " + getPageEndRow()
//+ ") where rnm > " + getPageStartRow();
ת»»Îª£º
querySql = "select * from ( select 1 rnm, page_a.* from ( " + strQuery
+ ") page_a LIMIT " + getPageStartRow() + "," + getPageSize() + " ) select_page";
10¡£from×Ó²éѯת»»£¬Îª×Ó²éѯ¶¨Òå±ðÃû
select count(*) from (
select a.login_no,a.LOGIN_NAME,a.EXPIRE_TIME,b.orgname,a.CONTRACT_PHONE,a.info_flag,a.login_level,a.group_id from DLOGINMSG a left outer join dchngroupinfo b on a.group_id=b.orgno where 1=1 and a.login_no like '%test%'
) subselect
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
linuxÏÂoracle°²×°£º
Oracle¹«Ë¾Ðû³ÆÔÚLinuxÏ°²×°Oracle9iÊý¾Ý¿âÖÁÉÙÒªÓÐ512MBµÄÄÚ´æºÍÖÁÉÙ1GB»òÕßÁ½±¶
ÄÚ´æ´óСµÄ½»»»¿Õ¼ä£¬¶ÔÓÚϵͳÄÚ´æ´óÓÚ2GBµÄ·þÎñÆ÷£¬½»»»¿Õ¼ä¿ÉÒÔ½éÓÚ2GB—4GBÖ®¼ä¡£
Èç¹ûÊÇΪÁËÔÚһ̨½öÓÐ256MÄÚ´æµÄÆÕͨPC»úÉÏÊÔÓÃOracle9 ......
´ó¼Ò¶¼ÖªµÀ£¬ÓÃPL/SQLÁ¬½ÓOracle£¬ÊÇÐèÒª°²×°Oracle¿Í»§¶ËÈí¼þµÄ¡£ÓÐûҪÏë¹ý²»°²×°Oracle¿Í»§¶ËÖ±½ÓÁ¬½ÓOracleÄØ£¿
ÆäʵÎÒÒ»Ö±ÏëÕâÑù×ö£¬ÒòΪÕâ¸ö¿Í»§¶ËʵÔÚÌ«ÈÃÈËÌÖÑáÁË£¡£¡£¡²»µ«»á°²×°Ò»¸öJDK£¬¶øÇÒ»¹»á°Ñ×Ô¼º·ÅÔÚ»·¾³±äÁ¿µÄ×îÇ°Ã棬»áÔì³É²»Ð ......
Êý¾Ý¿â´æ´¢ÖеÄÊý¾ÝÀàÐÍÓë´óС¸÷Òì¡£ÓÐЩµØ·½Ö»´æ´¢Êý×ÖÀàÐÍ£¬ÓÐЩֻ´æ´¢Îı¾ÀàÐÍ£¬ÓÐЩ¶þÕ߶ø¼æÖ®¡£¶øºÜ¶àÊý¾Ý¿âÖ§³Ö¸÷ÖÖרÓÃÀàÐÍ£ºÈÕÆÚºÍʱ¼äÀàÐÍ£¬¶þ½øÖÆ×Ö·ûÀàÐÍÒÔ¼°²¼¶ûÀàÐÍ¡£Ñ¡ÔñÊý¾ÝÀàÐÍÓëÊý¾ÝÏàÆ¥ÅäÊÇÊý¾Ý¿âÉè¼ÆÖÐ×îΪÖØÒªµÄ²¿·Ö£¬ÒòΪÕâÖÖÀàÐͽ«»áÓ°Ïìµ½RDBMSµÄЧÂÊÓëÐÔÄÜ¡£ËùÒÔ£¬¶ÔRDBMSµÄÊý¾ÝÀàÐÍÑ¡ÔñÓ¦ ......
MySqlÊý¾Ý¿âµ¼³öcsvÎļþÃüÁ
mysql> select first_name,last_name,email from account into outfile 'e:\\output1.csv' fields terminated by ','optionally enclosed by ''lines terminated by '\n';
csvÎļþЧ¹û£º
sunny
Grigoryan
lovechoosesun@gmail.com
Jon
Siegal
sun@riliantech.net
Joe
S ......