PLSQLDeveloper安裝使用手冊

PLSQLDeveloper安裝使用手冊TOC\o"1-5"\h\z酉己置Oracle數(shù)據(jù)庫連接4使用PLSQLDeveloper5連接Oracle數(shù)據(jù)庫5執(zhí)行SQL語句5在SQL窗口中執(zhí)行5在命令行窗口中執(zhí)行8創(chuàng)建數(shù)據(jù)庫中的對象10在SQL窗口中創(chuàng)建10在命令行窗口中創(chuàng)建10用模板創(chuàng)建10查看數(shù)據(jù)庫中的對象13從SQL窗口中打開查看窗口13從對象瀏覽器中打開查看窗口14調(diào)試函數(shù)/存儲過程15

i.運行安裝程序，出現(xiàn)如下界面:2.點Next,出現(xiàn)以下界面:3.點Next,出現(xiàn)如下界面:4.點Finish,開始安裝。完成后出現(xiàn)如下界面:fPL;SQLDe”他卡計InrStalatlonSerialnumber0k0998-UnlimiteduserlicenseallroundautomationsPrupunragimslt&ll.CapryingiFil&s...5.點Prupunragimslt&ll.CapryingiFil&s...5.點Close退出即可。.配置Oracle數(shù)據(jù)庫連接本部分內(nèi)容請參見《Oracle安裝配置手冊》.使用PLSQLDeveloper連接Oracle數(shù)據(jù)庫1.運行PLSQLDeveloper,彈出如下窗口:2.輸入正確的用戶名、密碼、數(shù)據(jù)庫名，并選擇正確的連接身份后即可進入。注意：數(shù)據(jù)庫名是指在本機設置的數(shù)據(jù)庫別名執(zhí)行SQL語句在SQL窗口中執(zhí)行.在File的下拉菜單中選New,如圖:

?PL/SQLDeveloper-EmislMlOOAWGfile肝djectEdt5essmQebugJoobMacroDocumentsReportsWindow也1口E*ogramWindow?也也,SavoCtrl乖5Save照…SaveA[lSQLWindowg科?EeportWhdowCommandWindowExphinPlanMfindawfjoseCfaspM『富命SeguerceSyTJDW^retfcOryJobPrintPrint沁jp…P的號SetWwExftLKerR以e■"Ie?!」Tliggeis國LjJavascuces1*1ZjMb*1*1_j|LbaiieiEi」DsreclariK±二JTables[+1一JViewsf*l_JSequences02JLk&百1*1二JPioHes國.一]R*?f*l二]Synonymsw」口萬命參3如心l1±i_|TmblKpaces國CUslere二JDatabaselinkTempgi日考國二JConstarits*|e-LJDelauh*_JDMLGHteflientE年|?|1H.選擇SQLWindow,產(chǎn)生一個SQL窗口，如圖:.按F8執(zhí)行一條SQL查詢語句，結(jié)果如圖:&PL/SQLDeveloper-FmisDCOO^WG士gIe肝口jsctEdtSessionQebugJoobMacroDgCLmentsdepartsWindow也Ip■:應修?m昌躇g茁船聒崎也學攣洞超里&PL/SQLDeveloper-FmisDCOO^WG士gIe肝口jsctEdtSessionQebugJoobMacroDgCLmentsdepartsWindow也Ip■:應修?m昌躇g茁船聒崎也學攣洞超里匕科？■I口區(qū)|Oulpdt|￡場取心|*9QLWindow-select*fromKtyhHMAllabjeds，餐0Recertobfecte1*1Flffl01*1Fl?國I±1國1*11*11*1Fl?I±11*11Funclians_□Piocedures」Packages1PackagebodiesITjipes_□Typebodies」Tliggei5」Javascuces~8Jgb?二]Lbaiiei_JDfDCHaRKITables2jViews_3Sequences」Ums二JPiofies2jrmFl@m一1S^non^ms_]D&db日垢linkw1TI^L-wvr^zJSQLTemDla儂f*_ICo抵lar電nlect工￡rgnx^yhxx]S①尋芟M畬YHDMI|YHMC|XSMCJEQX11HBZ|EZLXSTOPED[DWDM117GLQ002哲理人010002213SP0002審姒D20DD23130flM"a0100QQ2412922D00F0002E5129ms<Btt口1口0MAINt5011mgl共享里應曾賽01MAIN.75012m卬共享單位市批02MAIN4I1drmsselectedinO.D47seconcte(mare..-)二1:21lil」DeJaullli#_|DML我mlitefnents色_l2TSOLWindow-sdeclrIra4.按F8執(zhí)行一條輸出信息語句，如圖:5.切換到SQL窗口的Output頁面，可以看到顯示了輸出信息:-」口!上Allabjeds，餐0Recertobfecte-」口!上Allabjeds，餐0Recertobfecte1*1Flffl01*1Fl?國I±1國1*11*11*1Fl?I±11*11Funclians_□Piocedures」Packages1PackagebodiesITjipes_□Typebodies」Tliggei5」Javascuces~8Jgb?_2LbaiieiDfDCHaRKITables2jViews_3Sequences」Ums二JPiofies2jrmFl@m一1S^non^ms_]D&db日垢linkw1TI^L-wvr^zJTemDla儂NPL?IDeveloper-FmiEDClOO?VUG目Ie肝djsctEdt5essmQebugJoolsMacroDgajmentsReportsWindow^elp■:應修?口昌躇9茁般魁酬**阜華園巖里建喧雷國?nCo的占亞上]?」DdaukL*_|DMLs4atemenh;]-I_」『ZSQLWindow-begindbrns在命令行窗口中執(zhí)行.在File的下拉菜單中選New,界面同3.2.1中的第一步的界面。.選擇CommandWindow,產(chǎn)生一個命令行窗口:

⑴PL/SQLDeveloper-FmisDOCOAWG士gIe肝口jsetEdtSessionQiebuglootMacroDgcumigntsdepartsWindow洞口■:支修?m昌躇X般學里舊招可型恰雷%,等國rmlQ匕於?AllabjedsT±!」Retortcbfecte△1*]」Funcliansffl_JPioceduresAllabjedsT±!」Retortcbfecte△1*]」Funcliansffl_JPiocedures?!」PackaQesl±l_|Packagebodies1*1I1Types國_|Typebodies?!」Tiiggeisl±l」Javascuces1*1jJob自ra_|LbaiieiE：」DsreclariK±二jTables[+1一JViews_]Sequences?:」Lk&百1*1_|Profies國」R*5f*l_JSynonyms色Tempfato*_JC口nMaritsLt_|Delauh叵」DML斌日Htonen,「|,*CumnwridlWindow-r^ewQia^g]E出口?|Allobject▼*_jRecflrtcbfecteI*；1Funclians同■_□Piocedures,*CumnwridlWindow-r^ewQia^g]E出口?|Allobject▼*_jRecflrtcbfecteI*；1Funclians同■_□Piocedures1*1」Packages*_JPackagebodies1*」Types1*1-JTypebodesTliggeis.JavascucesJgb?LVariesDidcIcirkTables如帛SequencesLk國&ProflasRcie$Synonyms一-DIx|ConnactcdltoOra.cLa9iEntarprisiaEditionHciLa-asa9.^.0.1.0Connectedas￡b1sOOOO，lYHDHTHHCXSHCJCQXYHEECZLKSTDPIEDWI：'H17GLOOOZ管等人01OOOZ10SPOODZ甲時人02DOOZ130lisalisa.01000021Z3Ez0001doos“酢AA3仁甘￡七01QQHAIH5022ugl共享羊性管理01皿1HEO12XLSp箕享單位審批02SQL*seLeet*￡rcm嘉七yhx患器■?[cciT[THMpDB-|VtR[Affl(HDG|TMtr|9hwkHlMtKlhO.DSSswen^Tempfato±_JC口nManhr*_|Delauh,_□DMLMMerhenH*|tSQLWindow-begindbrr^:CommandWindow-iNw^

0PL/5QLDeveloper-FmisDOCOAWG■士gIe肝口jsctEdtSessionQiebuglootMacroDgCLmentsdepartsWindow■:支修?m昌躇X般學里舊招可理）雷%,等國rmlQ匕於?-ini^llAllabjeds±!」Retortcbfecte△1*]」FuncliansAllabjeds±!」Retortcbfecte△1*]」Funcliansffl_JPiocedures?!」PackaQesl±l_|Packagebodies1*1I1Types國_|Typebodies?!」Tiiggeisl±l」Javasajces1*1jJob自ra_|LbaiieiE：」DsreclariK±二jTables[+1一JViews_1Sequences?:」Lk&百1*1_|Profies國」R*5f*l_JSynonyms色Tempfato*_JC口nManhr*_|Ddauh?I|”:SQLWindow-begindbm^二CommandWindow■IN^^創(chuàng)建數(shù)據(jù)庫中的對象在SQL窗口中創(chuàng)建與3.2.1中執(zhí)行SQL查詢語句的方法類似，在SQL窗口中執(zhí)行創(chuàng)建語句即可。在命令行窗口中創(chuàng)建與3.2.2中執(zhí)行SQL查詢語句的方法類似，在命令行窗口中執(zhí)行創(chuàng)建語句即可。用模板創(chuàng)建此處以創(chuàng)建表為例.在File的下拉菜單中選New,再選擇Table;或者直接在對象瀏覽器中的Tables目錄上點右鍵選New。出現(xiàn)如下界面：NPL/5qLDeveloper-FmiEDClOO?VUG二131金0TTab-AllQbje*回Eenaal國]Cokrnns|由Ke/s|由Checks|嘴Induxd*|jjPtwleges|回國回叵.㈤而回叵!￡■KEE.田甲回回田莊G日CDED日日口ED日日EDE□日日CDEDUIEEldtJHIil匡IHU二NPL/5qLDeveloper-FmiEDClOO?VUG二131金0TTab-AllQbje*回Eenaal國]Cokrnns|由Ke/s|由Checks|嘴Induxd*|jjPtwleges|回國回叵.㈤而回叵!￡■KEE.田甲回回田莊G日CDED日日口ED日日EDE□日日CDEDUIEEldtJHIil匡IHU二HHHlHHlIHllililBHlUHlIHlO隹。MITDCREAl—1BBCOLSBBHI蝴AlNMEhBBRDUrt；BBJ5BBJ6BBJ7BB_13BE二19B0.2OBB_21BB_BBFLBBJBSHQLBB.CHECKBB_C0VERBB?DBDQRDOwnetFmisqqqiCu$t0NarnefTemplesf*_ICo抵lar電lilnDeJaull?ITablespaceSfreeKUiedIniTransMaxTranshniiailExierii：||日貝esFNe^lClient||Bytes~~司Slncie45ePMinExtents-1M4kEj^enh|廠UN詞ed一口國曲5「Tempoiarp廠ReserverowsoncomintOrgancatiorriPHeap廠IndeMComments：L*_|DMLs4atemenh;]“II”一CteeHelp■SQLCredletable2.命名新表為A,再切換到Columns頁面，增加number類型的字段A,和varchar2(100)類型的字段B,如圖：:CreatetableBnTab-AllQbje*5E-回叵叵而回叵l￡-R-回叵田E￡應莊m?AUTDCRE41—1BBCOLSBBHI蝴AlNMEhBBRDUrt；BBJ5BSJ6BBJ7BBJ3BBZl9B0.2OBB_21BB_BBFLBBJBSHQLBB.CHECKBB_COVERImplies國?口ConsiarVs_*J?」DdaukL*_|DMLs4atemenh;]<1|iFinGBHBid國1C[*rnns|由Ke/s|由Checks|嘴Index重|HPtwleges|郵時|gtKCKb■SQLCredletable3.再切換到Indexes頁面，增加一個包含A字段的唯一索引IDX_A,如圖:NPL/5qLDeveloper-FmiEDClOO?VUG；EdittoblcATablesAllQbje*AOTDCREA1—BBCOLSBBHIBBMA1N1MEKIBBRDUreBBJ5BBJSBBJ7BB_13BBZl9BB.20BB_21ibb.bbflBB?BB5HQLBB.CHECKBB_C0VERIBB.DBIDQnaiEd二TemDla儂f*l-_□Co的占亞上］?」DdaukDMLsflatemenk:|i±rEdittableAIiiI回Gone閭|四CDlumns|gK叩s||曲Chsdu8sIndexes4點ViewSQL,可以看到生成的SQL語句:5點Apply,即創(chuàng)建表A。查看數(shù)據(jù)庫中的對象從SQL窗口中打開查看窗口1.打開一個空白的SQL窗口，輸入對象名，如前面建的表A,在對象名上點右鍵，如圖:2.選才VView,出現(xiàn)如圖界面，可切換頁面查看表的信息；如果選Edit,還可以在界面上進行修改：NPL?IDeveloper-FmiEDClOO?WGAllabjBdf-|C]x]；VKWtdbkAMAaBoISMu莊莊莊AUT0CREA1BSCOLSBSHkJBBM同NMEkBBROWSBBJ5BBJ6BBJ7BE二18B0J9BB_2OBE_21BB_BBFLBS.BBSMQLBB.CHECKBBCOVER*」C口n&taritsNPL?IDeveloper-FmiEDClOO?WGAllabjBdf-|C]x]；VKWtdbkAMAaBoISMu莊莊莊AUT0CREA1BSCOLSBSHkJBBM同NMEkBBROWSBBJ5BBJ6BBJ7BE二18B0J9BB_2OBE_21BB_BBFLBS.BBSMQLBB.CHECKBBCOVER*」C口n&taritsLt_|DelauhFl_|DHLiiat:SQLWindow-NewSViewtableA司General|囚Cdums|2K<rs|gChecks]喟Indtwes]flPiivieaes|口wr|FMl€0000-Name^―SiorafjeTabl&space|FM|SQQQQCUsier—Duaban廠TwoofWFPreseiYe(ow$onCamrnerts|包利CloseColumns|"OigamzabciH「HeapFIndexHeip從對象瀏覽器中打開查看窗口.仍以表A為例，在對象瀏覽器中展開Tables目錄，選中表A,點右鍵，如圖:刃PL/gqLDeveloper-FmiEDClOO?VUG日卜肝口jsctEdtSessionQiebugJoobMacroDgcumigntsReportsWindow也Ip日曲由9-.時由，.甲弱甲由電電串由由電電血由時降ammnnllrnr,一二.二nrrngnrmmnminr■一三?二二minwnnrrrnrrnirn—T日卜肝口jsctEdtSessionQiebugJoobMacroDgcumigntsReportsWindow也Ip日曲由9-.時由，.甲弱甲由電電串由由電電血由時降ammnnllrnr,一二.二nrrngnrmmnminr■一三?二二minwnnrrrnrrnirn—TIHHUlil匡屋一二一-UHIHHIIHLSF-匡匡匡Ne0…DuplcaliB.HRefreshCopycommaseparatedPrse武怕$Describe炳白wEditftenarneDrop0rc*weRflcampieF&ferendngobjectsQueryEdit彌aExport做啟Tempia怕=sl*l二JConstants_*J[*i_|口dauk二1*_|DHL身a.后面的操作與3.4.1中的第二步完全相同。3.5.調(diào)試函數(shù)/存儲過程1.首先打開調(diào)試窗口，調(diào)試窗口可以從SQL窗口中打開，也可以從對象瀏覽器中打開。在SQL窗口中按如下方法打開：打開一個空白的SQL窗口，輸入函數(shù)或存儲過程名，如EXISTOBJ,在對象名上點右鍵，再選擇Test。在對象瀏覽器中按如下方法打開：展開函數(shù)或存儲過程目錄，選擇所需調(diào)試的函數(shù)或存儲過程，如EXISTOBJ，點右鍵，再選擇Test。如圖：2.選擇了Test以后打開的調(diào)試窗口如圖所示:

rPL，喇LDeveloper-FmisDOOO?VUG-ITestWindow-SEriptforfurKtionEMIETClB艇購gElsEptjject￡dit2BSS<onDebug[ools中門口口要umertsReports^htfcw日均■:支修?口昌躇9茁船型崎％學隼洞超里建恰雷Allobject/回?BIT二口R二Allobject/回?BIT二口R二由.⑥EIT_XOR-fF?CHARINOEX&?[HARiNOE<FROMeAC隹?MIEMATDATETQ5TR樂..⑥MYE雷(W/.DiATEDIFF由?EXISTOBJLE?EX1ETSETfSemstsrdwE?fflAC色?GETDATEl￡?GETPIFFLEH儂RENT比雷GET5FftCEE?GET.BETwEEN隹eHEXT01N1由?⑧INTT0HE<fh?INTTOSTfi..m鬲<(ChATC：/JTern口同骷ffl-OCOhSlWitS_*JS」DelaukI*」DMLs4atemenhEir-QiIhsndlng1]STwtWindow-SciiptfeefundionEXISTedraipi|口BM8Output|5幅.H|Rolilei|Trace|與j_二&I』8Apeclai'e一SiM-Jeiin口111rAlswtare：transittedfri^ai/&aintepers."--。/工ZnK2Z<-->rdru-?Znw22resultbooLe-tui.i；bogiiL-Cd22thefUliCtlOfirasullD:=QKi鷲j1廿0xmiae='>:u-oTmarf=>:vobjnake,vobjtype">:vobjtype)?—Cwrvirtfd2s?71r^Zi^ul2t<?JiitsuitL">ys-diutll.hool^to^ihrt4tesult\；and;李VamablebpcValue4?0re^ukIdleger■pwwneiSuho-—FYobpameSbing，5MM*l>vobjiype*R■*jjiT—13.上面的窗口中，result是返回的結(jié)果參數(shù)，其他是需要傳入的參數(shù)，輸入以后按F9,界面如圖：an?日b國k電喳營運后心■■■…殖］圖PL/SQLDeveloperfmiM000@WG-[TestWindow-5ciiptForfunctiofiEKESTODJ@WGl據(jù)?leProjectRd**我時QjebugloolsMacro的如惟nts-or?^ndewHdp.⑹M-F_JDirectoiie$EgTablesAlDDpctS。曲o四，X0fimQ-F_JDirectoiie$EgTablesAlDDpctS。曲o四，X0fimQ+fiDBMSPrdierTiacedkadajEw--B■白J.叔m爐日小日康昌七也￡*3金葉會已廣上士日F片--d/l/jauQlW-—>^lsa/trua/iml2resultboolean;begn二一￡j工J.fmetWawresulti-exiS&Obg(voimez■>:vovnetruigibjnamfi=>;vobjniuaftruobjeype■>Li/objt.ype);—Cojnvertfa2s^/ttru^/七。￡)/.1/mu21:result:ssys_diutll:biQOl_,Go_ln,c{result);QivdwAAUTOCRIEA7EDJXXBBCDLSBBHJBBMAINMENUBBROW5BB_15Tiennp尿s00Consents_*j￡]■口DefautErODMLstaiernenis陟口EriorhandinQ:|F口RecentCibiEdl暴叵i^2(Functions1￡3|Rocadure^gmPackageF口RckogebodiwELJTyvfrsIf口T^pebodiesEOTlig&*E口JavaMMcesE口Jobs1￡匚JUxaiiasSA-g-si-=Tib就Window&￡aip4larfundicn附S|；而一耳嬴工.按Ctrl+N,進入函數(shù)EXISTOBJ:Testscf取|DEMSOutput|Stab3bcs|Prditer|Tiace|X。中=觸，Alobiects[￡口Recent電已函因七JFundions由七Rocedure^E-O田口Fackogebodi&s0LJTyvfrs由二JbodiesE-LJTriggei?5口Javasources區(qū)口Jobsl￡匚JbbraiissF-ODimtorietF；Tablesgj。皿mmvutks以gon■■史.新附閱:2857”0￡DECTNicount罐,窗±距iSAALH□匚REATE口」NXBBDDL5BBHJBBMAJNMENUBBRCWSBB_15lismrfatBSEE,F口ConslantePIDefautLJDMLstaiemenis口EriorhandlinciTestWindow?SciiipvlarluxtKriES4SifuOUHERIonullthen口BJdVME■;=5YS_COH!TIXT['VSBMW'#■CUP!?IWT?SCHItUn);elEFEOBJOWED;=vOWES;?juiIf；selectoomit(*JintoLcaimT壬七口mSYS.ALL_aBJECTS?iw￥?OE工串=GpptRCOBJOWWEIOtadQBJICT_hfAMB=UPPBE(vflBJNAJ1B)20BJttC7_T±￡icaunts1then.wdtim.七薪?45return,faJloc：；eiulIf；VanaUeV^U6CallstackEXISTDBU|Line10]icourt:=0?；10:1Exeoiing...5.在靠近代碼的地方點左鍵，可以設置斷點；在靠近邊框的地方點左鍵，可以設置書簽，如圖：TestSCfB|DBMSOulput|Stabsbcs|Prdiler|Tiace|XT圳網(wǎng)的。小。觸fii□&IS一口仃廣國也士也fry一20也-亂寸leountNUMBER；OBJOWERVXJUCHiLBZmn--更法球面:Wg-S-gBEGIN&；ifuOWffERIkniillttwADEJOWEB"SYS^ONTEKTt-UEKB-EMV',aCUBIIE}TT_SCHEEIA1>;elseDBJaWEK：■vOimEB;?*<iix；aeUEcrteouivt《看￥i.ni:<3IqnuirtCron5YS.ALL_CIBJECT5OWEE?UPPEEl(OBJOWElendOBJECTHAM：E=irPPRIMJkndOBJECTTIfIcorunc=-1thenM*山eCallstackEXISTDBU|Line10]icourt:=0?EE

,

F口ConslantePIDefautLJDMLstaiemenis口EriorhardinaTestWindow?SciiipvlarluxtKriES4S；10:1Exeoiing...6.按Ctrl+T,運行到斷點處停下，我們可以輸入變量名，來查看該變量的當前值；也可以把鼠標移動到變量上直接查看:J9k.3日但出。語&E*岳es$knQtbglook劈xqDocumentsReports-如ndowHelp.國XI您0?日B國K電喳營運后心■■■…殖］圖!*PL/SQLDeveloperfmisOODO^WG-[TestWindow-SciiptForfunctiofiEKESTODJ@WGl。分=觸AlobiectE日FundiGmS?B&JIHEROUND⑥BIT_AND■⑥bitZhot?EIT』R?BITJCOR?CHAIRINDEX11Testscf取|DEMSOutput|Stab3bcs|Prditer|Tiace|?□，Q&士.千王句士-ffi-田句土田田由*田王由田王CHARINDEX.FROMBACDATEFWRTDATETOSTRDAYDAY-DATEDIFFEXISTOBJEXIGTSETEXISTSROWFRACGETDATEGETDIFRUEMPARENTGETS儂匚EGET_BETWEENicountNWEEB;OBJOWE^.VAJUCHilRZ《孫；--更法科祠:BEGINicountG；IfvOWffERisnullttwADEJOWEB:-S￥S_CO]/TEXT["UEEE.EW,1CUBJIE}TT_S：CHEMA11;elseDBJQWEKvaimER;andit;fFeJLectCQuivti：，)xntaLcoimtiftuft5Y3,ALLOBJECTSOWESl?UPI>E(OBJOWElendOBJECTPEBJvOEJNAJIE>AndOBJECTTIfleouac1thenVariabls|VdusCalstackgQ同門已FHISOOOO-^EXISTOBJtine1國短皿cor<仃JmrTew尿。m0口Conslante_*j1￡口DefauftE-LJDMLstaiernenis串口EriorhandlE二|=TestWindow二￡口口lorfundicriEMS|\|16；1-^Ksoutg二-Ifilx|-ISIx|戊0一日BB/電喳營運后業(yè)田管?…喳］禺Q?*出3給?Testscrip*|DEMSOutput|Stab3bcs|Prdifer|Tiace|+PL/SQLDeveloperfmisOODO^WG-[TestWindow-SciiptForfunctiofiEKESTODJ@WGl注fileProjedtEditiesjkxiQtbuglookm*ixoDfitawnt，Efflb*iyndowHdpX1圳網(wǎng)IBM?分=依口ConslanteP\DefautLJDMLstaiemenis口EriorhandlinciTestWindow■SciipllartuxticriE葡Sis-Cr*atidb-y一20也-亂寸leountNUMBER；OBJOWERVAJUClDLBNmn--JPJ?時■闕；20M-C7-OJBEGINicowta；ifUOTOERIkniilltlwADEJOWEB: