Oracle°²×° - Oracle / »ù´¡ºÍ¹ÜÀí
ÔÚwin7ϰ²×°OracleûÓÐORCL·þÎñ³ÌÐò£¬Çë¸÷λ¸ßÊÖÖ¸µãÖ¸µã°¡£¡
ORACLE°æ±¾ÎÊÌâ,ÀúÊ·Ìù×Ӳο¼ÏÂ....
ÕýÔÚ¼ì²é²Ù×÷ϵͳҪÇó...
ÒªÇóµÄ½á¹û: 5.0,5.1,5.2,6.0 Ö®Ò»
ʵ¼Ê½á¹û: 6.1
¼ì²éÍê³É¡£´Ë´Î¼ì²éµÄ×ÜÌå½á¹ûΪ: ʧ°Ü <<<<
ÎÊÌâ: Oracle Database 11g δÔÚµ±Ç°²Ù×÷ϵͳÖо¹ýÈÏÖ¤¡£
½¨Òé°¸: È·±£ÔÚÕýÈ·µÄƽ̨Éϰ²×°Èí¼þ¡£
========================================================
ÕýÔÚ¼ì²é Service Pack ÒªÇó...
¼ì²éÍê³É¡£´Ë´Î¼ì²éµÄ×ÜÌå½á¹ûΪ: δִÐÐ <<<<
OUI-18001: ²»Ö§³Ö²Ù×÷ϵͳ 'Windows Vista °æ±¾ 6.1'¡£
½¨Òé°¸: Çë°²×°½¨ÒéµÄ Service Pack¡£
========================================================
Çó½â£¡
Ö±½Ó°²×°32λµÄ¾Í¿ÉÒÔÁË¡£²»ÒªÓÃoracle for vistaµÄ¡£
win7ϰ²×°oracleȷʵÎÊÌâ¶à¶à£¬¿´¹ý¼¸¸öÏà¹ØµÄÌû×Ó£¬ÔÚÐéÄâ»úÀïÊÔÑéÁËÏ»¹ÊÇδÄܳɹ¦¡£
²Î¿¼
Òѽâ¾öÁË
ºÇºÇ
ÕÒµ½ refhost.xml Îļþ£¨Î»Öãºdatabase\stage\prereq\db £¬¿ÉÒÔʹÓüÆËã»úµÄËÑË÷¹¦ÄÜ£©£¬´ò¿ª refhost.xml ÅäÖÃÎļþ²¢ÕÒµ½ <CERTIFIED_SYSTEMS> ½Úµã£¬½Ó×ÅÔÚ½ÚµãºóÃæÌí¼ÓÒÔÏÂÄÚÈݲ¢±£´æ¼´¿É£º
<!--Microsoft Windows 7-->
<OPERATING_SYSTEM>
<VERSION VALUE="6.1"/>
</OPERATING_SYSTEM>
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
дPL/SQL·¢ÏÖ,
DBMS_OUTPUT.PUT_LINE(to_date('2010/05/19','yyyy/MM/dd'));
ºǫ́Êä³ö»¹ÊÇ10-05-19
ÎÞÂÛ¸ñʽÔõô¸Ä¶¼ÊÇÕâÑùÊäÈë,²»Ã÷°×°¡!!!
ÓÃDevoloperÀ´¿ª·¢µÄ..
dbms_output.put_line()ÀïÃæµÄ²ÎÊýÊ ......
Ôõôͨ¹ýÃüÁî²é¿´×Ô¼ºÒѾ´´½¨µÄ±í£¿
select tname from tab;
SQL code:
--1.sysÓû§µÇ¼
select table_name
from dba_indexes
where table_owner = 'Óû§Ãû';
--2.ËùÓÐÓû§
select * from tab;
......