oracle online documentation
oracle 9i online documentation:
http://www.oracle.com/pls/db92/db92.docindex?remark=homepage
oracle 10g online documentation:
http://www.oracle.com/pls/db102/homepage
oracle 11g online documentation:
http://www.oracle.com/pls/db111/homepage
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
centos 4.5Ï°²×°oracle 9204
Linux localhost.localdomain 2.6.9-55.ELsmp
Ò»£¬½âѹËõOracle9204µÄ°²×°Îļþ
1£® Oracle 9iR2 (9.2.0.4)
(1) ¼ò»¯¹ý³Ì£¨ÒÔoracleµÇ¼£¬ÊÍ·Å°²×°Îļþ,ʹÓøüÉٵĴÅÅ̿ռ䣬Ëٶȸü¿ì£©
ÔÚ°²×°LINUXʱ×îºÃ·ÖÒ»¸öÇø/orasetup,ÕâÑùÒ»À´¼´Ê¹ÏµÍ³»µÁË,Ò²Ö»ÊÇÖØװϵͳ,¶øÎÞÐëÖØÐ ......
1¡¢Ð´BATÎļþ
------------------------------------------------------------------------------------------------------
if "%time:~0,1%"==" " (set backup_file=%date:~0,4%%date:~5,2%%date:~8,2%-0%time:~1,1%%time:~3,2%%time:~6,2%) else (set backup_file=%date:~0,4%%date:~5,2%%date:~8,2%-%time:~0,2%%time: ......
Oracle¼à¿Ø¹¤¾ß¸ÅÀÀ
Kaya ·¢±íÓÚ os2ora.com
дÁËLinuxÉϵļà¿ØÓë·ÖÎö¹¤¾ß
Ö®ºó£¬Ð´Ð´OracleÉÏÏàÓ¦µÄ¼à¿ØÓë·ÖÎö¹¤¾ß»¹ÊÇͦÓÐÒâ˼µÄ£¬Ò»·½Ãæ¿ÉÒÔ¸ü¼ÓÍêÕû£¬Ò»·½Ãæ¿ÉÒÔ½øÐкáÏò¶Ô±È¡£
LinuxÉϵÄÐÔÄÜÊý¾ÝÒ»°ã¶¼À´×ÔÓÚ/procÎļþϵͳ£¬¶øOracleÔòÊÇÀ´×ÔÓÚV$ÊÓͼ¡£Òò´Ë£¬ËùÓеÄOracle¼à¿Ø¹¤¾ßµÄʵÏÖ¶¼Íò±ä²»Àë
V$
ÊÓͼ¡ ......
ÔÎĵØÖ·£ºhttp://www.cnblogs.com/yf520gn/archive/2009/01/12/1374359.html
EXISTSµÄÖ´ÐÐÁ÷³Ì
select * from t1 where exists ( select null from t2 where y = x )
¿ÉÒÔÀí½âΪ:
for x in ( select * from t1 )
loop
if ( exists ( select null from ......