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

oracleÁ¬½ÓÔ¶³ÌÊý¾Ý¿â

D:\oracle\product\10.2.0\db_2\NETWORK\ADMIN
6¡¢ÐÞ¸Äoracle°²×°Â·¾¶ÏÂD:\oracle\product\10.2.0\db_2\NETWORK\ADMIN\tnsnames.oraµÄtnsnames.oraÎļþ£¬Ìí¼Ó
XXX =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.12.42)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = poµÄ)
    )
  )
×¢£ºÒòoracleµÄ°²×°Â·¾¶²»Í¬£¬ÉÏÊö·¾¶¿ÉÄܲ»Í¬£¬ÊÓÇé¿ö¶ø¶¨¡£
CPSΪPL/SQL DeveloperÁ¬½ÓÔ¶³ÌÊý¾Ý¿âʱǰ̨ÏÔʾµÄÊý¾Ý¿âÃû³Æ£¬¿ÉÈÎÒⶨÒå
192.168.12.42 ΪҪÁ¬½ÓÔ¶³ÌÊý¾Ý¿âµÄIPµØÖ·
portal ΪԶ³ÌÁ¬½ÓÊý¾Ý¿âµÄʵÀýÃû³Æ


Ïà¹ØÎĵµ£º

oracle 9i/10g°²×°°üºÍPATCHÏÂÔصØÖ·»ã×Ü

oracle 9i/10g°²×°°üºÍPATCHÏÂÔصØÖ·»ã×Ü
°ÑÏÂÃæµÄµØÖ·¸´ÖƵ½Ñ¶À×Àï¾Í¿ÉÒÔÏÂÔØ.
---------------------------------------------------------------------------------------------------
ORACLE 9i
Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP
http://download.oracle ......

±±´óÇàÄñoracleѧϰ±Ê¼Ç3


»¹ÊǽèÖúoracle sql developerÀ´²Ù×÷oracle£¬sql plus»¹ÊÇÂé·³Ò»µã¡£
¼òµ¥¿´ÁËһϣ¬Óï¾ä»ù±¾É϶¼ºÍÆäËûÊý¾Ý¿âµÄsql²î²»¶à£¬¼Ç¼һϲ»Í¬µÄµØ·½¡£
ÈÕÆÚÀàÐͱ༭
update student set stu_birthday = to_date('2010-03-06 13:14:20','yyyy-MM-dd HH24:mi:ss');
ÐèҪʹÓÃto_date()º¯Êý£¬SQLÖв»Çø·Ö´óСд£¬MMºÍmm± ......

OracleÖм¸¸ö¹ØÓÚÈÕÆÚ·½ÃæµÄSQLʵÀý

¡í1:È¡µÃµ±Ç°ÈÕÆÚÊDZ¾Ôµĵڼ¸ÖÜ
SQL> select to_char(sysdate,'YYYYMMDD W HH24:MI:SS') from
dual;

TO_CHAR(SYSDATE,'YY
-------------------
20030327 4 18:16:09

SQL> select to_char(sysdate,'W') from dual;

T
-
4 ......

±±´óÇàÄñoracleѧϰ±Ê¼Ç12


¹ØϵÐÍÊý¾Ý¿âÀíÂÛÖÐ×Ö¶ÎÖµ±ØÐëÊǵ¥Öµ£¬¶øoracleÖÐÔÊÐíÔÚÒ»¸ö×Ö¶ÎÖд洢һ¸ö±íµÄÄÚÈÝ¡£
È磺Ա¹¤±íÖеÄÍâ¼ü ²¿ÃűàºÅ£¬oracleÖÐÕâ¸ö×ֶοÉÒÔ´æ·Å²¿ÃŵļǼ¶ø²¢²»ÊÇÒ»¸öÍâ¼ü£¬ÕâÑù²éѯʱºòµÄЧÂÊ»áÌá¸ß¡£
¿É±äÊý×飺
´´½¨´øÓпɱäÊý×éµÄ±í
´´½¨¿É±äÊý×é»ùÀàÐÍ
create or replace type »ùÀàÐÍÃû as object(×Ö¶ÎÇåµ¥); ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ