Oracle 2 Day + Application Express Developer’s Gui

Oracle®Database2Day+ApplicationExpressDeveloper’sGuideRelease3.2E11946-01July2009OracleDatabase2Day+ApplicationExpressDeveloper'sGuide,Release3.2E11946-01Copyright©2003,2009,Oracleand/oritsaffiliates.Allrightsreserved.PrimaryAuthors:DrueBaker,AnneRomano,TerriJenningsContributors:JoelKallman,SharonKennedyThissoftwareandrelateddocumentationareprovidedunderalicenseagreementcontainingrestrictionsonuseanddisclosureandareprotectedbyintellectualpropertylaws.Exceptasexpresslypermittedinyourlicenseagreementorallowedbylaw,youmaynotuse,copy,reproduce,translate,broadcast,modify,license,transmit,distribute,exhibit,perform,publish,ordisplayanypart,inanyform,orbyanymeans.Reverseengineering,disassembly,ordecompilationofthissoftware,unlessrequiredbylawforinteroperability,isprohibited.Theinformationcontainedhereinissubjecttochangewithoutnoticeandisnotwarrantedtobeerror-free.Ifyoufindanyerrors,pleasereportthemtousinwriting.IfthissoftwareorrelateddocumentationisdeliveredtotheU.S.GovernmentoranyonelicensingitonbehalfoftheU.S.Government,thefollowingnoticeisapplicable:U.S.GOVERNMENTRIGHTSPrograms,software,databases,andrelateddocumentationandtechnicaldatadeliveredtoU.S.GovernmentcustomersarecommercialcomputersoftwareorcommercialtechnicaldatapursuanttotheapplicableFederalAcquisitionRegulationandagency-specificsupplementalregulations.Assuch,theuse,duplication,disclosure,modification,andadaptationshallbesubjecttotherestrictionsandlicensetermssetforthintheapplicableGovernmentcontract,and,totheextentapplicablebythetermsoftheGovernmentcontract,theadditionalrightssetforthinFAR52.227-19,CommercialComputerSoftwareLicense(December2007).OracleUSA,Inc.,500OracleParkway,RedwoodCity,CA94065.Thissoftwareisdevelopedforgeneraluseinavarietyofinformationmanagementapplications.Itisnotdevelopedorintendedforuseinanyinherentlydangerousapplications,includingapplicationswhichmaycreateariskofpersonalinjury.Ifyouusethissoftwareindangerousapplications,thenyoushallberesponsibletotakeallappropriatefail-safe,backup,redundancy,andothermeasurestoensurethesafeuseofthissoftware.OracleCorporationanditsaffiliatesdisclaimanyliabilityforanydamagescausedbyuseofthissoftwareindangerousapplications.OracleisaregisteredtrademarkofOracleCorporationand/oritsaffiliates.Othernamesmaybetrademarksoftheirrespectiveowners.Thissoftwareanddocumentationmayprovideaccesstoorinformationoncontent,products,andservicesfromthirdparties.OracleCorporationanditsaffiliatesarenotresponsibleforandexpresslydisclaimallwarrantiesofanykindwithrespecttothird-partycontent,products,andservices.OracleCorporationanditsaffiliateswillnotberesponsibleforanyloss,costs,ordamagesincurredduetoyouraccesstooruseofthird-partycontent,products,orservices.iiiContentsPreface................................................................................................................................................................viiTopicOverview..........................................................................................................................................viiAudience.....................................................................................................................................................viiiDocumentationAccessibility...................................................................................................................viiiRelatedDocuments.....................................................................................................................................ixConventions.................................................................................................................................................x1IntroducingOracleApplicationExpressAboutOracleApplicationExpress........................................................................................................1-1UnderstandingOracleApplicationExpressArchitecture................................................................1-1AbouttheOracleApplicationExpressEnvironment........................................................................1-2AboutWorkspaces.............................................................................................................................1-3AboutOracleApplicationExpressUserRoles...................................................................................1-3OverviewoftheApplicationYouBuild..............................................................................................1-42AccessingYourDevelopmentEnvironmentBeforeYouBegin......................................................................................................................................2-1AccessingtheHostedDemoEnvironment..........................................................................................2-2LoggingIntotheHostedDemoEnvironment..............................................................................2-3SettingUpYourOwnLocalEnvironment..........................................................................................2-3Logg