Note: You can view the full content of our pages on any browser or Internet device. However, our pages look best in browsers that support Web Standards.

Oracle Web Application Programming for PL/SQL Developers

Solutions Specification for students_left_nav

Description: The left nav bar menu for Students. Load into 'students_left_nav' frame.

Sample Screen

students_left_nav.gif

Sample Code

CREATE OR REPLACE PROCEDURE students_left_nav
  AS
BEGIN
------------------------------------------------------------------------------

-- FILE           : students_left_nav.sql
-- CREATED BY     : Solomon Morse
-- CREATED BY DATE: January 12, 2003
-- URL            : students_left_nav

------------------------------------------------------------------------------
   htp.p('
<HTML>
<HEAD>
<TITLE>Student Left Nav</TITLE>
</HEAD>
<BODY>
<TABLE BORDER="0" WIDTH="100%">
  <TR>
    <TD ALIGN="center"><A HREF="search_student" TARGET="students_main"><SMALL><FONT 
FACE="Arial">Search Student</FONT></SMALL></A>
    </TD>
  </TR>
  <TR>
    <TD ALIGN="center"><A HREF="student_personal_info" TARGET="students_main"><SMALL><FONT 
FACE="Arial">Add/Edit Student</FONT></SMALL></A>
    </TD>
  </TR>
</TABLE>
</BODY>
</HTML>
');

EXCEPTION
   WHEN OTHERS THEN
   htp.p('An error occurred on this page. 
          Please try again later.');
END; 
/

Select a Sample Application Code Unit

  1. main_frame (15.2)
  2. top_menu (13.3) / (15.2)
  3. splash (13.1)
  4. student_main_frame (6.3)
  5. students_left_nav (6.3)
  6. search_student (12.4)
  7. get_student (12.4)
  8. student_list (12.4)
  9. student_personal_info (12.4)
  10. student_zipcode (18.5)
  11. update_student (18.5)
  12. instruct (Package Spec and Body)
    • grade_calc (9.2)
    • v_font (9.4)
    • c_instruct_list (9.4)
    • inst_tbl_type (9.4)
    • instruct_table (9.4)
    • [PL/SQL block to load instruct_table] (9.4)
    • instruct_personal_info (11.3)
    • instructor_list_info (11.3)
    • showzip (11.3)
    • instructors_frame (11.1)
    • instructors_left_nav (11.1)
    • update_instructor (11.2)
    • instructor_list_class (11.3)
    • instruct_classes (11.3)
    • student_list (11.2)
  13. classes_main_frame (6.3)
  14. classes_left_nav (6, Building App)
  15. classes_list (6, Building App)
  16. classes_location (13.4)
  17. classes_location_update (13.4)
  18. set_cookie (15.2)
  19. get_cookie (15.2)
  20. cookie_exists (15.2)
  21. visitor_name (15.2)
  22. process_visitor_name (15.2)
  23. student_list_update (not in book)

Main Solutions Page