Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Access¡¢SQLServer¡¢Oracle³£¼ûSQLÓï¾äÓ¦ÓÃÇø±ð


Access¡¢SQLServer¡¢Oracle³£¼ûSQLÓï¾äÓ¦ÓÃÇø±ð
¹Ø¾¢ËÉ PMP
Èç¹ûÒª¼æÈÝAccess¡¢SQL Server¡¢OracleÈý¸öÊý¾Ý¿â°æ±¾£»ÎÒÃÇÔÚ±àдSQLÓï¾äµÄ¹ý³ÌÖУ¬¾¡Á¿Ê¹ÓÃһЩͨÓõÄÓï¾ä£¬µ«»¹ÊÇÓÐЩ·½ÃæÓÐЩÇø±ð±ÜÃâ²»ÁË£¬ÏÖ¼òµ¥×ܽáһϡ£
ÒÔÏÂA´ú±íAccess,S´ú±íSQL Server,O´ú±íOracle
1¡¢È¡µ±Ç°ÏµÍ³Ê±¼ä
A:Select Now()
S:Select Getdate()
O:Select Sysdate from Dual
¡¡¡¡
2¡¢Á¬½Ó×Ö·û´®
A:&
S:+
O:||
¡¡¡¡
3¡¢×Ö·û´®º¯Êý(½ØÈ¡×Ö·û´®¡¢´óд¡¢Ð¡Ð´¡¢²éÕÒ×Ö·û´®Î»ÖÃ)
A:Mid¡¢UCase¡¢LCase¡¢InStr
S:SubString¡¢Upper¡¢Lower¡¢CharIndex
O:SubStr¡¢Upper¡¢Lower¡¢InStr
4¡¢ÅжÏÈ¡ÖµÓï¾ä
A:IIF
S:Case When Then
O:Decode
¡¡¡¡
5¡¢Ê±¼ä×Ö¶Î
A:ÒªÓÃ#ºÅ·Ö¸ô£¬»òÕßת»»ÎªÈÕÆÚ
¡¡¡¡SELECT * from Books WHERE RegDate = #2007-5-1# »ò
¡¡¡¡SELECT * from Books WHERE RegDate = CDate(’2007-5-1′)
S:¿ÉÒÔÖ±½ÓÓÃ''
¡¡¡¡SELECT * from Books WHERE RegDate = ‘2007-5-1′
O:To_Date
¡¡¡¡SELECT * from Books WHERE RegDate=To_Date('2007-05-01','yyyy-mm-dd')
6¡¢Êý¾ÝÀàÐÍת»»
A:CStr,CInt,CDate
S:Convert,CAST
O:To_Char,To_Number,To_Date
¡¡¡¡
7¡¢Inser Into …..Select …from Óï¾ä
¡¡¡¡Insert Into a(ii,jj,kk) (Select ii,jj,kk from b)
¡¡¡¡ÕâÑùµÄÓï¾ä£¬ÔÚSQL ServerÒÔ¼°OracleÖж¼²»»áÓÐ´í£¬µ«ÔÚAccessÖлᱨ:INSERT INTO Óï¾äµÄÓï·¨´íÎó¡£AccessÓ¦¸Ã°ÑºóÃæSelectÓï¾äµÄÀ¨ºÅÈ¥µô£¬ÈçÏÂ:
¡¡¡¡Insert Into a(ii,jj,kk) Select ii,jj,kk from b
¡¡¡¡Í¬Ê±ÕâÑùдÔÚSQL ServerºÍOracleÖж¼²»»áÓдí
¡¡¡¡
8¡¢¹Ø¼ü×Ö
¡¡¡¡ÓÐЩ×ÖĸÔÚAccess,SQL ServerÖÐÊǹؼü×Ö,ÐèÒªÓÃ[ ]½ç¶¨¿É½â¾öÎÊÌâ,ÀýÈç:at,name
¡¡¡¡
9¡¢±ðÃû
¡¡¡¡SQL ServerºÍOracleÖÐ×Ö¶ÎÆð±ðÃûʱas¿ÉÒÔÊ¡ÂÔ£¬Access²»ÄÜ
¡¡¡¡
10¡¢±íÃûǰ׺
¡¡¡¡Select *,1 from A
¡¡¡¡ÕâÑùµÄÓï¾äÔÚAccess,SQL ServerÖв»»áÓÐ´í£¬µ«ÔÚOracleÖÐÊDz»Ðеģ¬±ØÐëҪд³ÉÕâÑù:
¡¡¡¡Select A.*,1 from A
¡¡¡¡
11¡¢Èç¹ûÓï¾äÖÐÓÐ:(ðºÅ),ÀýÈçÓÐʱ¼ä×ֶεIJéѯ£ºCalcDate=#2008-05-01 11:00:00#,ÔÚAccessÖÐÒ»°ã»á³öÏÖÈçÏ´íÎ󣺲»Õý³£µØ¶¨Òå²ÎÊý¶ÔÏó¡£ÌṩÁ˲»Ò»Ö»ò²»ÍêÕûµÄÐÅÏ¢¡£½«ÏàÓ¦
QueryµÄParamCheck ÉèΪFalse¼´¿É¡£
¡¡¡¡
12¡¢AccessÖеÄÂß¼­ÖµÔÚ¿âÖÐΪ-1ºÍ0,¶øSQL ServerÖÐΪ1ºÍ0,ËùÒÔдBoolField = 1ÕâÑùµÄÓï¾äÓмæÈÝÐÔÎÊÌ⣬


Ïà¹ØÎĵµ£º

oracle µÄÁ½¸öÌæ»»º¯Êý REPLACE TRANSLATE


replace¾ÍÊÇÒ»°ãÒâÒåÉϵÄ×Ö·û´®Ìæ»»£¬translateÖ»ÊÇÒ»¸ö×Ö·ûÌæ»»¶ÔÓ¦µÄÒ»¸ö×Ö·û£¬ÏÂÃæÓÐÊÖ²á˵Ã÷£¬»¹ÓÐÀý×Ó O(∩_∩)O¹þ¹þ~
REPLACE
Syntax
Purpose
REPLACE returns char with every occurrence of search_string replaced with replacement_string. If replacement_string is omitted or null, then all occu ......

OracleÈÏÖ¤½éÉÜ

ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ 
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿â¹ÜÀíÈËÔ±ÉϸڵÄÒÀ¾Ý¡£
Ä¿Ç°ÒѳÉΪ¸÷IT¹«Ë¾¼°Ïà¹ØÆóÒµÕùÏྺƸµÄÊý¾Ý¿â¹ÜÀíά»¤È˲ţ¬ÊÇÊý¾Ý¿âά»¤¹ÜÀíÈËÔ ......

Oracleɾ³ýÓû§±íµÄʵ¼Ê²Ù×÷Ó¦ÓÃ

ÒÔϵÄÎÄÕÂÖ÷Òª½²ÊöµÄÊÇOracleɾ³ýÓû§±íµÄʵ¼Ê²Ù×÷·½°¸£¬±¾ÎÄÖ÷ÒªÊÇÒÔÏà¹Øʵ¼ÊÓ¦ÓôúÂëµÄ·½Ê½À´Òý³öÆäʵ¼ÊµÄ²Ù×÷²½Ö裬ÒÔϾÍÊÇÎÄÕµľßÌåÄÚÈÝÃèÊö£¬ÍûÄãÔÚä¯ÀÀÖ®ºó»áÓÐËùÊÕ»ñ¡£
1.
select 'Drop table '||table_name||';' from all_tables where owner='Ҫɾ³ýµÄÓû§Ãû£¨×¢ÒâÒª´óд£©';

2.Oracleɾ³ýÓû§±í ÒÔÓ ......

hibernate sql²éѯ list


±¾ÎÄתÔØ: http://hi.baidu.com/%D2%BB%C6%F0%C8%A5%CC%DF%C7%F2/blog/item/802027355899fe83a61e12ee.html
ʹÓÃSQLQuery
¶ÔÔ­ÉúSQL²éѯִÐеĿØÖÆÊÇͨ¹ýSQLQuery½Ó¿Ú½øÐеģ¬Í¨¹ýÖ´ÐÐSession.createSQLQuery
()
»ñÈ¡Õâ¸ö½Ó¿Ú¡£×î¼òµ¥µÄÇé¿öÏ£¬ÎÒÃÇ¿ÉÒÔ²ÉÓÃÒÔÏÂÐÎʽ£º
List
cats
=
sess.createSQLQuery
(
......

How to use PL SQL Developer in Ubuntu

You can user PL SQL Developer in Ubuntu like in Windows:
1.download PL/SQL Developer for linux;
2.Install JDK berfore the next;
3.install the PL/SQL Developer;
4.goto the $PL/SQL Developer,run sh sqldeverloper.sh;
5.type the $JDK;
6.then the PL/SQL Developer will startup. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ