资源描述：
《oracle application express 升级(推荐)》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、OracleAPEXTutorial,TabularForm1- Introduction2- CreateaTabularFormusingWizard3- CreateTabularFormmanually4- HandlingTabularform4.1- Addrows4.2- Multiplerowupdate4.3- Deletingmultiplerowsimmediately4.4- Deletingmultiplerows-Promptbeforedeleting5- Maybeyouareinterested1-IntroductionYo
2、uareviewingguidelinesforprogramming OracleAPEX5.0.Thisisthe2nddocumentwhichnextof:·OracleAPEXTutorialforBeginnersIncludedinthisdocument,Iwillcontinuetoguideyouon OracleAPEXDatabaseDesktopApplication,usingTabularForm.2-CreateaTabularFormusingWizardLoginto OracleAPEX with programmer's
3、account.·http://localhost:8080/apexGoto "DatabaseApplication".Next,goingto "HelloDatabaseDesktopApplication" thatyoucreatedintheprevious guidanceInthisapplication,thereareafewpagescreatedintheprevioustutorial.Click"CreatePage"tocreateanotherpage.Createa TabularForm:Enter:·Page:7·Pa
4、geName:EmpTabularForm(7)Yourwebpagehasbeencreated,clickRUNtotestthenewlycreatedpage.Page7isrunning:Here,thequestionarisesastohowtochangesomeinputfieldsinto SELECTLISTorPOPUPLOV(Listofvalues). Forexample,youwanttochooseaManager (MGR)throughPOPUPLOV,andselectaJobthroughSELECTLIST.Retu
5、rntothedesign screenofpage7.SetthepropertiesfortheJOBcolumnsothatitdisplaysasaSELECTLIST.Identification:·Type: SelectListListofValues·Type: StaticValue·StaticValue:?123456STATIC:CLERK;CLERK,SALESMAN;SALESMAN,PRESIDENT;PRESIDENT,MANAGER;MANAGER,ANALYST;ANALYSTThesyntaxusedtodeclareth
6、estaticvalues ?1STATIC:Display1;Return1,Display2;Return2Next,youneedtosetthepropertiesfortheMGRsothatitshowsupasPOPUPLOV(listofvalues)Identification:·Type: PopupLOV(showsdisplayvalues)ListofValues:·Type: SQLQuery·SQLQuery: Selectemp.ename,emp.empnofromEmpSimilarlysetthepropertiesfor
7、DEPTNO,sothatitdisplaysasaPOPUPLOV.Identification:·Type: PopupLOV(showsdisplayvalues)ListofValues·Type: SQLQuery·SQLQuery: Selectd.dname,d.deptnofromDeptdSaveandrunthePage7:3-CreateTabularFormmanuallyAbove,IshowedyouhowtocreateaTabularForm byusingthewizardof OracleApex. Nextwewillcr
8、eatecompletelyfroms
