oracleÔÚÏßÎĵµµØÖ·
Ϊ·ÀÍü¼Ç£¬¼Ç¼ÓÚÏ£º
oracle 11gR2 : http://www.oracle.com/pls/db112/homepage£¬ÏÂÔØÍøÖ·http://www.oracle.com/technology/documentation/database.html
oracle 11gR1 : http://www.oracle.com/pls/db111/homepage
oracle 10gR2 : http://www.oracle.com/pls/db102/homepage
Ïà¹ØÎĵµ£º
´øUNION ALLÎﻯÊÓͼµÄ¿ìËÙË¢ÐÂ
1. ¶¨ÒåµÄ²éѯµÄunion all²Ù×÷±ØÐëÔÚ×µÈ¼¶£¨²éѯÖØдºó£©
2. ÎﻯÊÓͼÈÕÖ¾Ö¸¶¨rowidºÍincluding new values
3. Èç¹û±íÉèÉæ¼°µ½Ò»¸ö´óÁ¿µÄinsert»òÕßÖ±½Ó·¾¶¼ÓÔØ£¬deletes,update£¬Ö¸¶¨sequencea
4. fromÁбí ......
½ñÌìͬÊÂÓöµ½ÁËÒ»¸öÎÊÌ⣬ÔÒòÊÇrownumµÄÎÊÌâ¡£
ÏÂÃæתһƪÎÄÕ£º
¶ÔÓÚOracleµÄrownumÎÊÌ⣬ºÜ¶à×ÊÁ϶¼Ëµ²»Ö§³Ö>£¬>=£¬=£¬between……and£¬Ö»ÄÜÓÃÒÔÉÏ·ûºÅ£¨<¡¢& lt;=¡¢£¡=£©£¬²¢·Ç˵ÓÃ>£¬>=£¬=£¬between……and ʱ»áÌáʾSQLÓï·¨´íÎ󣬶øÊǾ³£ÊDz鲻³öÒ»Ìõ¼Ç¼À´£¬»¹»á³öÏÖË ......
Oracleѧϰ:·ÖÇø±íºÍË÷Òý
http://tech.it168.com/a2009/0609/585/000000585998.shtml
ʲôʱºòʹÓ÷ÖÇø£º
¡¡¡¡1¡¢ ´óÊý¾ÝÁ¿µÄ±í£¬±ÈÈç´óÓÚ2GB¡£Ò»·½Ãæ2GBÎļþ¶ÔÓÚ32λosÊÇÒ»¸öÉÏÏÞ£¬ÁíÍⱸ·Ýʱ¼ä³¤¡£
¡¡¡¡2¡¢ °üÀ¨ÀúÊ·Êý¾ÝµÄ±í£¬±ÈÈç×îеÄÊý¾Ý·ÅÈëµ½×îеķÖÇøÖС£µäÐ͵ÄÀý×Ó£ºÀúÊ·±í£¬Ö»Óе±Ç°Ô·ݵÄÊý¾Ý¿ÉÒÔ±»Ð޸ģ¬ ......
Last login: Mon Feb 8 14:13:19 2010 from 192.168.1.249
ipnet
-bash-3.00$
-bash-3.00$ ipnet
-bash: ipnet: command not found
-bash-3.00$ su - oracle
Password:
eastcsu: incorrect password
-bash-3.00$ eastcom
-bash: eastcom: command not found
-bash-3.00$ su - oracle
Password:
[oracl ......
ת×Ô£ºhttp://hi.baidu.com/66_com
ÒýÑÔ
ÎÒÏÖÔÚËùÔÚµÄÏîÄ¿×éÐèÒª°ÑmysqlµÄÊý¾Ý´¦Àíºóµ¼Èëµ½oracleÊý¾Ý¿âÖУ¬ÔÚ´ËÆÚ¼äÓöµ½ÁËÊý¾ÝÖÐÎÄÂÒÂëÎÊÌâ¡£ÏÂÃæÊÇÎÒ¶ÔÕâ¸öÎÊÌâµÄ×ܽᡣ
1¡¢linux²Ù×÷ϵͳ£¬mysql£¬oracle°²×°Ê±×Ö·û¼¯µÄÑ¡Ôñ¡£
ÎҵĽ¨ÒéÊÇÕâÈýÕßµÄ×Ö·û¼¯±£³ÖÒ»Ö£¬È«Îªutf-8»ògdk»ògb2312¡£Èç¹ûÓÐÌØÊâÒªÇó£¬ÈýÕß²»Í¬Ò² ......