ORACLE APPLICATION EXPRESS 50 升级.docVIP

Oracle APEX Tutorial, Tabular Form 1-?Introduction 2-?Create a Tabular Form using Wizard 3-?Create Tabular Form manually 4-?Handling Tabular form 4.1-?Add rows 4.2-?Multiple row update 4.3-?Deleting multiple rows immediately 4.4-?Deleting multiple rows - Prompt before deleting 5-?Maybe you are interested 1- Introduction You are viewing guidelines for programming?Oracle APEX 5.0. This is the 2nd document which next of: Oracle APEX Tutorial for Beginners Included in this document, I will continue to guide you on?Oracle APEX Database Desktop Application, using Tabular Form. 2- Create a Tabular Form using Wizard Log in to?Oracle APEX?with?programmers account. http://localhost:8080/apex Go to?Database Application. Next, going to?Hello Database Desktop Application??that you created in the previous?guidance In this application, there are a few pages created in the previous tutorial. Click Create Page to create another page. Create a?Tabular Form: Enter: Page: 7 Page Name: Emp Tabular Form (7) Your web page has been created, click RUN to test the newly created page. Page 7 is running: Here, the question arises as to how to change some input fields into?SELECT LIST or POPUP LOV (List of values).?For example, you want to choose a Manager?(MGR) through POPUP LOV, and select a Job through SELECT LIST. Return to the design?screen of page 7. Set the properties for the JOB column so that it displays as a SELECT LIST. Identification: Type:?Select List List of Values Type:?Static Value Static Value: ? 1 2 3 4 5 6 STATIC: CLERK;CLERK, SALESMAN;SALESMAN, PRESIDENT;PRESIDENT, MANAGER;MANAGER, ANALYST;ANALYST The syntax used to declare the static values? ? 1 STATIC:Display1;Return1,Display2;Return2 Next, you need to set the properties for the MGR so that it shows up as POPUP LOV (list of values) Identification: Type:?Popup LOV (shows display values) List of Values: Type:?SQL Query SQL Query:?Select emp.ename, emp.empno from Emp Similarly set the propert