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

ÈçºÎÐ¶ÔØORACLE(ÍêÈ«¾­µä°æ)

Èí¼þ»·¾³£º
1¡¢Windows 2000+ORACLE 8.1.7
2¡¢ORACLE°²×°Â·¾¶Îª£ºC:\ORACLE
ʵÏÖ·½·¨£º
1¡¢¿ªÊ¼£­£¾ÉèÖã­£¾¿ØÖÆÃæ°å£­£¾¹ÜÀí¹¤¾ß£­£¾·þÎñ Í£Ö¹ËùÓÐOracle·þÎñ¡£
2¡¢¿ªÊ¼£­£¾³ÌÐò£­£¾Oracle - OraHome81£­£¾Oracle Installation Products£­£¾ Universal Installer жװËùÓÐOracle²úÆ·£¬µ«Universal Installer±¾Éí²»Äܱ»É¾³ý
5¡¢ÔËÐÐregedit£¬Ñ¡ÔñHKEY_LOCAL_MACHINE\SOFTWARE\ORACLE£¬°´del¼üɾ³ýÕâ¸öÈë¿Ú¡£
6¡¢ÔËÐÐregedit£¬Ñ¡ÔñHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services£¬¹ö¶¯ Õâ¸öÁÐ±í£¬É¾³ýËùÓÐOracleÈë¿Ú¡£
7¡¢ÔËÐÐrefedit£¬Ñ¡ÔñHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application£¬ ɾ³ýËùÓÐOracleÈë¿Ú¡£
8¡¢¿ªÊ¼£­£¾ÉèÖã­£¾¿ØÖÆÃæ°å£­£¾ÏµÍ³£­£¾¸ß¼¶£­£¾»·¾³±äÁ¿ ɾ³ý»·¾³±äÁ¿CLASSPATHºÍPATHÖÐÓйØOracleµÄÉ趨
9¡¢´Ó×ÀÃæÉÏ¡¢STARTUP£¨Æô¶¯£©×é¡¢³ÌÐò²Ëµ¥ÖУ¬É¾³ýËùÓÐÓйØOracleµÄ×éºÍͼ±ê
10¡¢É¾³ý\Program Files\OracleĿ¼
11¡¢ÖØÐÂÆô¶¯¼ÆËã»ú£¬ÖØÆðºó²ÅÄÜÍêȫɾ³ýOracleËùÔÚĿ¼
12¡¢É¾³ýÓëOracleÓйصÄÎļþ£¬Ñ¡ÔñOracleËùÔÚµÄȱʡĿ¼C:\Oracle£¬É¾³ýÕâ¸öÈë¿ÚĿ¼¼°ËùÓÐ×ÓĿ¼£¬²¢´ÓWindows 2000Ŀ¼£¨Ò»°ãΪC:\WINNT£©ÏÂɾ³ýÒÔÏÂÎļþORACLE.INI¡¢oradim73.INI¡¢oradim80.INI¡¢oraodbc.iniµÈµÈ¡£
13¡¢WIN.INIÎļþÖÐÈôÓÐ[ORACLE]µÄ±ê¼Ç¶Î£¬É¾³ý¸Ã¶Î
14¡¢ÈçÓбØÒª£¬É¾³ýËùÓÐOracleÏà¹ØµÄODBCµÄDSN
15¡¢µ½Ê¼þ²é¿´Æ÷ÖУ¬É¾³ýOracleÏà¹ØµÄÈÕÖ¾ ˵Ã÷£ºÈç¹ûÓиö±ðDLLÎļþÎÞ·¨É¾³ýµÄÇé¿ö£¬Ôò²»ÓÃÀí»á£¬ÖØÐÂÆô¶¯£¬¿ªÊ¼Ðµİ²×°£¬°²×°Ê±£¬Ñ¡ÔñÒ»¸öеÄĿ¼£¬Ôò£¬°²×°Íê±Ï²¢ÖØÐÂÆô¶¯ºó£¬ÀϵÄĿ¼¼°Îļþ¾Í¿ÉÒÔɾ³ýµôÁË¡£


Ïà¹ØÎĵµ£º

Oracle SpatialÖеÄOperator²Ù×÷×Ó Ïêϸ˵Ã÷

SDO_FILTER
¸ñʽ£º
    SDO_FILTER(geometry1, geometry2, params);
ÃèÊö£º
    ͨ¹ý¿Õ¼äË÷Òý£¬¸ù¾Ý¸ø¶¨µÄ¼¸ºÎÒªËØ¼ìË÷³ö¾ßÓпռäÏ໥¹ØÏµµÄ¿Õ¼ä¶ÔÏó¡£ÕâÀïµÄ¿Õ¼ä¹ØÏµÊÇÖ¸Á½¸ö¼¸ºÎ²»·ÖÀ룬¼´Non-disjoint¡£¡¾disjoint£º±íʾÁ½¸ö¼¸ºÎµÄ±ßºÍÄÚ²¿¶¼²»Ïཻ¡¿
    Õâ¸öSdo_Fi ......

oracleÈÕÆÚ´¦ÀíÍêÈ«°æ(×ªÔØ)

TO_DATE¸ñʽ
Day:
dd number 12
dy abbreviated fri
day spelled out friday
ddspth spelled out, ordinal twelfth
Month:
mm number 03
mon abbreviated mar
month spelled out march
Year:
yy two digits 98
yyyy four digits 1998
24Сʱ¸ñʽÏÂʱ¼ä·¶Î§Îª£º 0:00:00 - 23:59:59....
12Сʱ¸ ......

Oracle Silent Installations(¾²Ä¬°²×°)


 
Linux Æ½Ì¨ÏÂOracle Silent Installations(¾²Ä¬°²×°)£¬Ò»Ö±¶¼Ã»Óг¢ÊÔ¹ýÓÃÕâÖÖ·½·¨À´×°Êý¾Ý¿â¡£ ÒòΪÓи߼¶µÄ¹¤¾ß£¬¾ÍûÓбØÒªÔÚÀ´ÓÃÕâÖÖ·½·¨ÁË£¬Oracle µÄ½çÃæ»¹ÊDZȽϷ½±ã£¬¶øÇÒÎÒÃÇ»¹ÓÐXmanager ¹¤¾ß£¬ËùÒÔÔÚlinux ÏÂ×°Èí¼þ£¬»¹ÊǺܷ½±ãµÄ¡£
 
Òò´ËÒ²¾ÍûÓÐÌ«ÔÚÒâÕ ......

J2EEÓ¦ÓÃÖÐÓëOracleÊý¾Ý¿âµÄÁ¬½Ó

ÔÚJ2EEÓ¦ÓóÌÐò¿ª·¢ÖУ¬Ó¦ÓóÌÐòÓëÊý¾Ý¿âÁ¬½ÓµÄ½¨Á¢ÊÇÎÒÃǾ­³£Óöµ½µÄÎÊÌâÖ®Ò»¡£ÔÚÕâÀïÎÒÖ÷Ҫ̸̸ÔÚ±¾µØÓ¦ÓóÌÐòÖÐͨ¹ýOCI·½Ê½¡¢thin·½Ê½ºÍJdbcOdbcÇÅ·½Ê½Á¬½ÓOracleÊý¾Ý¿â£¬ÔÚiPlanet Application Server 6.5ºÍSun Java System Application Server 7ÖжÔOracleÊý¾Ý¿âÁ¬½Ó³ØµÄÅäÖÃÒÔ¼°Ó¦ÓÃÖÐÈçºÎ´ÓÁ¬½Ó³ØÖлñµÃÁ¬½Ó
Ò»¡¢±¾µ ......

ORACLE Óë mysql µÄÇø±ð

 1.ÔÚORACLEÖÐÓÃselect * from all_usersÏÔʾËùÓеÄÓû§£¬¶øÔÚMYSQLÖÐÏÔʾËùÓÐÊý¾Ý¿âµÄÃüÁîÊÇshow databases¡£¶ÔÓÚÎÒµÄÀí½â£¬ORACLEÏîÄ¿À´ËµÒ»¸öÏîÄ¿¾ÍÓ¦¸ÃÓÐÒ»¸öÓû§ºÍÆä¶ÔÓ¦µÄ±í¿Õ¼ä£¬¶øMYSQLÏîÄ¿ÖÐÒ²Ó¦¸ÃÓиöÓû§ºÍÒ»¸ö¿â¡£ÔÚORACLE(db2Ò²Ò»Ñù)Öбí¿Õ¼äÊÇÎļþϵͳÖеÄÎïÀíÈÝÆ÷µÄÂß¼­±íʾ£¬ÊÓͼ¡¢´¥·¢Æ÷ºÍ´æ´¢¹ý³ÌÒ² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ