User Manual - OPResume.com
Contents
1. Copyright by Mahmood Chowdhury User Manual Step by step guide on using UAO database in Oracle Apex By Mahmood Chowdhury November 29 2010 Final Project 60 415 Advanced and Practical Database System ORACLE Application Express Mahmood C ORACLE APEX Page 1 Copyright by Mahmood Chowdhury Introduction After the installation process as mentioned in the previous manual go ahead and run the UAO database application Application 144 UAO DATABASE Edit Application Properties J gt Run Application Supporting Objects Ay l od 1 Accommodationstaff 2 Accommodationstaff 4 TA 6 Halls Of Residence 7 Inspections Amm i E a 11 Lease 12 Lease ame e Paca Se E IERE Sharet Semponents Utilities Export Import Go ISIE Cations Fi m 3 Advisor Of Studies r ad od oe Inspections A m 13 Location A CENNO Click to run the UAO database Am 4 Advisor Of Studies 5 Halls Of Residence A u 9 Report 2 10 Form on INVOICE f Fi om 14 Location 16 Report 1 rp Fi m EF Se Se Fy Se Mahmood C ORACLE APEX Page 2 Copyright by Mahmood Chowdhury Once the application opens you will see a window with all your tables in tabular format The report which will display some data if you have already entered using sqlplus will appear on the body of the screen Accommodat2. Position Rooms Studentflatinspections Studentflats Accommodationstaff gt Accommodationstaff Cancel i Delete Apply Changes Staffnumber 3 Leasenumber 999999 Flatnumber 1111 Name PEER Enter data into the empty field or change information into an existing field Dob Sex Location Hall Position Enter data into the empty fields or change information in an existing field Mahmood C ORACLE APEX Page 7 Copyright by Mahmood Chowdhury Welcome BANDARA Logout a aaa ee EE Accommodationstaff Advisor Of Studies Halls Of Residence Inspections Invoice Lease Location Next Of Kin Position Rooms Studentflatinspections Studentflats Accommodationstaff gt Accommodationstaff Apply Changes Staffnumber 3 Leasenumber 999999 Flatnumber 1111 Name Richard Geere Address 121 Hollywoodland Ave Dob 01 Nov 10 Sex Male Location Hall Position Hall Manager e In this example we entered data into Name Address DOB SEX Location and Position fields as shown in the above picture Once done click Apply Changes Welcome BANDARA Logout Advisor Of Studies Halls Of Residence Inspections invoice Lease Location Next Of Kin Position Rooms Studentflatinspections Accommodationstaff Accommodationstaff Action Processed x pe Go Actions w Create Staffnumber Leasenumber Filatnumber Addr
3. ess P 3 999999 1111 Richard Geere 121 Hollywood Ave 01 NOV 10 Male Hall Hall Manager Ta 1989564325 999999 1111 rasika b 121 campbell avenue 01 NOV 10 male Hall Hall Manager 3 1989564326 999999 1111 Mahmood Chowdhury 401 Sunset Avenue 10 NOV 10 Male Hall Hall Manager f 1 999999 1111 John Smith 34 Kin Kent ON N9G 3T5 17 SEP 45 Male Hall Admin Asst 8 2 888888 2222 Due Wang 12 Yun Kent ON N9G 3T 23 OCT 65 MALE Accommodation Office Hall Manager 1989564324 999999 1111 Rasika 123 no road M Hall Hall Manager 1 6 X If successful the Action Processed message will appear on top of the report Mahmood C ORACLE APEX Page 8 Copyright by Mahmood Chowdhury Delete Remove Data To delete a data from any table select the table from the tabs click the Pencil icon of the record you wish to delete A window similar to the update window will appear and you will see a Delete option on top right hand corner Click Delete and you have successfully deleted the desired record In this example we wish to delete StaffNumber 1989564324 from the Accommodationstaff table By clicking the Pencil Icon beside this Staffnumber on the Accommodationstaff report we will get the following screen Welcome BANDARA Logoi Cancel Delete Apply Changes Staffnumber 1989564324 Leasenumber 999999 Flatnumber 1111 Now click on Delete button to remove this record from our Acc
4. ionstaff 4 Jhttp proton cspcl uwindsor ca 8081 apex f p 144 1 29469297111227 Welcome BANDARA Logait AdvisorOfStudies HallsOfResidence Inspections Invoice Lease Location Next Of Kin Position Rooms Studentflatinspections Studentflats Accommodationstaff tcommodationstaff Go Actions v Leasenumber Flatnumber Hall 999999 Tables in Hall Manager tabular format 1989564325 999999 1111 rasika b 121 campbell avenue 01 NOV 10 male Hall Pd 1 999999 1111 John Smith 34 Kin Kent ON N9G 3T5 17 SEP 45 M Hall Admin Asst f 2 888888 2222 Due Wang 12 Yun Kent ON N9G 3T5 23 OCT 65 M Accommodation Office Hall Manager 3 1989564324 999999 1111 Rasika 123 no road M Hall Hall Manager 1 5 Reports containing existing data in table Accommodationstaff To create a new record click the Create button Home Application 144 EditPage1 Create Session Caching View Debug Debug Show Edit Links EEE a Figure 1 Create Insert record Mahmood C ORACLE APEX Page 3 Copyright by Mahmood Chowdhury To create insert a record click the Create button as shown in Figure 1 The following window will open Welcome BANDARA Logout m Accommodationstaff Advisor Of Studies Halls Of Residence Inspections Invoice Lease Location Next Of Kin Position Rooms Studentflatinspections Studentfla
5. ommodationstaff table You will get a pop up message confirming the deletion Mahmood C ORACLE APEX Page 9 Copyright by Mahmood Chowdhury Welcome BANDARA Logout i Accommodationstaff Advisor Of Studies Halls Of Residence Inspections invoice Lease Location Next Of Kin Position Rooms Studentflatinspections Studentflats Accommodationstaff gt Accommodationstaff aig Fn JOU pA http proton cspc1 uwindsor ca 8081 Apply Changes Staffnumber 1989564324 Would you like to perform this delete action Leasenumber 999999 Ftnumber C1111 Name Rasika Address 123 no road Dob Sex M Location Hall Position Hall Manager When clicked OK the record is deleted from the Accommodationstaff table and Action Processed message will appear on top of the report von Accommodationstaff Advisor Of Studies Halls Of Residence inspections Invoice Lease Location Next Of Kin Position Rooms Studentflatinspe Accommodationstaff Ao Ge Cations Create Staffnumber Leasenumber Flatnumber Name Address Dob Sex Location P 3 999999 1111 Richard Geere 121 Hollywood Ave 01 NOV 10 Male Hall Hall Manager P 1989564325 999999 1111 rasika b 121 campbell avenue 01 NOV 10 male Hall Hall Manager 3 1989564326 999999 1111 Mahmood Chowdhury 401 Sunset Avenue 10 NOV 10 Male Hall Hall Manager gt 1989564327 123436 2222 Steve Jobs 234 Cupo
6. rtino 04 MAY 10 Male Hall Hall Manager P 1 999999 1111 John Smith 34 Kin Kent ON N9G 3T5 17 SEP 45 Male Hall Admin Asst P 2 888888 2222 Due Wang 12 Yun Kent ON N9G 3T5 23 OCT 65 MALE Accommodation Office Hall Manager 1 6 Mahmood C ORACLE APEX Page 10
7. s can only be Hall Manager Administrative Assistant and Cleaner ORA 06512 at BANDARA STAFF_POSITION line 3 ORA 04088 error during execution of trigger BANDARA STAFF_POSITION x Error Unable to process row of table ACCOMMODATIONSTAFF OK Mahmood C ORACLE APEX Page 6 Copyright by Mahmood Chowdhury To correct the above mistakes go back to the form input the proper data into respective fields and click Create Update Data If you wish to update a data all you have to do is click the pencil icon and a window will appear that will allow you to change any value of any field Accommodationstaff Advisor Of Studies Halls Of Residence inspections invoice Lease Location Next Of Kin Position Rooms Accommodationstaff Action Processed x P 4 Go Actions v Create 3 999999 1111 Hall 1989564325 999999 1111 rasika b 121 campbell avenue 01 NOV 10 male Hall Hall Manager 1989564326 999999 1111 Mahmood Chowdhury 401 Sunset Avenue 10 NOV 10 Male Hall Hall Manager 1 999999 1111 John Smith 34 Kin Kent ON N9G 3T5 17 SEP 45 M Hall Admin Asst 2 888888 2222 Due Wang 12 Yun Kent ON N9G 3T5 23 OCT 65 M Accommodation Office Hall Manager 1989564324 999999 1111 Rasika 123 no road M Hall Hall Manager 1 6 Click the Pencil Icon to update a record Welcome BANDARA Logout al Accommodationstaff Advisor Of Studies Halls Of Residence inspections Invoice Lease Location Next Of Kin
8. ts Accommodationstaff gt Accommodationstaff Cancel Create Staffnumber 1989564326 Leasenumber 999999 Flatnumber 1111 Address 401 Sunset Avenue Dob 10 Nov 10 E Sex Male Location Hall Position Hall Manager Fill out the required fields in this example we are using the Accommodationstaff table such as Leasenumber Flatnumber Name etc To choose the date click the calendar icon After all the information have been inputted click the Create button on top right hand side Mahmood C ORACLE APEX Page 4 Copyright by Mahmood Chowdhury Welcome BANDARA Logoul Accommodationstaff Advisor Of Studies Halls Of Residence Inspections Invoice Lease Location Next Of Kin Position Rooms Studentflatinspections Studentflats Accommodationstaff Actions v Action Processed zj Create 3 999999 1989564325 999999 1 999999 2 888888 S P J 1989564326 999999 P P P 1989564324 999999 1111 1111 1111 Tii 2222 1111 rasika b Mahmood Chowdhury John Smith Due Wang Rasika 121 campbell avenue 401 Sunset Avenue 34 Kin Kent ON N9G 3T5 12 Yun Kent ON N9G 3T5 123 no road 01 NOV 10 10 NOV 10 17 SEP 45 23 OCT 65 Hall male Hall Male Hall M Hall M Accommodation Office Hall M Hall Manager Hall Manager Admin Asst Hall Manager Hall Manager 1 6 If your entries are valid it will redirect yo
9. u to the table form in this case Accommodationstaff and you will see your entries in the report for our example StaffNumber 1989564326 and you will notice a message displaying Action Processed with green background above the report If for some reason you have entered an incorrect information in any of the fields in any form Apex will display an error message Let s take an example of Accommodationstaff Mahmood C ORACLE APEX Page 5 Copyright by Mahmood Chowdhury Accommodationstaff Advisor Of Studies Halls Of Residence inspections in Accommodationstaff gt Accommodationstaff Staffnumber 1989564328 Leasenumber 123436 Flatnumber 1111 Name Mickey Mouse Address 123 rankin avenue eerrreeee Dob 13 Sep 10 Sex Male Location Wi ndsor Position Teacher In this example our location and position fields are incorrect The UAO database only accepts Location as Hall or Accommodation office and position only accepts Hall Manager Administrative Assistant or Cleaner Since we entered Location Windsor and Position Teacher the following error messages will display Welcome BANDARA ORA 20202 The locations can only be Hall and Accommodation Office ORA 06512 at BANDARA STAFF_LOCATION line 3 ORA 04088 error during execution of trigger BANDARA STAFF_LOCATION x Error Unable to process row of table ACCOMMODATIONSTAFF OK Welcome BANDARA ORA 20202 The position
Download Pdf Manuals
Related Search