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

Oracle¶àÐмǼºÏ²¢/Á¬½Ó/¾ÛºÏ×Ö·û´®µÄ¼¸ÖÖ·½·¨

 ¡¾ÒýÓá¿http://tangshd.blog.sohu.com/96035768.html
Oracle¶àÐмǼºÏ²¢/Á¬½Ó/¾ÛºÏ×Ö·û´®µÄ¼¸ÖÖ·½·¨
 
  ÔõôºÏ²¢¶àÐмǼµÄ×Ö·û´®£¬Ò»Ö±ÊÇoracleÐÂÊÖϲ»¶ÎʵÄSQLÎÊÌâÖ®Ò»£¬¹ØÓÚÕâ¸öÎÊÌâµÄÌû×ÓÎÒ¿´¹ý²»ÏÂ30¸öÁË£¬ÏÖÔھͶÔÕâ¸öÎÊÌ⣬½øÐÐÒ»¸ö×ܽᡣ
   ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name    Type         Nullable Default Comments 
------- ------------ -------- ------- -------- 
COUNTRY VARCHAR2(20) Y                         
CITY    VARCHAR2(20) Y
SQL> select * from test;
COUNTRY              CITY
-------------------- --------------------
Öйú                 ̨±±
Öйú                 Ïã¸Û
Öйú                 ÉϺ£
ÈÕ±¾                 ¶«¾©
ÈÕ±¾                 ´óÚæ
ÒªÇóµÃµ½ÈçϽá¹û¼¯£º
-------    --------------------
Öйú       ̨±±,Ïã¸Û,ÉϺ£
ÈÕ±¾       ¶«¾©£¬´óÚæ
  ʵ¼Ê¾ÍÊǶÔ×Ö·ûʵÏÖÒ»¸ö¾ÛºÏ¹¦ÄÜ£¬ÎÒºÜÆæ¹ÖΪʲôOracleûÓÐÌṩ¹Ù·½µÄ¾ÛºÏº¯ÊýÀ´ÊµÏÖËüÄØ£º£©
  ÏÂÃæ¾Í¶Ô¼¸ÖÖ¾­³£Ìá¼°µÄ½â¾ö·½°¸½øÐзÖÎö£¨ÓÐÒ»¸öÆÀ²â±ê×¼×î¸ß¡ï¡ï¡ï¡ï¡ï£©£º
1.±»¼¯ºÏ×ֶη¶Î§Ð¡Çҹ̶¨ÐÍ Áé»îÐÔ¡ï   ÐÔÄÜ¡ï¡ï¡ï¡ï ÄÑ¶È ¡ï
  ÕâÖÖ·½·¨µÄÔ­ÀíÔÚÓÚÄãÒѾ­ÖªµÀCITY×ֶεÄÖµÓм¸ÖÖ£¬ÇÒ»¹²»ËãÌ«¶à£¬Èç¹ûÌ«¶àÕâ¸öSQL¾Í»áÏ൱µÄ³¤¡£¡£¿´Àý×Ó£º
SQL> select t.country,
  2  MAX(decode(t.c


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

ORACLE SAVE EXCEPTION ×Ó¾ä

½ñÌìÔÚÒ»¸öÌû×ÓÀï¿´µ½shiyiwanµÄ»ØÌûÖÐÌá¼°µ½ÁËÁ½¸ö×Ô¼ºÒÔǰû¼û¹ýµÄ¸ÅÄsave exceptionºÍdml error logging¡£ÉÏÍøËÑÁËËÑÏà¹ØÄÚÈÝ£¬¿´ÁË¿´´ó¸ÅÃ÷°×Òâ˼£¬²»¹ýÔÚʵ¼ÊÔËÓÃÖл¹ÊÇûÔõôÓùý¡£±£´æÏÂÀ´£¬ÒÔºóÓõĵ½µÄ»°·½±ã²éÔÄ¡£
ÕâһƪÊǹØÓÚsave exceptionµÄ£¬ÁíÍâһƪdml error loggingµÄ²Î¼ûÈçÏÂÁ´½Ó
http://blog.csdn ......

Oracle INSERT ALLºÍINSERT FIRST

½ñÌìµÚÒ»´ÎÖªµÀORACLEÔ­À´»¹¿ÉÒÔÕâÑùINSERTµÄ……³¤¼ûʶÁË
Ò»¡¢ÎÞÌõ¼þ INSERT ALL
¶þ¡¢Ìõ¼þ INSERT ALL
Èý¡¢Ìõ¼þ INSERT FIRST
Insert…Select
ʹÓÃInsert SelectʵÏÖͬʱÏò¶à¸ö±í²åÈë¼Ç¼
Ò»¡¢ÎÞÌõ¼þ INSERT ALL
----------------------------------------------------------------------- ......

С²¼ÀÏʦoracleÊÓƵ½²×ù±Ê¼Ç£¨¶þ£©

Oracle Process Structure
Oracle takes advantage of various types of processes:
¡¡—User process: Started at the time a database user requests connection to the Oracle server
  —Server process: Connects to the Oracle instance and is started when a user establishes a session
& ......

oracleÎĵµµÚ¾ÅÕ´¥·¢Æ÷(1)

 µÚ¾ÅÕÂ½Ú :´¥·¢Æ÷±àÂë
    ´¥·¢Æ÷ÊÇ´æ´¢ÔÚÊý¾Ý¿â´æÖÐÒþʽµÄÔËÐлòÕß±»´¥·¢µÄÒ»¶Î³ÌÐò£¬µ±Ä³Ð©Ê¼þ·¢Éú¡£Í¨³£Çé¿öÏ£¬´¥·¢Æ÷ÖÐÖ§³Ö¿ÉÖ´ÐеÄÒ»¶Îpl/sql´úÂë¿é£¬µ±Ò»¸öinsert,update,»òÕßdeleteÃüÃû·¢ÉúÔÚÒ»¸ö±í»òÕßÊÓͼÉϵÄʱºò¡£ÆäÒ²Ö§³ÖϵͳºÍÊý¾Ý¿â»òÕß·½°¸Ê¼þ.oracleÊý¾Ý¿âÒ²Ö§³Ö´¥·¢Æ÷Öк¬Ó ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ