PLSQLDeveloper安装使用手册

PLSQLDeveloper安装使用手册TOC\o"1-5"\h\z酉己置Oracle数据库连接4使用PLSQLDeveloper5连接Oracle数据库5执行SQL语句5在SQL窗口中执行5在命令行窗口中执行8创建数据库中的对象10在SQL窗口中创建10在命令行窗口中创建10用模板创建10查看数据库中的对象13从SQL窗口中打开查看窗口13从对象浏览器中打开查看窗口14调试函数/存储过程15

i.运行安装程序，出现如下界面:2.点Next,出现以下界面:3.点Next,出现如下界面:4.点Finish,开始安装。完成后出现如下界面:fPL;SQLDe”他卡计InrStalatlonSerialnumber0k0998-UnlimiteduserlicenseallroundautomationsPrupunragimslt&ll.CapryingiFil&s...5.点Prupunragimslt&ll.CapryingiFil&s...5.点Close退出即可。.配置Oracle数据库连接本部分内容请参见《Oracle安装配置手册》.使用PLSQLDeveloper连接Oracle数据库1.运行PLSQLDeveloper,弹出如下窗口:2.输入正确的用户名、密码、数据库名，并选择正确的连接身份后即可进入。注意：数据库名是指在本机设置的数据库别名执行SQL语句在SQL窗口中执行.在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,产生一个SQL窗口，如图:.按F8执行一条SQL查询语句，结果如图:&PL/SQLDeveloper-FmisDCOO^WG士gIe肝口jsctEdtSessionQebugJoobMacroDgCLmentsdepartsWindow也Ip■:应修•m昌躇g茁船聒崎也学挛洞超里&PL/SQLDeveloper-FmisDCOO^WG士gIe肝口jsctEdtSessionQebugJoobMacroDgCLmentsdepartsWindow也Ip■:应修•m昌躇g茁船聒崎也学挛洞超里匕科？■I口区|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执行一条输出信息语句，如图: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在命令行窗口中执行.在File的下拉菜单中选New,界面同3.2.1中的第一步的界面。.选择CommandWindow,产生一个命令行窗口:

⑴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^^创建数据库中的对象在SQL窗口中创建与3.2.1中执行SQL查询语句的方法类似，在SQL窗口中执行创建语句即可。在命令行窗口中创建与3.2.2中执行SQL查询语句的方法类似，在命令行窗口中执行创建语句即可。用模板创建此处以创建表为例.在File的下拉菜单中选New,再选择Table;或者直接在对象浏览器中的Tables目录上点右键选New。出现如下界面：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,即创建表A。查看数据库中的对象从SQL窗口中打开查看窗口1.打开一个空白的SQL窗口，输入对象名，如前面建的表A,在对象名上点右键，如图:2.选才VView,出现如图界面，可切换页面查看表的信息；如果选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.调试函数/存储过程1.首先打开调试窗口，调试窗口可以从SQL窗口中打开，也可以从对象浏览器中打开。在SQL窗口中按如下方法打开：打开一个空白的SQL窗口，输入函数或存储过程名，如EXISTOBJ,在对象名上点右键，再选择Test。在对象浏览器中按如下方法打开：展开函数或存储过程目录，选择所需调试的函数或存储过程，如EXISTOBJ，点右键，再选择Test。如图：2.选择了Test以后打开的调试窗口如图所示:

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是返回的结果参数，其他是需要传入的参数，输入以后按F9,界面如图：an•日b国k电喳营运后心■■■…殖］图PL/SQLDeveloperfmiM000@WG-[TestWindow-5ciiptForfunctiofiEKESTODJ@WGl据?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,进入函数EXISTOBJ:Testscf取|DEMSOutput|Stab3bcs|Prditer|Tiace|X。中=触，Alobiects[£口Recent电已函因七JFundions由七Rocedure^E-O田口Fackogebodi&s0LJTyvfrs由二JbodiesE-LJTriggei?5口Javasources区口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圳网的。小。触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/电喳营运后业田管♦…喳］禺Q・*出3给?Testscrip*|DEMSOutput|Stab3bcs|Prdifer|Tiace|+PL/SQLDeveloperfmisOODO^WG-[TestWindow-SciiptForfunctiofiEKESTODJ@WGl注fileProjedtEditiesjkxiQtbuglookm*ixoDfitawnt，Efflb*iyndowHdpX1圳网IBM?分=依口ConslanteP\DefautLJDMLstaiemenis口EriorhandlinciTestWindow■SciipllartuxticriE葡Sis-Cr*atidb-y一20也-乱寸leountNUMBER；OBJOWERVAJUClDLBNmn--JPJ?时■阙；20M-C7-OJBEGINicowta；ifUOTOERIkniilltlwADEJOWEB: