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

Çë½ÌORACLE UTF8ÎÊÌâ

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


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

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


ÒýÓÃ

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

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



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

HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE -> KEY_OraDb10g_home1



3.Ö´ÐÐsql¡­¡­


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


Ïà¹ØÎÊ´ð£º

Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

ÇóÒ»sqlÓï¾ä - Oracle / ¿ª·¢

Á½¸ö±í
Çë¿´ "Persons" ±í£º
name banji shunxu
yiyang 01 1
yiyang 02 1
lili 01 2
  
½ÓÏÂÀ´Çë¿´ "xueke" ±í£º
name kemu shunxu
yiy ......

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ºÅ