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

Çë½ÌORACLE UTF8ÎÊÌâ

Êý¾Ý¿âÖÐÖÐÎÄÊÇÕý³£µÄ¡£³ÌÐò¶Á³öÀ´£¬ÏÔʾÔÚ¿ØÖÆÌ¨£¬ÊÇÂÒÂë¡£ÇëÎÊʲôԭÒò£¿¶àл
·þÎñÆ÷¶ËºÍ¿Í»§¶ËµÄ×Ö·û¼¯·Ö±ðÊÇʲô£¿


¾ÍÊÇÔÚ·þÎñÆ÷¿ØÖÆÌ¨´òÓ¡³öÀ´µÄ£¬´ÓÊý¾Ý¿âÖжÁ³öÀ´µÄÖÐÎÄÏÔʾ¾ÍÊÇÂÒÂ룬ֱ½ÓÔÚ³ÌÐòÖеÄÖÐÎÄÏÔʾÕý³£

ÔÚ¶ÁÈ¡Êý¾ÝµÄʱºòÊÇ·ñÒª×öÊ²Ã´ÌØÊâ´¦Àí£¿


ÒýÓÃ

ÄãµÄ¿Í»§¶Ë×Ö·û¼¯ºÍ·þÎñÆ÷µÄ²»Ò»ÑùÔì³ÉµÄ,ÐÞ¸ÄÄãµÄ¿Í»§¶Ë×Ö·û¼¯
ÐÞ¸Äoracle¿Í»§¶Ë×Ö·û¼¯£¨±àÂ룩
¹Ø¼ü×Ö: ÐÞ¸Äoracle¿Í»§¶Ë×Ö·û¼¯£¨±àÂ룩

1.´ò¿ª×¢²á±í-regedit



2.ÕÒµ½ÈçÏÂĿ¼£º

HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE -> KEY_OraDb10g_home1



3.Ö´ÐÐsql¡­¡­


²»Éæ¼°µ½¿Í»§¶Ë°¡¡£Êý¾Ý¿â¡¢³ÌÐòÔËÐзþÎñÆ÷¶¼ÊÇͬһ̨·þÎñÆ÷


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

server 2000Êý¾Ý×ªÒÆµ½oracle - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......

oracle֪ʶ - Oracle / »ù´¡ºÍ¹ÜÀí

ÔÚOracle Êý¾Ý¿âÖÐÔõô²éǰÈýÌõ¼Ç¼½µÐò£»
select * from
  (select * from table order by col_name desc)
where rownum<=3;

select * from
(
select s.*,rownum rn 
from t3 s
)
where ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ