Allround Automations PL/SQL Developer 13.0.2.1898 Multilingual-數據庫管理工具 L/SQLDeveloper是一款集成開發環境,用於開發、測試、調試和優化OraclePL/SQL存儲的程序單元,如包、觸發器等。PL/SQLDeveloper的功能包括上下文相關幫助和數據庫對象描述、語法加亮、數據查詢和編輯、圖形瀏覽器等,這些功能使開發人員的工作更為輕鬆。 PL/SQLDeveloperisanIntegratedDevelopmentEnvironmentthatisspecificallytargetedatthedevelopmentofstoredprogramunitsforOracleDatabases.OvertimewehaveseenmoreandmorebusinesslogicandapplicationlogicmoveintotheOracleServer,sothatPL/SQLprogramminghasbecomeasignificantpartofthetotaldevelopmentprocess.PL/SQLDeveloperfocusesoneaseofuse,codequalityandproductivity,keyadvantagesduringOracleapplicationdevelopment. ThefollowingaremajorfeaturesofPL/SQLDeveloper: PowerfulPL/SQLEditor WithitsSyntaxHighlighting,SQLandPL/SQLhelp,ObjectDescriptions,CodeAssistant,CompilerHints,Refactoring,PL/SQLBeautifier,CodeContents,CodeHierarchy,CodeFolding,HyperlinkNavigation,MacroLibraryandmanyothersophisticatedfeatures,theUnicodecomplianteditorwillevenappealtothemostdemandinguser.Informationisautomaticallypresentedtoyouwhenyouneedit,orisatmostoneclickaway. IntegratedDebugger Theintegrateddebuggeroffersallfeaturesyoucouldwishfor:StepIn,StepOver,StepOut,RunUntilException,Breakpoints,View&SetVariables,ViewCallStack,andsoon.Youcandebuganyprogramunitwithoutmakinganymodificationtoit,includingtriggersandobjecttypes. PL/SQLBeautifier ThePL/SQLBeautifierallowsyoutoformatyourSQLandPL/SQLcodethroughauser-definedsetofrules.Yourcodecanautomaticallybebeautifiedwhenyoucompile,save,oropenafile.ThisfeaturewillincreaseyourcodingproductivityandwillimprovethereadabilityofyourPL/SQLcodeifyouareworkinginlargeprojectteams. SQLWindow TheSQLWindowallowsyoutoenteranySQLstatementormultiplestatementsandvieworedittheresultsinagrid.TheresultgridsupportsaQueryByExamplemodetosearchspecificrecordsinaresultset.YoucaneasilyrecallpreviouslyexecutedSQLstatementsfromahistorybuffer.TheSQLeditorprovidesthesamepowerfulfeaturesasthePL/SQLEditor. CommandWindow TodevelopandexecuteSQLscriptsyoucanusePL/SQLDeveloper'sCommandWindow.ThiswindowhasthesamelookandfeelasSQL*Plus,andadditionallyhasabuilt-inscripteditorwithcorrespondingsyntaxhighlighting.Nowyoucandevelopyourscriptswithoutthe"editscript/saveit/switchtoSQL*Plus/runscript"cycle,andwithoutleavingthecomfortablePL/SQLDeveloperIDE. Reports TorunreportsagainstyourapplicationdataoragainsttheOracledictionary,youcanusePL/SQLDeveloper'sbuilt-inReportfunctionality.Thereareanumberofstandardreports,andyoucaneasilycreateyourowncustomreports.Thesecustomreportscanbesavedinareportfile,whichcaninturnbeincludedinthereportsmenu.Thismakesitveryeasytorunyourownfrequentlyusedcustomreports. Diagrams TheDiagramWindowallowsyoutocreateagraphicalrepresentationofaselectionofobjects.Thiswayyoucaneasilyvisualize(apartof)thedatabaseobjectsofyourapplicationorprojectandtheirrelations.Adiagramcanbeusedfordocumentationpurposes,butcanalsoserveasaworkspace.Right-clickingonanobjectprovidesaccesstoallobjectfunctions,anddouble-clickingonanobjectwillinvokethedefaultactionfortheobjecttype. Projects ToorganizeyourworkyoucanusePL/SQLDeveloper'sbuilt-inprojectconcept.Aprojectconsistsofacollectionofsourcefiles,databaseobjects,notes,andoptions.Itallowsyoutoworkwithinthescopeofaspecificsetofitems,insteadofacompletedatabaseorschema.Thismakesiteasytofindtheprojectitemsyouneed,tocompileallprojectitems,ortomoveaprojectfromonelocationordatabasetoanother. RegressionTesting ForregressiontestingyoucanusePL/SQLDeveloper'sbuilt-inTestManager.YoucandefineandrunaTestSet,andquicklydetermineifalltestsruncorrectly.Incaseofanerror,theTestManagercanlaunchtheDebuggertoinvestigatethecauseoftheerror.YoucanrunTestSetsfromtheCommandWindowforautomatedregressiontesting. To-DoItems YoucanuseTo-DoItemsinanySQLorPL/SQLsourcefiletomakeaquicknotethatsomethingneedstobedoneinthissourcefile.YoucanaccessthisinformationlaterfromtheTo-DoList,eitherattheobjectlevelorattheprojectlevel. andother...