-- ·|­û / µù¥U -- ¡@
¡@±b¸¹¡G
¡@±K½X¡G
¡@ | µù¥U | §Ñ°O±K½X
3/14 ·s®Ñ¨ì¡I 12/12 ·s®Ñ¨ì¡I 12/5 ·s®Ñ¨ì¡I 11/30 ·s®Ñ¨ì¡I
ÁʮѬyµ{¡EQ & A¡E¯¸°È¯d¨¥ª©¡E«ÈªA«H½c
¢x 3ds Max¢x Maya¢x Rhino¢x After Effects¢x SketchUp¢x ZBrush¢x Painter¢x Unity¢x
¢x PhotoShop¢x AutoCad¢x MasterCam¢x SolidWorks¢x Creo¢x UG¢x Revit¢x Nuke¢x
¢x C#¢x C¢x C++¢x Java¢x ¹CÀ¸µ{¦¡¢x Linux¢x ´O¤J¦¡¢x PLC¢x FPGA¢x Matlab¢x
¢x Àb«È¢x ¸ê®Æ®w¢x ·j¯Á¤ÞÀº¢x ¼v¹³³B²z¢x Fluent¢x VR+AR¢x ANSYS¢x ²`«×¾Ç²ß¢x
¢x ³æ´¹¤ù¢x AVR¢x OpenGL¢x Arduino¢x Raspberry Pi¢x ¹q¸ô³]­p¢x Cadence¢x Protel¢x
¢x Hadoop¢x Python¢x Stm32¢x Cortex¢x Labview¢x ¤â¾÷µ{¦¡¢x Android¢x iPhone¢x
¥i¬d®Ñ¦W,§@ªÌ,ISBN,3dwoo®Ñ¸¹
¸Ô²Ó®ÑÄy¤ÀÃþ

Oracle 11g³]­p»P¶}µo±Ðµ{

( ²Åé ¦r)
§@ªÌ¡G±ä¥ÉµY ¾GªFÁø ¨v¼ä ±i¥ßªNÃþ§O¡G1. -> ¸ê®Æ®w -> Oracle
ĶªÌ¡G
¥Xª©ªÀ¡G²MµØ¤j¾Ç¥Xª©ªÀOracle 11g³]­p»P¶}µo±Ðµ{ 3dWoo®Ñ¸¹¡G 33859
¸ß°Ý®ÑÄy½Ð»¡¥X¦¹®Ñ¸¹¡I

¡i¦³®w¦s¡j
NT°â»ù¡G 295 ¤¸

¥Xª©¤é¡G9/28/2012
­¶¼Æ¡G533
¥úºÐ¼Æ¡G0
¯¸ªø±ÀÂË¡G
¦L¨ê¡G¶Â¥Õ¦L¨ê»y¨t¡G ( ²Åé ª© )
¥[¤JÁʪ«¨® ¢x¥[¨ì§Úªº³Ì·R
(½Ð¥ýµn¤J·|­û)
ISBN¡G9787302291152
§@ªÌ§Ç¡@|¡@ĶªÌ§Ç¡@|¡@«e¨¥¡@|¡@¤º®e²¤¶¡@|¡@¥Ø¿ý¡@|¡@§Ç
(²Åé®Ñ¤W©Ò­z¤§¤U¸ü³sµ²¯Ó®É¶O¥\, ®¤¤£¾A¥Î¦b¥xÆW, ­YŪªÌ»Ý­n½Ð¦Û¦æ¹Á¸Õ, ®¤¤£«OÃÒ)
§@ªÌ§Ç¡G

ĶªÌ§Ç¡G

«e¨¥¡G

¤@¡B Ãö¤_¥»®Ñ
ÀHµÛ­pºâ¾÷À³¥Î§Þ³Nªº¨³²rµo®i¡A¼Æ¾Ú®w§Þ³N¤]¦b¤é·s¤ë²§¡A³n¥ó¦æ·~¹ï¼Æ¾Ú®wºÞ²z¨t²Îªº©Ê¯à¡B¦w¥þ©Ê¡B¥i¾a©Êµ¥¤è­±ªº»Ý¨D¤]ÀH¤§¼W±j¡COracle¼Æ¾Ú®w¥H¨ä±j¤jªº¥\¯à¡B«K±¶ªº¾Þ§@¡B¥i¾aªº©Ê¯àµ¥¯SÂI¦b¼Æ¾Ú®w»â°ì¤¤±o¨ì¤F¼sªxªºÀ³¥Î¡A¦}űo¤F¬üÅA»P«H¥ô¡C
·í«e¥«³õ¤WÃö¤_Oracle¼Æ¾Ú®w¤è­±ªº®ÑÄy«Ü¦h¡Aµ¹Oracleªº¾Ç²ßªÌ±a¨Ó¤F¤è«K,¦ý¬O¥HOracle 11g¬°°ò¦Á¿¸ÑOracle¼Æ¾Ú®wÀ³¥Î¤ÎºÞ²z¦}¥B¾A¦X§@¬°±Ð§÷ªº®ÑÄy¦}¤£¦h¨£¡C½sªÌ®Ú¾Ú¦h¦~ªºOracle¹ê½î¸gÅç¤Î¤@½u±Ð¾Ç¸gÅç½s¼g¤F¥»±Ð§÷¡A§Æ±æ¯àµ¹Oracleªº¾Ç²ßªÌ´£¨Ñ°Ñ¦Ò¡C
¤G¡B ¥»®Ñ¯à¤O¥Ø¼Ð
³q¹L¥»®Ñªº¾Ç²ß¡AŪªÌ¦bOracle¼Æ¾Ú®w¨Ï¥Î¤è­±¯à°÷¹F¨ì¥H¤U¯à¤O¥Ø¼Ð¡G
’õ ´x´¤Ãö¨t¼Æ¾Ú®wªº°ò¥»²z½×¤Î³]­p¤èªk¡C
’õ ´x´¤SQL»y¨¥©MPL/SQL»y¨¥¡C
’õ ´x´¤Oracle 11gªº³]­p©MºÞ²z¤èªk¡C
’õ ¨ã¦³³Ð·s¯à¤O¡B©Ý®i¾Ç²ßOracleªº¯à¤O¡C
’õ ¨ã¦³¹ï¼Æ¾Ú®wºÞ²z¹Lµ{¤¤¹J¨ìªº°ÝÃDµ¹¥X¸Ñ¨M¤èªk¤Î«Øijªº¯à¤O¡C
’õ ¨ã¦³Oracle¼Æ¾Ú®wºÞ²z­ûªº°ò¥»Â¾·~¯À½è¡C
¤T¡B ¥»®Ñ¤º®e²Õ´
¥þ®Ñ¥D­n¤À¬°¤T¤j³¡¤À¡A«ö·Ó¤º®e¼Ò¶ô²Õ´³¹¸`¡A¦U­Ó³¹¸`¤§¶¡´`§Çº¥¶i¡A¬J¬Û»²¬Û¦¨¤S¬Û¹ï¿W¥ß¡AŪªÌ¥i¥H®Ú¾Ú¦Û¤vªº»Ý­n¦³¿ï¾Ü¦a¾\Ū©M¨Ï¥Î¡C
²Ä¤@³¡¤À¤¶²Ð¼Æ¾Ú®w°ò¦²z½×¤Î¼Æ¾Ú®w³]­p¡A¦@¦³3³¹¡C
²Ä1³¹¡A¼Æ¾Ú®w¨t²Î·§­z¡A¤¶²Ð¼Æ¾Ú®w¨t²Îªº¬ÛÃö·§©À¤ÎÅé¨tµ²ºc¡C
²Ä2³¹¡AÃö¨t¼Æ¾Ú®w³]­p²z½×¡A¥D­nÁ¿¸Ñ¼Æ¾Ú¼Ò«¬¡BÃö¨t¼Ò«¬¤ÎÃö¨t¼Æ¾Ú®w³W­S¤Æ²z½×¡C
²Ä3³¹¡A¼Æ¾Ú®w³]­p¡A¤¶²Ð¼Æ¾Ú®w³]­p¡A¥]¬A·§©Àµ²ºc³]­p¡BÅÞ¿èµ²ºc³]­p¡Bª«²zµ²ºc³]­p¡A¼Æ¾Ú®wªº¹ê¬I¡B¹B¦æ©MºûÅ@¡C
²Ä¤G³¡¤À¤¶²ÐOracle°ò¦¡A¥D­n¥]¬ASQLªº¨Ï¥Î¡BOracle¨Æ°ÈºÞ²z¡BPL/SQL°ò¦¤Î°ª¯Å½sµ{µ¥¡A¦@¦³9³¹¡C
²Ä4³¹¡A¦w¸ËOracle¡A¤¶²Ð¦w¸ËOracleªº·Ç³Æ¤u§@¤Î¦p¦ó¦w¸Ë¡B¼Æ¾Ú¦r¨åµ¥¡C
²Ä5³¹¡ASQL*Plus¡A¥]¬A¦p¦ó¨Ï¥Îsqlplus©R¥Oµn¿ý¨ì¼Æ¾Ú®w¤ÎSQL*Plus±`¥Î©R¥O¡C
²Ä6³¹¡ADDL©MDML¡A¥D­n¤¶²ÐOracleªº¼Æ¾ÚÃþ«¬¤Î¦p¦ó³Ð«Øªí¡B­×§ïªíµ²ºc¡A¦p¦ó¹ï¼Æ¾Ú¶i¦æ¦UºØ¾Þ§@¡C
²Ä7³¹¡A¬d¸ß»y¥y¡A¥]¬A³æªí¬d¸ß¡B¦hªí³s±µ¬d¸ß¡B¤l¬d¸ß©M¶°¦X¹Bºâ¡C
²Ä8³¹¡AOracle¨Æ°ÈºÞ²z¡A¥D­n¤¶²Ð¨Æ°Èªº°ò¥»·§©À¡B¨Æ°Èªº³B²z¾÷¨î¤Î¦}µo±±¨î¡C
²Ä9³¹¡A¼Ò¦¡¹ï¶H¡A¥D­n¤¶²Ðµø¹Ï¡B¦P¸qµü¡B§Ç¦C¡B¯Á¤Þ¡B¤À°Ïªí¡BÁ{®Éªíµ¥¼Ò¦¡¹ï¶H¡C
²Ä10³¹¡A±`¥ÎSQL¨ç¼Æ¡A¥]¬A¦r²ÅÃþ¨ç¼Æ¡B¼Æ­ÈÃþ¨ç¼Æ¡B¤é´ÁÃþ¨ç¼Æ¡BªÅ­È³B²z¨ç¼Æ¡BÂà´«Ãþ¨ç¼Æ¡B¨ä¥L±`¥Î¨ç¼Æµ¥¡C
²Ä11³¹¡APL/SQL°ò¦¡A¥D­n¤¶²ÐPL/SQLªº°ò¦·§©À¤ÎÀ³¥Î¡C
²Ä12³¹¡APL/SQL°ª¯Å½sµ{¡A¤¶²Ð¦p¦ó¦sÀx¤lµ{§Ç¤Î¥]¡BIJµo¾¹ªºÀ³¥Îµ¥¡C
²Ä¤T³¡¤À¬OOracleªº°ª¯ÅÀ³¥Î©MºÞ²z¡A¦@¦³4³¹¡C
²Ä13³¹¡A Oracle¥þ²y¤Æ¤ä«ù¡A¥D­n¦³°ê®a»y¨¥¤ä«ù¡BOracle¤¤ªº¦r²Å¶°¡B±`¥ÎªºNLS°Ñ¼Æ¡C
²Ä14³¹¡AOracleªº±Ò°Ê©MÃö³¬¡A¥]¬A¦p¦ó³Ð«Ø©M°t¸m°Ñ¼Æ¤å¥ó¡B±Ò°Ê¼Æ¾Ú®w¤ÎÃö³¬¼Æ¾Ú®w¡C
²Ä15³¹¡AOracleªºÅé¨tµ²ºc¡A¥HOracle¹ê¨Ò¤¶²Ð¨äª«²z¦sÀxµ²ºc©MÅÞ¿è¦sÀxµ²ºc¡C
²Ä16³¹¡AOracleªº¦w¥þºÞ²z¡A¥]¬A¥Î¤áºÞ²z¡BÅv­­ºÞ²z¡B¨¤¦âºÞ²z©M·§­n¤å¥óºÞ²z¡C
¥|¡B ¥»®Ñ¯SÂI
’õ ¦b¤º®e²Õ´¤W¥H¹ê»Ú»Ý¨D¬°°ò¦³]­p³¹¸`µ²ºc¡A¹ê¨ÒÂ×´I¡Bµ²ºc²M´·¡BÅÞ¿è¦X²z¡A¨ÏŪªÌ®e©ö³q¹L¥»®Ñªº¾\Ū¾Ç²ß´x´¤Oracle¼Æ¾Ú®wªº°ò¦ª¾ÃÑ¡BºÞ²z§Þ¥©¤Î°ª¯ÅÀ³¥Î¡C
’õ ª`­«°ö¾iŪªÌªº¹ê½îÀ³¥Î¯à¤O¡A³v¼h²`¤Jªº³¹¸`¦w±Æ¨ÏŪªÌ´`§Çº¥¶i¦a¹ê²{¥»®Ñªº¯à¤O¥Ø¼Ð¡C
’õ ®Ñ¤¤¨Ï¥Î¤F¤j¶qªº¹ê¨Ò¡A°µ¨ì¥H¹ê»ÚÀ³¥Î¬°¥XµoÂI­åªR²z½×ª¾ÃÑ¡A¨ÏŪªÌ¦b¾Ç²ß²z½×ª¾ÃѪº¦P®É¶i¦æ¹ê½î¡A§ó®e©ö´x´¤Oracle¼Æ¾Ú®wªº¨Ï¥Î¤èªk»P§Þ¥©¡C
¤­¡B ¥»®Ñ¾AÀ³¹ï¶H
¥»®Ñ¥i§@¬°°ªµ¥°|®Õ¤Î°ö°V¾÷ºc­pºâ¾÷¬ÛÃö±M·~ªº±Ð§÷¡A¤]¥i§@¬°Oracle¼Æ¾Ú®wªºªì¾ÇªÌ¤Î¨ã¦³¤@©wªºOracle¼Æ¾Ú®w°ò¦ªº³n¥ó¶}µo¤H­û©M¼Æ¾Ú®wºÞ²z¤H­ûªº°Ñ¦Ò®Ñ¡C
¥»®Ñªº²Ä1³¹¡B²Ä2³¹¡B²Ä3³¹¥Ñ¨v¼ä½s¼g¡A²Ä6³¹¡B²Ä7³¹¡B²Ä8³¹¡B²Ä9³¹¡B²Ä10³¹¥Ñ±ä¥ÉµY½s¼g¡A²Ä11³¹¡B²Ä12³¹¥Ñ±i¥ßªN½s¼g¡A²Ä4³¹¡B²Ä5³¹¡B²Ä13³¹¡B²Ä14³¹¡B²Ä15³¹¡B²Ä16³¹¥Ñ¾GªFÁø½s¼g¡A¥þ®Ñ¥Ñ±ä¥ÉµY²Î½Z¡B©w½Z¡A¾GªFÁø²ÎÄw¡Bµ¦¹º¡C
¨Ñ±Ð®v¨Ï¥Îªº¹q¤l½Ò¥ó¤Î©Ò¦³¹ê¨Ò·½¥N½X¥i±q²MµØ¤j¾Ç¥Xª©ªÀºô¯¸(www.tup.com.cn)¤U¸ü¡C
¥»®Ñ¦b½s¼g¹Lµ{¤¤±o¨ì«Ü¦h±M®aªºÀ°§U¡B¤ä«ù©M«ü¾É¡A¦b¦¹ªí¥Ü°J¤ßªº·PÁ¡C¥Ñ¤_½sªÌª¾ÃѤô¥­¦³­­¡A®Ñ¤¤²¨º|©M¤£¨¬¤§³B¦b©ÒÃø§K¡AÀµ½ÐŪªÌ§åµû«ü¥¿¡C

½s ªÌ2012¦~8¤ë
¤º®e²¤¶¡G

¥»®Ñªö¥Î¤j¶qªº¹ê¨Ò¡A²`¤J²L¥X¦a¤¶²Ð¤FOracle 11gªº¨Ï¥Î©MºÞ²z¡A¦@16³¹¡A¥]¬A¼Æ¾Ú®w¨t²Î·§­z¡AÃö¨t¼Æ¾Ú®w³]­p²z½×¡B¼Æ¾Ú®w³]­p¡B¦w¸ËOracle¡BSQL*Plus¡BDDL©MDML¡B¬d¸ß»y¥y¡BOracle¨Æ°ÈºÞ²z¡B¼Ò¦¡¹ï¶H¡B±`¥ÎSQL¨ç¼Æ¡BPL/SQL°ò¦¡BPL/SQL°ª¯Å½sµ{¡BOracle¥þ²y¤Æ¤ä«ù¡BOracleªº±Ò°Ê©MÃö³¬¡BOracleªºÅé¨tµ²ºc¡BOracleªº¦w¥þºÞ²zµ¥¤º®e¡C
¥»®Ñª`­«¹ê¥Î©Ê©M¥iŪ©Ê¡A¥H¹ê¨Ò¬°¨Ì¦«¡A¨ÏŪªÌ¦b¾Ç²ß²z½×ª¾ÃѪº¦P®É¯à°÷±N©Ò¾Ç¤º®eÀ³¥Î¤_¹ê»Ú¤¤¡A§ó®e©ö´x´¤Oracle 11gªº¨Ï¥Î¤èªk¤Î§Þ¥©¡C¥»®Ñ¥i§@¬°°ªµ¥°|®Õ¤Î°ö°V¾÷ºc­pºâ¾÷¬ÛÃö±M·~ªº±Ð§÷¡A¤]¥i§@¬°Oracle¼Æ¾Ú®wªºªì¾ÇªÌ¤Î¨ã¦³¤@©wªºOracle¼Æ¾Ú®w°ò¦ªº³n¥ó¶}µo¤H­û©M¼Æ¾Ú®wºÞ²z¤H­ûªº°Ñ¦Ò®Ñ¡C

¥Ø¿ý¡G

²Ä1³¹ ¼Æ¾Ú®w¨t²Î·§­z1
1.1 ¼Æ¾Ú®wªº°ò¥»·§©À1
1.1.1 ¼Æ¾Ú©M¼Æ¾Ú®w1
1.1.2 ¼Æ¾Ú®wºÞ²z¨t²Î2
1.1.3 ¼Æ¾Ú®w¨t²Î3
1.2 ¼Æ¾ÚºÞ²z§Þ³Nªºµo®i5
1.2.1 ¤H¤uºÞ²z¶¥¬q6
1.2.2 ¤å¥ó¨t²Î¶¥¬q7
1.2.3 ¼Æ¾Ú®w¨t²Î¶¥¬q7
1.3 ¼Æ¾Ú®w¨t²ÎªºÅé¨tµ²ºc10
1.3.1 ¤T¯Å¼Ò¦¡µ²ºc10
1.3.2 ¨â¯Å¬M¹³¥\¯à»P¼Æ¾Ú¿W¥ß©Ê12
1.4 ½m²ßÃD12
²Ä2³¹ Ãö¨t¼Æ¾Ú®w³]­p²z½×14
2.1 ¼Æ¾Ú¼Ò«¬14
2.1.1 ¼Æ¾Ú¼Ò«¬¤Î¤ÀÃþ14
2.1.2 ¼Æ¾Ú¼Ò«¬ªº²Õ¦¨­n¯À15
2.1.3 ´XºØ¥D­nªº¼Æ¾Ú¼Ò«¬16
2.2 Ãö¨t¼Ò«¬19
2.2.1 Ãö¨t¼Æ¾Úµ²ºc19
2.2.2 Ãö¨t¾Þ§@20
2.2.3 Ãö¨tªº§¹¾ã©Ê¬ù§ô20
2.3 Ãö¨t¼Æ¾Ú®w³W­S¤Æ²z½×22
2.3.1 ¼Æ¾Ú¨Ì¿à23
2.3.2 ­S¦¡¤Î³W­S¤Æ24
2.4 ½m²ßÃD28
²Ä3³¹ ¼Æ¾Ú®w³]­p30
3.1 ¼Æ¾Ú®w³]­p·§­z30
3.1.1 ¤°¤\¬O¼Æ¾Ú®w³]­p30
3.1.2 ¼Æ¾Ú®w³]­pªº¤º®e31
3.1.3 ¼Æ¾Ú®w³]­pªº¥Ø¼Ð»P¯SÂI31
3.1.4 ¼Æ¾Ú®w³]­pªº¤èªk31
3.1.5 ¼Æ¾Ú®w³]­pªº¨BÆJ32
3.2 »Ý¨D¤ÀªR34
3.2.1 »Ý¨D¤ÀªRªº¥ô°È34
3.2.2 »Ý¨D¤ÀªRªº¨BÆJ35
3.3 ·§©Àµ²ºc³]­p36
3.3.1 ·§©Àµ²ºc³]­pªº¥Ø¼Ð©Mµ¦²¤36
3.3.2 ¹êÅé-Áp¨t¤èªk38
3.3.3 ªö¥ÎE-R¤èªkªº¼Æ¾Ú®w·§©Àµ²ºc³]­p41
3.3.4 E-R¼Ò«¬³]­p¹ê¨Ò45
3.4 ÅÞ¿èµ²ºc³]­p48
3.4.1 ÅÞ¿èµ²ºc³]­pªº¨BÆJ48
3.4.2 E-R¼Ò«¬¦VÃö¨t¼Æ¾Ú¼Ò«¬ªºÂà´«49
3.4.3 Ãö¨t¼Æ¾Ú¼Ò«¬ªºÀu¤Æ50
3.5 ª«²zµ²ºc³]­p51
3.5.1 ª«²zµ²ºc³]­pªº¨BÆJ51
3.5.2 ª«²zµ²ºc³]­pªº©Ê¯àµû»ù52
3.6 ¼Æ¾Ú®w¹ê¬I53
3.7 ¼Æ¾Ú®w¹B¦æ©MºûÅ@54
3.8 ½m²ßÃD54
²Ä4³¹ ¦w¸ËOracle56
4.1 ·Ç³Æ¤u§@56
4.1.1 ¤F¸Ñµw¥ó»Ý¨D56
4.1.2 Àò¨úOracle¼Æ¾Ú®w¤ÎÀ°§U¤åÀÉ56
4.2 ¦w¸Ë¨BÆJ58
4.3 ¼Æ¾Ú¦r¨å70
4.3.1 ¼Æ¾Ú¦r¨å·§­z70
4.3.2 ÀRºA¼Æ¾Ú¦r¨åµø¹Ï71
4.3.3 °ÊºA©Ê¯àµø¹Ï72
4.4 ½m²ßÃD73
²Ä5³¹ SQLúRPlus75
5.1 µn¿ý¨ì¼Æ¾Ú®w75
5.1.1 sqlplus©R¥O75
5.1.2 connect©R¥O78
5.2 SQLúRPlusªº±`¥Î©R¥O78
5.2.1 HELP©R¥O79
5.2.2 SET©R¥O80
5.2.3 SHOW©R¥O87
5.2.4 PROMPT©R¥O89
5.2.5 SAVE©M@©R¥O89
5.2.6 EDIT©R¥O90
5.2.7 RUN©R¥O90
5.2.8 COLUMN©R¥O91
5.2.9 DESCRIBE©R¥O92
5.2.10 SPOOL©R¥O93
5.2.11 CLEAR©R¥O94
5.3 «O¦sSQLúRPlusªº³]¸m95
5.4 ½m²ßÃD95
²Ä6³¹ DDL©MDML97
6.1 SQLªº°ò¥»·§©À97
6.1.1 SQLªº¾ú¥v97
6.1.2 SQLªº²Õ¦¨¤¸¯À98
6.1.3 ªÅ­È99
6.1.4 ª`ÄÀ100
6.1.5 SQL»y¥yªº¤ÀÃþ100
6.2 Oracleªº¥D­n¼Æ¾ÚÃþ«¬101
6.2.1 ¦r²Å«¬101
6.2.2 ¼Æ­È«¬108
6.2.3 ¤é´Á®É¶¡«¬112
6.2.4 rowidÃþ«¬117
6.2.5 ¤j¹ï¶HÃþ«¬118
6.2.6 ¤£¦P¼Æ¾ÚÃþ«¬¤§¶¡ªºÂà´«119
6.3 ¨Ï¥ÎCREATE TABLE»y¥y«Øªí120
6.3.1 °ò¥»»yªk120
6.3.2 §¹¾ã©Ê¬ù§ô122
6.3.3 ¨Ï¥Î¤l¬d¸ß³Ð«Øªí129
6.3.4 ¬d¬Ýªí«H®§131
6.4 ¨Ï¥ÎALTER TABLE»y¥y­×§ïªíµ²ºc132
6.4.1 ¼W¥[¦C132
6.4.2 ¼W¥[¬ù§ô133
6.4.3 ­×§ï¦C134
6.4.4 ­×§ï¬ù§ô135
6.4.5 ­«©R¦Wªí¦W©M¦C¦W137
6.4.6 §R°£¦C©M¬ù§ô137
6.4.7 ¬ù§ôªº±Ò¥Î¡BÅçÃÒ©M©µ¿ð141
6.5 ¨Ï¥ÎINSERT»y¥y´¡¤J¼Æ¾Ú147
6.5.1 ³æ¦æ´¡¤J147
6.5.2 ªÅ¦r²Å¦ê»PªÅ­È148
6.5.3 ¦h¦æ´¡¤J148
6.6 ¨Ï¥ÎUPDATE»y¥y§ó·s¼Æ¾Ú154
6.7 ¨Ï¥ÎDELETE»y¥y§R°£¼Æ¾Ú155
6.8 ¨Ï¥ÎTRUNCATE»y¥y§R°£¼Æ¾Ú155
6.9 §R°£ªí156
6.10 ½m²ßÃD157
²Ä7³¹ ¬d¸ß»y¥y159
7.1 ¬d¸ß»y¥y·§­z159
7.1.1 °ò¥»»yªk®æ¦¡159
7.1.2 °°ªí©M°°¦C160
7.2 ³æªí¬d¸ß161
7.2.1 SELECT¤l¥y161
7.2.2 FROM¤l¥y165
7.2.3 WHERE¤l¥y166
7.2.4 DISTINCTÃöÁä¦r182
7.2.5 GROUP BY¤l¥y»P»E¦X¨ç¼Æ183
7.2.6 HAVING¤l¥y188
7.2.7 ORDER BY¤l¥y189
7.2.8 ¬d¸ß»y¥yªº°õ¦æ¶¶§Ç194
7.3 ¦hªí³s±µ¬d¸ß195
7.3.1 ¤º³s±µ195
7.3.2 ¥~³s±µ199
7.3.3 ¦ÛµM³s±µ203
7.3.4 ²Ã¥d¨à¿n©M¥æ¤e³s±µ205
7.3.5 ¦Û³s±µ206
7.4 ¤l¬d¸ß207
7.4.1 ¥i¥H¨Ï¥Î¤l¬d¸ßªº»y¥y208
7.4.2 ¤l¬d¸ßªº¤ÀÃþ208
7.4.3 ¬ÛÃö¤l¬d¸ß214
7.5 ¶°¦X¹Bºâ217
7.5.1 ¦}¶°¹Bºâ217
7.5.2 ¥æ¶°¹Bºâ219
7.5.3 ®t¶°¹Bºâ219
7.6 ½m²ßÃD220
²Ä8³¹ Oracle¨Æ°ÈºÞ²z221
8.1 ¨Æ°È·§­z221
8.1.1 ¤°¤\¬O¨Æ°È221
8.1.2 ¨Æ°Èªº4­Ó¯S©Ê222
8.2 Oracleªº¨Æ°È³B²z¾÷¨î222
8.2.1 ¨Æ°Èªº¶}©l»P²×¤î222
8.2.2 ¨Æ°È±±¨î»y¥y223
8.2.3 ¦hª©¥»Åª¤@­P©Ê225
8.3 ¨Æ°Èªº¦}µo±±¨î225
8.3.1 ¦}µo¾Þ§@±a¨Óªº°ÝÃD225
8.3.2 ¨Æ°Èªº¹jÂ÷¯Å§O226
8.3.3 Âê230
8.4 ½m²ßÃD235
²Ä9³¹ ¼Ò¦¡¹ï¶H237
9.1 µø¹Ï237
9.1.1 µø¹Ïªº·§©À237
9.1.2 ³Ð«Øµø¹Ï238
9.1.3 ¹ïµø¹Ï¶i¦æDML¾Þ§@241
9.1.4 ­×§ïµø¹Ï244
9.1.5 §R°£µø¹Ï244
9.1.6 ¤ºÁpµø¹Ï»P«eúJnúJ¦æ¬d¸ß244
9.1.7 ¬d¬Ýµø¹Ï«H®§248
9.2 ¦P¸qµü249
9.2.1 ¦P¸qµüªº·§©À249
9.2.2 ³Ð«Ø¦P¸qµü249
9.2.3 §R°£¦P¸qµü251
9.2.4 ¬d¬Ý¦P¸qµü«H®§251
9.3 §Ç¦C251
9.3.1 §Ç¦Cªº·§©À251
9.3.2 ³Ð«Ø§Ç¦C252
9.3.3 NEXTVAL°°¦C©MCURRVAL°°¦C253
9.3.4 ­×§ï§Ç¦C255
9.3.5 ¬d¬Ý§Ç¦C«H®§256
9.4 ¯Á¤Þ256
9.4.1 ¯Á¤Þªº·§©À256
9.4.2 ¯Á¤ÞªºÃþ«¬257
9.4.3 ³Ð«Ø¯Á¤Þ261
9.4.4 ­×§ï©M­««Ø¯Á¤Þ262
9.4.5 §R°£¯Á¤Þ264
9.4.6 ¬d¬Ý¯Á¤Þ«H®§264
9.4.7 ¯Á¤Þ»P¬ù§ô265
9.4.8 ¦ó®É¨Ï¥Î¯Á¤Þ267
9.5 ¤À°Ïªí268
9.5.1 ¤°¤\¬O¤À°Ïªí268
9.5.2 ³Ð«Ø¤À°Ïªí268
9.5.3 ºûÅ@¤À°Ï285
9.5.4 ¬d¬Ý¤À°Ï«H®§289
9.6 Á{®Éªí291
9.7 ½m²ßÃD293
²Ä10³¹ ±`¥ÎSQL¨ç¼Æ295
10.1 ¦r²ÅÃþ¨ç¼Æ295
10.1.1 ASCII¨ç¼Æ295
10.1.2 CHR¨ç¼Æ296
10.1.3 CONCAT¨ç¼Æ296
10.1.4 INITCAP¨ç¼Æ296
10.1.5 INSTR¨ç¼Æ297
10.1.6 LOWER¨ç¼Æ©MUPPER¨ç¼Æ298
10.1.7 LPAD¨ç¼Æ©MRPAD¨ç¼Æ299
10.1.8 LTRIM¨ç¼Æ¡BRTRIM¨ç¼Æ©MTRIM¨ç¼Æ300
10.1.9 LENGTH¨ç¼Æ©MLENGTHB¨ç¼Æ301
10.1.10 REPLACE¨ç¼Æ301
10.1.11 SUBSTR¨ç¼Æ©MSUBSTRB¨ç¼Æ302
10.2 ¼Æ­ÈÃþ¨ç¼Æ302
10.2.1 ABS¨ç¼Æ302
10.2.2 CEIL¨ç¼Æ303
10.2.3 FLOOR¨ç¼Æ303
10.2.4 MOD¨ç¼Æ303
10.2.5 ROUND¨ç¼Æ304
10.2.6 TRUNC¨ç¼Æ305
10.3 ¤é´ÁÃþ¨ç¼Æ305
10.3.1 ADD_MONTHS¨ç¼Æ305
10.3.2 CURRENT_DATE¨ç¼Æ©MCURRENT_TIMESTAMP¨ç¼Æ306
10.3.3 EXTRACT¨ç¼Æ307
10.3.4 LAST_DAY¨ç¼Æ308
10.3.5 MONTHS_BETWEEN¨ç¼Æ308
10.3.6 NEXT_DAY¨ç¼Æ309
10.3.7 ROUND¨ç¼Æ310
10.3.8 TRUNC¨ç¼Æ311
10.4 ªÅ­È³B²z¨ç¼Æ313
10.4.1 NVL¨ç¼Æ313
10.4.2 NVL2¨ç¼Æ313
10.4.3 NULLIF¨ç¼Æ314
10.4.4 COALESCE¨ç¼Æ314
10.5 Âà´«Ãþ¨ç¼Æ315
10.5.1 TO_CHAR¨ç¼Æ315
10.5.2 TO_DATE¨ç¼Æ317
10.5.3 TO_NUMBER¨ç¼Æ317
10.6 ¨ä¥L±`¥Î¨ç¼Æ318
10.6.1 DECODE¨ç¼Æ318
10.6.2 DUMP¨ç¼Æ320
10.7 ½m²ßÃD320
²Ä11³¹ PL/SQL°ò¦322
11.1 PL/SQL·§­z322
11.1.1 ¤°¤\¬OPL/SQL322
11.1.2 SQL»PPL/SQL322
11.1.3 PL/SQLªº¹B¦æ323
11.2 PL/SQLªº²Õ¦¨¤¸¯À324
11.2.1 ¶ô325
11.2.2 ¼ÐÃѲÅ327
11.2.3 ¼Æ¾ÚÃþ«¬327
11.2.4 Åܶq330
11.2.5 ½á­È»y¥y332
11.3 ±±¨îµ²ºc333
11.3.1 ¤À¤äµ²ºc333
11.3.2 ´`Àôµ²ºc338
11.3.3 ¸õÂ൲ºc343
11.4 ´å¼Ð346
11.4.1 ´å¼Ðªº·§©À346
11.4.2 Å㦡´å¼Ð346
11.4.3 Áô¦¡´å¼Ð356
11.5 ²§±`357
11.5.1 ²§±`·§­z357
11.5.2 ²§±`ªº³B²z359
11.5.3 ²§±`ªº¶Ç¼½362
11.5.4 SQLCODE©MSQLERRM¨ç¼Æ367
11.6 ½m²ßÃD368
²Ä12³¹ PL/SQL°ª¯Å½sµ{372
12.1 ¦sÀx¤lµ{§Ç372
12.1.1 ¦sÀx¹Lµ{372
12.1.2 ¦sÀx¨ç¼Æ380
12.1.3 §½³¡¤lµ{§Ç386
12.2 ¥]388
12.2.1 ¥]·§­z388
12.2.2 ¥]ªº³Ð«Ø389
12.2.3 ¥]ªº½Õ¥Î391
12.2.4 ¥]ªº­«¸ü392
12.2.5 ¥]ªººÞ²z393
12.3 IJµo¾¹394
12.3.1 IJµo¾¹·§­z394
12.3.2 DMLIJµo¾¹396
12.3.3 INSTEAD OFIJµo¾¹401
12.3.4 ¨t²ÎIJµo¾¹403
12.3.5 IJµo¾¹ªººÞ²z404
12.4 ½m²ßÃD405
²Ä13³¹ Oracle¥þ²y¤Æ¤ä«ù408
13.1 °ê®a»y¨¥¤ä«ù408
13.1.1 ¤°¤\¬ONLS408
13.1.2 NLSªº¥D­n¤º®e408
13.2 Oracle¤¤ªº¦r²Å¶°409
13.2.1 Oracle¤ä«ùªº¦r²Å¶°410
13.2.2 ¼Æ¾Ú®w¦r²Å¶°©M°ê®a¦r²Å¶°411
13.3 ±`¥ÎªºNLS°Ñ¼Æ412
13.3.1 »y¨¥©M¦a°Ï°Ñ¼Æ412
13.3.2 ¤é´Á©M®É¶¡°Ñ¼Æ413
13.3.3 ¬d¬ÝNLS°Ñ¼Æ415
13.3.4 ³]¸mNLS°Ñ¼Æ416
13.4 ½m²ßÃD420
²Ä14³¹ Oracleªº±Ò°Ê©MÃö³¬421
14.1 ³Ð«Ø©M°t¸m°Ñ¼Æ¤å¥ó421
14.1.1 Oracle°Ñ¼Æ¤å¥ó·§­z421
14.1.2 ¬d¬Ýªì©l¤Æ°Ñ¼Æ422
14.1.3 ³Ð«Ø°Ñ¼Æ¤å¥ó424
14.1.4 ­×§ïªì©l¤Æ°Ñ¼Æ425
14.1.5 ±`¨£ªºªì©l¤Æ°Ñ¼Æ427
14.2 ±Ò°Ê¼Æ¾Ú®w428
14.2.1 ¼Æ¾Ú®wªº±Ò°Ê¹Lµ{428
14.2.2 ¹ê¨Òªº³Ð«Ø»P¼Æ¾Ú®wªº±Ò°Ê428
14.2.3 ¼Æ¾Ú®wªºª¬ºA¤Á´«430
14.3 Ãö³¬¼Æ¾Ú®w436
14.4 ½m²ßÃD438
²Ä15³¹ OracleªºÅé¨tµ²ºc439
15.1 Oracle¹ê¨Ò439
15.1.1 Oracle¹ê¨Ò·§­z439
15.1.2 Oracleªº¤º¦sµ²ºc440
15.1.3 Oracleªº¶iµ{µ²ºc446
15.2 Oracleªºª«²z¦sÀxµ²ºc450
15.2.1 ¼Æ¾Ú¤å¥ó451
15.2.2 ±±¨î¤å¥ó452
15.2.3 Áp¾÷­«°µ¤é§Ó¤å¥ó452
15.3 OracleªºÅÞ¿è¦sÀxµ²ºc458
15.3.1 ¼Æ¾Ú¶ô458
15.3.2 °Ï460
15.3.3 ¬q461
15.3.4 ªíªÅ¶¡462
15.4 ½m²ßÃD476
²Ä16³¹ Oracleªº¦w¥þºÞ²z478
16.1 ¥Î¤áºÞ²z478
16.1.1 ¥Î¤á»P¼Ò¦¡478
16.1.2 ³Ð«Ø¥Î¤á479
16.1.3 ¥Î¤áªº»{ÃҤ覡481
16.1.4 ­×§ï¥Î¤á490
16.1.5 §R°£¥Î¤á492
16.1.6 Oracle¼Æ¾Ú®wÀq»{³Ð«Øªº¥Î¤á492
16.1.7 ¬d¸ß¥Î¤á«H®§494
16.2 Åv­­ºÞ²z495
16.2.1 ¨t²ÎÅv­­ºÞ²z495
16.2.2 ¹ï¶HÅv­­ºÞ²z503
16.3 ¨¤¦âºÞ²z506
16.3.1 ³Ð«Ø¨¤¦â506
16.3.2 ¬°¨¤¦â±Â¤©Åv­­509
16.3.3 Àq»{¨¤¦â»P¨¤¦âªº±Ò¥Î¸T¥Î509
16.3.4 ¦^¦¬¨¤¦âªºÅv­­©M§R°£¨¤¦â512
16.3.5 ¬d¬Ý¨¤¦â«H®§513
16.4 ·§­n¤å¥óºÞ²z514
16.4.1 ·§­n¤å¥ó·§­z514
16.4.2 ³Ð«Ø·§­n¤å¥ó514
16.4.3 §R°£·§­n¤å¥ó517
16.4.4 ¬d¬Ý·§­n¤å¥ó«H®§517
16.5 ½m²ßÃD519
ªþ¿ýA ¦U³¹½m²ßÃD°Ñ¦Òµª®×521
°Ñ¦Ò¤åÄm535
§Ç¡G