Introduction to Oracle Developer 10g

GITS-Product&TechnologyTeam1OracleDeveloper10g1.IntroductiontoOracleDeveloper10g2.NewFeaturesforForm10g3.NewFeaturesforReport10g4.NewFeaturesforothercomponents5.Demonstration6.Q&AGITS-Product&TechnologyTeam2HistoryDeveloper2000,4.x,5.x,6.x(patch16),9i,10gLatestversionis10gRel2(10.1.2)butnoform/reportisincludedLatestfull-setversionis10gRel1(9.0.4)&soallthenamingforformURLisstillf90xxxxGITS-Product&TechnologyTeam3OracleSupportDirectionGITS-Product&TechnologyTeam4CertificationMatrixOSApplicationServerDatabaseServerStatus2000SP3+/2003/XP10g(9.0.4)9.2Certified2000SP3+/2003/XP10g(9.0.4)8.1.7(8i)Certified2000SP3+/2003/XP10g(9.0.4)10gCertifiedGITS-Product&TechnologyTeam5ArchitectureOracleApplicationServer10gJdeveloperSoftwareConfigurationManagerDesignerFormsWarehouseBuilderBIBeansDiscovererReportsJ2EEInternetApplicationsBusinessIntelligenceGITS-Product&TechnologyTeam6FormArchitectureGITS-Product&TechnologyTeam7Form9iDeployWebFormbyservletinsteadofCGIUsestandardport80/443fordeploymentReplaceenvironmentvariableswithDEFAULT.ENVSupportmulti-timezone:DATETIME_SERVER_TZ,DATETIME_LOCAL_TZSupportlengthsemanticsinvariabledeclaration:VARCHAR2(10CHAR),VARCHAR2(10BYTE)GITS-Product&TechnologyTeam8Form9iUseJavaDesign-timeAPI(JDAPI)tomodifyformAbletoconvertformtoXMLorviceversaAllowtocancellong-runningLOVUseONETIME_WHEREtochangequeryinblocktemporarilyUseJavaImportertoconvertjavaclassintolocalPL/SQLunitsNoformruntime&needtorunalocalservlet(OC4J)engineinordertorunformAuto-detectlanguagesettinginclients’browserGITS-Product&TechnologyTeam9Form9i–upgradeReplaceRUN_PRODUCTwithRUN_REPORT_OBJECTReplacefixed-lengthpropertywithformatmaskStricterenforcementontriggers,e.g.WHEN-BUTTON-PRESSEDinitemlevelonlyStricterenforcementonitemproperty,e.g.DisplayItemwith“Required=Yes”mustbefilledin(notin6i)GITS-Product&TechnologyTeam10Form10gNamingforformfilesisifxxxx90.*“Form&ReportOnly”optionforAS:installwithout10ginfrastructuretosimplifyupgrade(amustfor9iAS)FormRuntimePrestartEnginestospeedupresponseRestrictedURLparameterstoincreasesecuritySingleSignOn(SSO)throughOracleInternetDirectory(OID)SupportJ2EE1.4&J2SE5.0(1.5)GITS-Product&TechnologyTeam11Form10gUseWebUtil(e.g.TEXT_IO,HOST)toaccessclient’srestrictedresources(e.g.HD)IntegratewithOracleEnterpriseManager(OEM)toremotelymonitorFormServices(e.g.CPUusage&memory)Abletomanage(e.g.kill)FormsessionsthroughOEMAbletohideuserid/passwordfromURLGITS-Product&TechnologyTeam12Form10gSupportusingSunJavaruntimeinsteadofOracleproprietary‘jinitiator’SupportWindow7byusingSunJavaruntimeGITS-Product&TechnologyTeam13Report9i-ArchitectureGITS-Product&TechnologyTeam14Report9iAnyformat:HTML,PDF,XML,…Anysource:OracleDB,OLAP,XML,JDBC,TextfileAnywhere:file,printer,cache,emailAllowdeploymentthroughbothservletorCGISupportWebServicesAllowtoadddynamiccontentthroughURLNoParameterFormReplacesrw.set_attr(srw.set_attr_face)withsrw.set_xxx(srw.set_font_face)GITS-Product&TechnologyTeam15Report10gNamingforreportfilesisrwxxx.*SupportJSPtag&abletoconvertRDFtoJSP/XMLProvidejavaAPItodevelopcustomizedPluggableDataSources(e.g.JDBC,XML)ReplaceOracle6iGraphicswithbuilt-inhundredsofgraphicaloutputsEvent-drivenreportgenerationMulti-bytecharacter(e.g.chinese)supportinPDFGITS-Product&TechnologyTeam16Report10gAllowtoemailreportoutputthroughstandardSMTPserverAbletomonitor&managereportjobsthroughOEMSSOthroughOIDIntegratewithSoftwareConfigurationManagertoprovideversioncontrolUseJavaImportertoconvertjavaclassintolocalPL/SQLunitsGITS-Product&TechnologyTeam17Discoverer10gJavaCommand-lineToolforEULMaintenanceSupportSSOthoughOIDDirectaccesstoOracleOLAPProvideeasy-to-usewizardforpoweruserstogenerateanalyticEISreportsGITS-Product&TechnologyTeam18Jdeveloper10gProvideApplicationDevelopmentFramework(ADF)tosupportModel-View-Controller(MVC)architectureGITS-Product&TechnologyTeam19Jdeveloper10gsupportJava,WebServices,XML,SQLinasingleplatformOne-clickcreationofwebservciesfromjavaclasswizardforimportingEJBIntegratewithOracleASToplinkdraganddropWSDLfromUDDIbrowserXMLschemaeditorGITS-Product&TechnologyTeam20SoftwareConfigurationManager10gIntegratewithForm,Report,Jdeveloper,Discoverer&Designertoprovideversioncontrol&check-in/check-outProvide“DependencyAnalyzer”toinvestigatethewholeimpactforanychangetoaspecificcodingunitAbletocomparethecodingdifferenceforFMB&RDFGITS-Product&TechnologyTeam21ToolsOracle’stoolstoaccessDBbymanuallykeyinSQLstatement“Toad”forOracleDB(from“QuestSoftware”):GUItoolsfordeveloperorDBAtoaccessdatabase(easytouse,noneedtorememberSQLstatement)GITS-Product&TechnologyTeam22DemonstrationGITS-Product&TechnologyTeam23Q&A