Oracle WebDB 2.2 2000 4 : J01171-01
Oracle WebDB 2.2 : J01171-01 Oracle WebDB Creating and Managing Components - Task Help, Release 2.2 A77057-01 Susan Barton, David Mathews, Carol Menzigian Haranadh Abburu, Mark Clark, Susan Léveillé, Thiagarajan Natarajan, Frank Rovitto, Todd Vender, Hui Zeng Copyright 1999, Oracle Corporation. All rights reserved. Printed in Japan. * Oracle Corporation Oracle Corporation Restricted Rights Notice Restricted Rights Notice Programs delivered subject to the DOD FAR Supplement are "commercial computer software" and use, duplication, and disclosure of the Programs, including documentation, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, Programs delivered subject to the Federal Acquisition Regulations are "restricted computer software" and use, duplication, and disclosure of the Programs shall be subject to the restrictions in FAR 52.227-19, Commercial Computer Software - Restricted Rights (June, 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065.
1 2 3 WebDB 1.1 WebDB... 1-1 1.2... 1-2 1.3 Database Access Descriptor DAD... 1-4 1.4 WebDB... 1-5 1.5 WEBDB_DEVELOPER... 1-5 1.6 Oracle... 1-7 1.7 Oracle... 1-8 1.8... 1-10 1.9 Oracle... 1-11 1.10... 1-12 1.11... 1-12 WebDB 2.1... 2-1 2.2... 2-2 2.3... 2-2 2.4 WebDB... 2-3 2.5 WebDB... 2-4 3.1... 3-1 3.2... 3-2 3.3... 3-4 3.4... 3-5 iii
4 3.4.1... 3-5 3.4.2... 3-5 3.4.3... 3-6 3.4.4... 3-7 3.4.5... 3-9 3.5... 3-10 3.5.1... 3-10 3.5.2... 3-10 3.5.3... 3-11 3.5.4... 3-12 3.6 WebDB... 3-14 3.6.1... 3-14 3.6.2... 3-15 4.1 WebDB... 4-1 4.1.1... 4-1 4.1.2... 4-2 4.1.3... 4-3 4.1.4... 4-4 4.1.5... 4-5 4.1.6... 4-6 4.1.7 WebDB Web... 4-8 4.1.8... 4-9 4.1.9... 4-9 4.1.10... 4-11 4.1.11 SQL... 4-32 4.1.12 WebDB... 4-44 4.2 Oracle... 4-59 4.2.1 Oracle... 4-59 4.2.2... 4-60 4.3... 4-61 4.3.1... 4-61 4.3.2... 4-62 4.3.3... 4-63 iv
5 4.3.4... 4-64 4.3.5... 4-66 4.3.6... 4-67 4.3.7... 4-69 4.3.8... 4-80 4.3.9... 4-87 4.3.10 JavaScript... 4-91 WebDB 5.1... 5-1 5.2... 5-2 5.3... 5-3 5.4... 5-4 5.5... 5-5 5.5.1 DBA WEBDB_DEVELOPER... 5-5 5.5.2 Oracle... 5-6 5.6... 5-8 5.6.1... 5-8 5.6.2... 5-9 5.6.3... 5-10 5.7... 5-11 5.7.1... 5-11 5.8 Oracle Reports Security... 5-13 5.8.1 Oracle Reports Security... 5-13 5.8.2 Oracle Reports... 5-13 5.8.3 Cookie... 5-15 5.8.4... 5-16 5.8.5 :... 5-17 5.8.6 :... 5-17 5.8.7 :... 5-18 5.8.8 :... 5-18 5.8.9 :... 5-19 5.8.10 :... 5-21 5.8.11 :... 5-22 5.8.12 :... 5-23 v
6 7 5.8.13... 5-24 5.8.14... 5-26 5.8.15... 5-28 5.8.16... 5-29 5.9... 5-30 5.10 Oracle Reports... 5-31 5.11 Oracle Reports... 5-32 WebDB Oracle 6.1... 6-1 6.2... 6-2 6.3... 6-2 6.4 WebDB... 6-3 6.4.1... 6-3 6.4.2... 6-3 6.4.3 I/O... 6-4 6.4.4... 6-4 6.4.5... 6-4 6.5 WebDB... 6-5 6.5.1... 6-5 6.5.2... 6-6 6.5.3... 6-7 6.5.4 IP... 6-7 6.5.5... 6-8 6.6 Oracle... 6-10 6.6.1... 6-10 6.6.2 HTP... 6-10 6.6.3... 6-10 6.6.4... 6-11 6.6.5... 6-11 6.6.6... 6-12 Web 7.1 WebDB... 7-1 7.2 WebDB... 7-1 vi
8 9 7.3 Web... 7-3 8.1... 8-1 8.2... 8-2 8.3... 8-4 8.4... 8-5 8.5... 8-7 8.5.1... 8-7 8.5.2... 8-8 8.5.3... 8-9 8.5.4... 8-10 8.5.5... 8-11 8.5.6... 8-12 8.5.7 QBE... 8-13 8.5.8... 8-15 10 9.1 WebDB HTML... 9-1 9.2 WebDB... 9-2 9.3 Oracle WebDB PL/SQL Gateway Setting WebDB... 9-3 10.1 WebDB... 10-1 vii
viii
Oracle WebDB J01171-01 Oracle WebDB WebDB WebDB WebDB Adobe Acrobat PDF WebDB CD DOC_JA J01171-01.pdf WebDB Oracle WebDB J01169-01 Oracle WebDB Oracle WebDB WebDB WebDB WebDB CD DOC_JA QuickTour wbstart.htm J01169-01.pdf ix
Oracle WebDB J01168-01 Oracle WebDB J01171-01 Oracle WebDB J01170-01 Oracle WebDB J01173-01 Oracle WebDB J01172-01 Oracle WebDB 2.2 Windows NT Solaris WebDB Listener intermedia Text WebDB CGI WebDB Oracle Application Server WebDB WebDB WebDB WebDB WebDB CD DOC_JA J01168-01.pdf J01171-01.pdf J01170-01.pdf J01173-01.pdf J01172-01.pdf x
1 WebDB 1.1 WebDB WebDB WebDB WebDB HTTP WebDB WebDB WebDB WebDB WebDB 1-1
1.2 WebDB Listener PL/SQL Web WebDB PL/SQL WebDB WebDB Listener PL/SQL DBA WebDB DBA WebDB Database Access Descriptor DAD MIME PL/SQL 1. WebDB 2. Oracle WebDB PL/SQL Gateway Settings WebDB Apply 3. Change Listener Settings 1-2 Oracle WebDB 2.2
: Oracle WebDB PL/SQL Gateway Settings WebDB Change Listener Settings WebDB MIME MIME MIME application/excel xls WebDB Listener WebDB Listener PL/SQL Oracle WebDB 5 WebDB Listener WebDB Listener WebDB 1-3
Database Access Descriptor DAD 1.3 Database Access Descriptor DAD DAD DAD HTTP PL/SQL Oracle WebDB WebDB Web DAD WebDB Web DAD WebDB DAD DAD WebDB Windows NT Solaris WebDB WebDB Web DAD Web DAD MYSITE DAD WebDB Web DAD Web DAD S MYSITES DAD Web DAD 1-4 Oracle WebDB 2.2
WEBDB_DEVELOPER 1.4 WebDB WebDB WebDB Oracle WebDB WebDB ORACLE WebDB WebDB WebDB WEBDB_DEVELOPER WebDB SCOTT WebDB SCOTT WebDB 1.5 WEBDB_DEVELOPER WebDB 2 1 WebDB WebDB WebDB WebDB WEBDB_DEVELOPER WebDB WEBDB_DEVELOPER DBA WebDB Oracle DBA WebDB 1-5
WEBDB_DEVELOPER WebDB DBA WebDB Oracle Oracle WebDB WebDB WEBDB_DEVELOPER WebDB WebDB : WEBDB_DEVELOPER WEBDB_DEVELOPER 1-6 Oracle WebDB 2.2
Oracle 1.6 Oracle Oracle SELECT INSERT UPDATE DELETE EXECUTE Oracle Oracle WebDB Oracle WebDB EXECUTE WebDB 1-7
Oracle 1.7 Oracle DBA Oracle WebDB EXECUTE WebDB SELECT INSERT UPDATE DELETE EXECUTE SCOTT EXECUTE 1 1 1 1 Oracle 1. WebDB 2. 3. 4. / 5. 6. 7. 1 1 Oracle 1 1. WebDB 1-8 Oracle WebDB 2.2
Oracle 2. 3. 4. 5. 6. 7. 8. 1 : WEBDB_DEVELOPER DBA WebDB WEBDB_DEVELOPER DBA Sales_Personnel Headquarters_Personnel Sales_Personnel Headquarters_ Personnel WebDB 1-9
1.8 WEBDB_DEVELOPER WebDB WebDB WebDB 1 WebDB SELECT INSERT UPDATE DELETE EXECUTE SCOTT.EMP SCOTT.EMP SELECT SCOTT SCOTT.EMP WebDB JANE SCOTT EMP FRED JANE FRED FRED SCOTT.EMP SELECT JANE SCOTT.EMP : WebDB 1-10 Oracle WebDB 2.2
Oracle 1 1.9 Oracle Oracle SELECT INSERT UPDATE DELETE EXECUTE WebDB Oracle Oracle WebDB WebDB WebDB 1-11
1.10 DBA WEBDB_DEVELOPER WebDB WebDB SELECT INSERT UPDATE DELETE EXECUTE 1.11 WebDB WebDB JavaScript WebDB 1-12 Oracle WebDB 2.2
2 WebDB 2.1 WebDB 1. WebDB 2. 3. 4. 5. WebDB 2-1
2.2 WebDB WebDB WebDB WebDB ID ID WEBDB_DEVELOPER WebDB WebDB WebDB webdb.mycompany.com/webdb/ IP HTTP/1.00 WebDB Web Mozilla WebDB 2.3 WebDB 1. WebDB 2. : WebDB WebDB WebDB 2-2 Oracle WebDB 2.2
WebDB 2.4 WebDB WebDB WebDB WebDB WebDB WebDB WebDB 2 WebDB WebDB WebDB 2-3
WebDB 2.5 WebDB WebDB WebDB 1. WebDB 2. "object" object 3. 4. 2-4 Oracle WebDB 2.2
3 3.1 WebDB SCOTT SCOTT EMP EMP WebDB 3-1
: WEBDB_DEVELOPER WebDB HTML Web WebDB Oracle WebDB 1,000 1,000 3.2 1. WebDB 2. : 3. 4. %EMP% Employee Calc_ Employee_Salary 3-2 Oracle WebDB 2.2
5. : : 3 % SCO% SCOTT SCOUT 3-3
3.3 WebDB 1. WebDB 2. : 3. % EMP E% 4. 5. 6. 3-4 Oracle WebDB 2.2
3.4 3.4.1 WebDB 2 WebDB 1 QBE QBE : 3.4.2 QBE < > <= >= % 3-5
3.4.3 1. WebDB 2. : 3. 4. 5. 6. QBE QBE 7. 1 8. 9. QBE 10. 3-6 Oracle WebDB 2.2
: QBE % SCO% SCOTT SCOUT 3.4.4 1. WebDB 2. 3. : 4. 5. 6. QBE QBE 7. 1 Department Sales Job Title Clerk 3-7
8. 9. QBE 10. 11. Action 12. 1. 1 6 2. 3. 1. 1 11 2. : QBE NULL NULL 3-8 Oracle WebDB 2.2
3.4.5 1. WebDB 2. 3. 4. 5. 6. QBE 7. VARCHAR 8. 9. 3-9
3.5 3.5.1 WebDB Oracle SQL PL/SQL PL/SQL WebDB 1 3.5.2 1. WebDB 2. : 3. 4. 5. 6. 3-10 Oracle WebDB 2.2
7. 8. 3.5.3 PL/SQL 1. WebDB 2. : 3. 4. 5. 6. 7. : 3-11
3.5.4 1. WebDB 2. : 3. 4. 5. 6. SCOTT GIVE_RAISE SCOTT.EMP SCOTT.EMP 2 P_DEPTNO P_RAISE_ PERCENT 3-12 Oracle WebDB 2.2
: 7. P_DEPTNO 10 P_RAISE_PERCENT 7 8. 3-13
WebDB 3.6 WebDB 3.6.1 WebDB 1. WebDB 2. : DBA 3. 1 4. UI PRODUCTION 5. 7 6. 3-14 Oracle WebDB 2.2
WebDB 3.6.2 1. WebDB 2. : DBA 3. 1 4. UI PRODUCTION 5. 6. 7. 8. 3-15
WebDB 3-16 Oracle WebDB 2.2
4 4.1 WebDB 4.1.1 WebDB Web SQL WebDB 4-1
WebDB 2 3 OK PL/SQL WebDB URL 4.1.2 WebDB WebDB DBA WebDB WebDB FRED FRED SCOTT.EMP SELECT INSERT UPDATE DELETE SCOTT.EMP FRED 4-2 Oracle WebDB 2.2
WebDB 4.1.3 WebDB FRED FRED SCOTT.EMP SELECT INSERT UPDATE DELETE SCOTT.EMP FRED WebDB DBA 4-3
WebDB 4.1.4 WebDB SCOTT.EMP Accounting Operations Resarch SQL WebDB SQL WebDB 4-4 Oracle WebDB 2.2
WebDB / WebDB Employee 2 Employee Chart.Run Chart Parm Employee Chart.Run Chart WebDB 2 4.1.5 WebDB 1. WebDB 2. : / QBE 3. 4-5
WebDB 4.1.6 1. WebDB 2. : DBA 3. 4. : 1 5. 1 6. 4-6 Oracle WebDB 2.2
WebDB 7. : WebDB 4-7
WebDB 4.1.7 WebDB Web WebDB Web 1 1 WebDB View chart of employee salaries by department WebDB View individual employee salary Update employee salary 4-8 Oracle WebDB 2.2
WebDB WebDB 4.1.8 UI UI 1 UI WebDB WebDB 4.1.9 SCOTT.EMP EMPNO #owner.package-name.nextval # owner 4-9
WebDB package-name nextval name.nextval EMPNO DEPTNO SCOTT.EMP = #owner.get_default_dept EMPNO 4-10 Oracle WebDB 2.2
WebDB 4.1.10 4.1.10.1 WebDB WebDB Oracle HTML Web PL/SQL HTML JavaScript Web SQL SELECT ID ID Web WebDB QBE ID WebDB QBE / MD HTML Web 3 1 HTML 1 2 4-11
WebDB WebDB URL HTML 2 Web 1 4-12 Oracle WebDB 2.2
WebDB 4.1.10.2 SQL SQL WebDB ID SQL UI 1. WebDB 2. SCOTT : SCOTT 3. EXAMPLE_CAL 4. EXAMPLE_CAL 5. 4-13
WebDB 4.1.10.3 2 SQL SQL SQL WebDB SQL PL/SQL SQL SCOTT.EMP 4-14 Oracle WebDB 2.2
WebDB ALLEN JAMES MARTIN WebDB URL SQL SQL Web SYLK Excel 1. WebDB 2. SCOTT : SCOTT 3. EXMPLE_WIZ_CHART SQL EXAMPLE_SQL_CHART 4. 4-15
WebDB 5. 6. 4.1.10.4 Web Web HTML HTML Web <ORACLE> </ORACLE> SQL PL/SQL Web <ORACLE> </ORACLE> SQL SELECT 1. WebDB 2. SCOTT : SCOTT 3. EXAMPLE_DYNAMIC_PAGE 4. EXAMPLE_DYNAMIC_PAGE 5. 4-16 Oracle WebDB 2.2
WebDB 4.1.10.5 JavaScript UI 1. WebDB 2. SCOTT : SCOTT 3. EXAMPLE_FORM EXAMPLE_SP_FORM 4. 5. 6. 4-17
WebDB 4.1.10.6 1 HTML 1 2 SQL JOIN 1 3 SCOTT.DEPT DEPTID SCOTT.EMP ID Department ID ID JavaScript 4-18 Oracle WebDB 2.2
WebDB 1. WebDB 2. SCOTT : SCOTT 3. EXAMPLE_MD_FORM 4. Example_MD_Form 5. 4-19
WebDB 4.1.10.7 QBE QBE QBE QBE QBE QBE QBE 1. WebDB 2. SCOTT : SCOTT 3. EXAMPLE_QBE 4. EXAMPLE_QBE 5. 4-20 Oracle WebDB 2.2
WebDB 4.1.10.8 2 Web SQL HTML PL/SQL URL SCOTT.EMP 1 SCOTT.EMP 1. WebDB 2. SCOTT : SCOTT 3. EXAMPLE_FRAME 4. Example_Frame 5. 4-21
WebDB 4.1.10.9 Web 2 SCOTT.EMP MGR EMPNO MGR EMPNO 3 ID JavaScript UI 1. WebDB 2. SCOTT : SCOTT 3. EXAMPLE_HIERARCHY 4. EXAMPLE_HIERARCHY 5. 4-22 Oracle WebDB 2.2
WebDB 4.1.10.10 Web HTML WebDB URL WebDB URL 1 5 UI 1. WebDB 2. SCOTT : SCOTT 3. EXAMPLE_MENU 4. Example_Menu 5. 4-23
WebDB 4.1.10.11 WebDB 3 1 1 1 WebDB URL 4-24 Oracle WebDB 2.2
WebDB 4-25
WebDB 1. WebDB 2. 3. 4. : 5. 2 1 My Menu 6. My Menu My Menu My Menu My Menu My Menu 7. My Menu My Menu 4-26 Oracle WebDB 2.2
WebDB 1. 1 7 2. 3. 4. 5. My Menu 4-27
WebDB 1. 2. 3. 4. URL http://www.oracle.com WebDB SCHEMA.COMPONENT.SHOW SCHEMA COMPONENT SHOW SHOW_PARMS 5. 1. 4-28 Oracle WebDB 2.2
WebDB 4.1.10.12 2 SQL SQL SQL WebDB SQL PL/SQL SQL SQL QBE 4-29
WebDB SCOTT.EMP SQL JavaScript WebDB URL 4-30 Oracle WebDB 2.2
WebDB 2 JOIN BY PL/SQL 1. WebDB 2. SCOTT : SCOTT 3. EXAMPLE_WIZ_REPORT SQL EXAMPLE_SQL_REPORT 4. 5. 6. 4-31
WebDB 4.1.11 SQL 4.1.11.1 WebDB SQL WebDB SQL SQL SQL SQL SQL WebDB SQL SQL WebDB SQL Web 4.1.11.2 2 SQL WHERE SQL SQL JOIN 4-32 Oracle WebDB 2.2
WebDB 4.1.11.3 SQL SQL :var1 :var2 :var3 SQL SCOTT.EMP SALARY DEPT select ename, sal, dept from scott.emp where sal = :salary and deptno like :dept SQL 2 2 WebDB SQL DEPT Accounting Operations Research Sales Department 4-33
WebDB 4.1.11.4 SQL SELECT the_date, the_name, the_name_link, the_target from schema.object the_date the_name the_name_link the_date_link the_target_frame the_date the_name WebDB URL NULL WebDB SQL the_date WebDB URL NULL Web URL URL NULL 4-34 Oracle WebDB 2.2
WebDB SQL SCOTT Example_RPT select EMP.HIREDATE the_date, EMP.ENAME the_name, 'SCOTT.EXAMPLE_WIZ_RPT.show?p_arg_names=emp.ename &p_arg_values=' ename '&p_arg_names=_emp_ename_cond&' the_name_link, null the_date_link, null the_target from SCOTT.EMP 4-35
WebDB 4.1.11.5 SQL SELECT the_link, the_name, the_data from schema.object the_link the_name the_data the_name WebDB URL NULL WebDB SQL : SQL the_link null SELECT null, ename, sal from SCOTT.EMP 4-36 Oracle WebDB 2.2
WebDB sysdate - hiredate SQL SELECT null ENAME sysdate-hiredate from SCOTT.EMP group by JOB the_link, the_name, the_data, GROUP BY SQL select null the_link, JOB the_name, avg(sal) the_data, from SCOTT.EMP group by JOB 4-37
WebDB SQL SCOTT.EMP select 'SCOTT.EXAMPLE_WIZ_RPT.show?p_arg_names=emp.ename &p_arg_values=' ename '&p_arg_names=_emp_ename_cond&' the_link, ENAME the_name, SAL the_data from SCOTT.EMP order by SAL desc 4-38 Oracle WebDB 2.2
WebDB SQL SQL :SALARY SCOTT.EMP SAL select null the_link, ENAME the_name, SAL the_data, from SCOTT.EMP where SAL > :SALARY Order by SAL desc 4-39
WebDB 4.1.11.6 SQL HTML <html> <body> <h1>hello</h1> It's <oracle> begin htp.p(to_char(sysdate,'day HH24:MI')) end; </oracle> is your data accessible? </body> </html> SELECT <html> <body> <h1>employees in SCOTT.EMP</h1> <oracle>select * from scott.emp </oracle> </body> </html> 4-40 Oracle WebDB 2.2
WebDB 4.1.11.7 SQL SQL SCOTT.EMP ID EMPNO SCOTT Example_Form HTML SQL EMPNO : WebDB SQL select '<A REF="' 'SCOTT.EXAMPLE_FORM.show?p_arg_names=EMPNO& p_arg_values=' empno '"> ' empno '</A>' empno, ename, deptno, mgr, sal from SCOTT.EMP 4-41
WebDB 4-42 Oracle WebDB 2.2
WebDB SQL SQL :JOBS SCOTT.EMP SAL select deptno, ename, hiredate, job, sal, comm from scott.emp where job in (:jobs) or :jobs is null SQL SQL Deptno 4-43
WebDB 4.1.12 WebDB 4.1.12.1 WebDB WebDB FRED FRED FRED SCOTT FRED FRED FRED FRED 4.1.12.2 DBA PRODUCTION PRODUCTION 4-44 Oracle WebDB 2.2
WebDB 4.1.12.3 WebDB PRODUCTION PRODUCTION Production with INVALID package 4-45
WebDB 4.1.12.4 WebDB WebDB 1. WebDB 2. : DBA 3. 4. : 5. / 6. / 7. / 8. 4-46 Oracle WebDB 2.2
WebDB 4.1.12.5 1. WebDB 2. : DBA 3. 1 4. UI 5. 6. 7. 8. : 4-47
WebDB 1. 1 7 2. 3. 1 : EDIT 4-48 Oracle WebDB 2.2
WebDB 4.1.12.6 1. WebDB 2. : DBA 3. 4. 5. : DBA 6. 4-49
WebDB 1. 1 3 2. 3. : 4-50 Oracle WebDB 2.2
WebDB 4.1.12.7 WebDB WebDB SQL INSERT WebDB WebDB 1. WebDB 2. : DBA 3. 4. 5. SQL 6. Web SQL ASCII 7. 8. SQL*Plus SQL 4.1.12.8 DBA 4-51
WebDB WebDB EDIT DBA 1. WebDB 2. : DBA 3. 4. WebDB 1. 1 4 2. Action 4-52 Oracle WebDB 2.2
WebDB 4.1.12.9 1. WebDB 2. : DBA 3. 4. 1. 1 4 2. 3. 4. 4-53
WebDB : PRODUCTION with VALID PACKAGE WebDB Web WebDB 4.1.12.10 WebDB QBE 4-54 Oracle WebDB 2.2
WebDB WebDB 2433 WebDB : Oracle init.ora 4-55
WebDB init.ora WebDB Oracle WebDB Oracle init.ora init.ora job_queue_processes=2 job_queue_intervals=120 job_queue_keep_connections =TRUE 2 120 Oracle WebDB 1. WebDB 2. 3. 4-56 Oracle WebDB 2.2
WebDB 1. WebDB 2. 3. : 4. MY_CHART.SHOW_PARMS WebDB 5. 6. : % WebDB 4-57
WebDB 1. WebDB 2. 3. WebDB : 4. MY_CHART.SHOW_PARMS WebDB 5. 6. 7. 8. 9. WebDB 10. : % 4-58 Oracle WebDB 2.2
Oracle 4.2 Oracle 4.2.1 Oracle WebDB Oracle Oracle WebDB Oracle PL/SQL 1 PL/SQL SQL 1 4-59
Oracle 4.2.2 1. WebDB 2. 3. 4-60 Oracle WebDB 2.2
4.3 4.3.1 WebDB JavaScript 1 WebDB LOV JavaScript UI WebDB URL Web WebDB 1 UI JavaScript WebDB / 4-61
WebDB WebDB 4.3.2 JavaScript UI 1. WebDB 2. : DBA 4-62 Oracle WebDB 2.2
4.3.3 3. 1 4. UI 5. PRODUCTION 6. 7 7. 16 WebDB 1. WebDB 2. 3. My_Blue_Color 4. Web 16 Blue #C0D9D9 16 # 5. 6. 1. WebDB 4-63
2. 3. 4. My_Blue_Color 5. Web 16 Blue #C0D9D9 16 # 6. 7. 1. WebDB 2. 3. 4. 5. 4.3.4 Web Arial Times New Roman WebDB 1. WebDB 2. 3. Arial Web 4. 4-64 Oracle WebDB 2.2
1. WebDB 2. 3. 4. 5. 6. 1. WebDB 2. 3. 4. 5. : Web Web Web Times New Roman,Times Times New Roman Times Times 4-65
4.3.5 WebDB /images/ WebDB UI 1. WebDB 2. 3. 4. : /images/ 5. 6. 1. WebDB 2. 3. 8 4. 1 5. 1 6. 7. 4-66 Oracle WebDB 2.2
8. 9. 10. 11. 12. 1. 1 8 2. 3. 4.3.6 WebDB WebDB WWV_USR_TABLE_LINK$ WebDB WebDB WebDB WebDB SQL INSERT WebDB WebDB SQL INSERT WebDB WWV_USR_TABLE_LINK$ DBA UI 4-67
1. WebDB 2. 3. SQL INSERT 4. Web INSERT ASCII 5. SQL*Plus WebDB WebDB WebDB2 WebDB2 SQL*PLUS INSERT UI 1. WebDB 2. 3. UI 6 4. UI UI 1 5. LOV 6. SQL INSERT 7. Web INSERT ASCII 8. SQL*Plus WebDB WebDB webdb2 webdb2 SQL*PLUS INSERT 4-68 Oracle WebDB 2.2
4.3.7 4.3.7.1 WebDB HTML HTML WebDB WebDB 4-69
4.3.7.2 WebDB URL WebDB 1. WebDB 2. 3. : WebDB 4. : LINK_TO_REPORT241 5. 6. : WebDB WebDB HTML WebDB WebDB SCOTT SCOTT_REPORT SCOTT.SCOTT_REPORT SCOTT_REPORT SCOTT.SCOTT_REPORT 7. HTML URL http://www.mycompany.com 8. 4-70 Oracle WebDB 2.2
9. WebDB HTML OK 10. WebDB 11. WebDB SCOTT.EMP ENAME EMPNO DEPTNO 12. SCOTT.EMP 10 10 = DEPTNO show_header HTML font_size order_by_1 show_header Yes No 13. 14. 15. OK 4-71
4.3.7.3 SQL SCOTT.EMP DEPTNO 4-72 Oracle WebDB 2.2
= DEPTNO 4-73
DEPTNO SCOTT.EMP DEPTNO DEPTNO 4-74 Oracle WebDB 2.2
10 10 4-75
4.3.7.4 WebDB URL HTML <A> SQL 1. WebDB 2. 3. 6 4. LINK_ FROM_SALARY_CHART LINK_FROM_SALARY_ CHART salary L 5. 6. 7. : SQL 4-76 Oracle WebDB 2.2
4.3.7.5 WebDB HTML 1. WebDB 2. 3. LINK_TO_ SALARY_CHART LINK_TO_SALARY_CHART salary L % 4. 5. 4-77
4.3.7.6 WebDB URL WebDB WebDB 1. WebDB 2. 3. 4. LINK_ FROM_EMPLOYEE_REPORT LINK_FROM_ EMPLOYEE_REPORT employee_report rep % 5. 6. 1 7. 8. 4-78 Oracle WebDB 2.2
4.3.7.7 1. WebDB 2. 3. 6 4. LINK_ FROM_SALARY_CHART LINK_FROM_SALARY_ CHART salary L 5. 6. SQL 7. Web SQL ASCII 8. 9. SQL*Plus SQL 4-79
4.3.8 4.3.8.1 LOV WebDB LOV WebDB LOV WebDB SCOTT.EMP DEPTNO DEPTNO Accounting Operations Research Sales WebDB LOV WebDB LOV 1 4-80 Oracle WebDB 2.2
LOV LOV LOV SCOTT.EMP WebDB LOV 2 LOV LOV SQL 4.3.8.2 2 Sales Marketing Accounting Research WebDB WebDB SQL SQL SQL 4-81
DBA 1 4.3.8.3 LOV LOV Dept 10 Dept 20 Dept 30 10 20 30 LOV LOV LOV LOV 1. WebDB 2. LOV 3. - LOV 4-82 Oracle WebDB 2.2
4. : 5. DEPARTMENTS_LOV 6. : 7. NULL NULL 8. LOV LOV 9. 1 LOV 1 2 2 10. LOV 4.3.8.4 LOV SQL LOV SQL select display_column, value_column from table_name display_column LOV display_column display_column display_column table_name LOV LOV SQL LOV 4-83
1. WebDB 2. 3. - SQL LOV 4. : 5. DEPARTMENTS_LOV 6. : 7. NULL NULL 8. LOV SELECT select deptno, deptno from scott.emp 9. LOV 4-84 Oracle WebDB 2.2
4.3.8.5 LOV 1. WebDB 2. 3. LOV 7 4. LOV LOV 5. LOV SQL 6. LOV 7. LOV SQL 4-85
4.3.8.6 LOV WebDB LOV WebDB LOV 1. WebDB 2. 3. LOV LOV 4. LOV LOV 5. LOV SQL 6. LOV 7. LOV 8. 4-86 Oracle WebDB 2.2
4.3.9 4.3.9.1 UI WebDB Web UI WebDB UI Web UI UI UI UI UI WebDB HTML UI HTML UI HTML Web Web WebDB HTML HTML Web #BODY# Web HTML UI UI 4-87
4.3.9.2 UI UI 1. WebDB 2. UI UI UI UI UI 3. UI WebDB UI UI DBA 4. UI 5. : 6. UI WebDB Accounting_Template 7. UI 8. 9. UI UI 4-88 Oracle WebDB 2.2
UI 10. UI 4.3.9.3 UI UI 1. WebDB 2. UI UI UI UI UI 3. UI Web UI UI DBA 4. HTML 5. : 6. UI WebDB Accounting_Template 7. Web HTML : UI HTML HTML Web Web HTML 4-89
8. HTML HTML #BODY# #BODY# HTML WebDB Web HTML 1 2 #BODY# : 9. UI 10. 11. UI UI UI 12. UI 4-90 Oracle WebDB 2.2
4.3.10 JavaScript 4.3.10.1 JavaScript WebDB JavaScript OnBlur OK JavaScript TRUE FALSE JavaScript JavaScript 4-91
1. 2. IsNaN "Is Not a Number" JavaScript 3. 4. JavaScript JavaScript isdate isinteger isalphanumeric isalpha isemailaddress DD-MON-YY @ 4-92 Oracle WebDB 2.2
4.3.10.2 JavaScript WebDB JavaScript JavaScript 1. WebDB 2. JavaScript JavaScript 3. JavaScript JavaScript 4. JavaScript JavaScript NULL JavaScript NotNull 5. JavaScript JavaScript1.1 JavaScript1.2 6. JavaScript : JavaScript 7. JavaScript 4-93
4.3.10.3 JavaScript JavaScript JavaScript WebDB JavaScript WebDB JavaScript JavaScript 1. WebDB 2. JavaScript JavaScript 3. JavaScript JavaScript JavaScript 7 4. JavaScript 5. JavaScript JavaScript 6. JavaScript JavaScript JavaScript 7. JavaScript JavaScript 8. JavaScript 4-94 Oracle WebDB 2.2
4.3.10.4 JavaScript JavaScript 1. WebDB 2. JavaScript JavaScript 3. JavaScript JavaScript JavaScript 7 4. JavaScript JavaScript 5. JavaScript 6. JavaScript JavaScript JavaScript 7. JavaScript JavaScript 8. JavaScript OnBlur [Enter] 2 OnBlur JavaScript JavaScript 9. 4-95
4-96 Oracle WebDB 2.2
5 WebDB 5.1 DBA WebDB WebDB Oracle SELECT INSERT UPDATE DELETE EXECUTE WebDB EXECUTE WebDB 5-1
5.2 WebDB WebDB 1. WebDB 2. 3. 5-2 Oracle WebDB 2.2
5.3 DBA 1. WebDB 2. 3. WebDB SCOTT SCOTT WebDB 4. 5. 6. 7. 8. ORACLE 9. WebDB WEBDB_DEVELOPER WebDB : WebDB WebDB WebDB 5-3
10. WebDB : Oracle 5.4 1. WebDB 2. 3. 4. 5. 6. 5-4 Oracle WebDB 2.2
5.5 5.5.1 DBA WEBDB_DEVELOPER DBA WebDB WEBDB_DEVELOPER DBA WebDB WebDB WEBDB_DEVELOPER WebDB WEBDB_ DEVELOPER WebDB WEBDB_DEVELOPER DBA WebDB 1. WebDB 2. 3. WebDB 5-5
4. 5. 6. DBA WEBDB_DEVELOPER 7. 8. 1 5.5.2 Oracle DBA WebDB EXECUTE WebDB WebDB SELECT INSERT UPDATE DELETE 1. WebDB 2. 3. Sales_Department % & _ 4. 5-6 Oracle WebDB 2.2
5. / : 6. 7. 1 WebDB 5-7
5.6 5.6.1 DBA WebDB WebDB 1. WebDB 2. 3. 4. WebDB WebDB WebDB 5. WebDB 6. : WebDB WebDB 5-8 Oracle WebDB 2.2
5.6.2 DBA 1. WebDB 2. 3. 4. : 5. 6. : 7. 8. : WebDB WebDB 5-9
5.6.3 1. WebDB 2. WebDB WebDB 3. : WebDB SCOTT SCOTT 5-10 Oracle WebDB 2.2
5.7 5.7.1 DBA WebDB SELECT INSERT UPDATE DELETE EXECUTE 1. WebDB 2. 3. 1 2 3 SCOTT SCOTT % SCOTT SCOUT SCO% 4. 5. / SELECT INSERT UPDATE DELETE EXECUTE 6. / 7. WebDB 5-11
1. WebDB 2. 3. 4. / / / 5. 6. : SELECT INSERT UPDATE DELETE EXECUTE SELECT WebDB SELECT INSERT UPDATE DELETE 5-12 Oracle WebDB 2.2
Oracle Reports Security 5.8 Oracle Reports Security 5.8.1 Oracle Reports Security Oracle Reports Security Oracle Reports Oracle Reports WebDB WebDB Oracle Reports.RDF.REP.XML Reports Server Reports Server Reports Server Reports Server Reports Server Oracle Reports WebDB 5.8.2 Oracle Reports WebDB Oracle Reports Oracle Reports WebDB 5-13
Oracle Reports Security RW_ADMINISTRATOR WebDB Oracle Reports Security WebDB Oracle Reports Security RW_DEVELOPER RW_POWER_ USER RW_BASIC_USER CGI killjob RW_DEVELOPER Oracle Reports RW_ADMINISTRATOR WebDB Oracle Reports Security RW_POWER_USER RW_ BASIC_USER CGI showmap showenv showjobs getjobid parsequery RW_POWER_USER RW_BASIC_SER Oracle Reports URL RW_BASIC_USER CGI Oracle Reports CGI showmyjobs killmyjobs help 5.5.1 DBA WEBDB_ DEVELOPER 5-14 Oracle WebDB 2.2
Oracle Reports Security 5.8.3 Cookie WebDB Cookie Oracle Reports URL Cookie Reports Server Reports Server Cookie Reports Server Cookie Reports Server my_webserver.west.my_company.com Cookie my_company.com: Reports Server Cookie Reports Server west.my_company.com: Reports Server Cookie Reports Server sales.west.my_company.com: Reports Server Cookie Reports Server east.my_company.com: Reports Server Cookie Reports Server : WebDB Listener Cookie 1. wdbsvr.cfg [ORACLE_HOME] listener cfg Windows NT c: orant listener cfg wdbsvr.cfg 2. wdbsvr.cfg [SERVER] ORCookieName Cookie 3. ORCookieDomain Cookie Cookie 4. WebDB 5-15
Oracle Reports Security 5.8.4 Oracle Reports Reports Server 2 1 12:00 10:00 2 12:00 10:00 : Reports Server 1 Reports Server 1 1 Reports Server : 12:00 10:00 : 12:00 10:00 : 1 12:00 10:00 : 12:00 10:00 : 12:00 10:00 4:00 10:00 : 12:00 10:00 : 12:00 10:00 : 12:00 10:00 5-16 Oracle WebDB 2.2
Oracle Reports Security 5.8.5 : 12:00 10:00 EVERY_DAY May 17 1999 12:00 AM May 17 1999 10:00 PM Daily 1 [ ] 5.8.6 : 12:00 10:00 EVERY_DAY_1999 May 17 1999 12:00 AM May 17 1999 10:00 PM Daily 1 Dec 31 1999 10:00 PM WebDB 5-17
Oracle Reports Security 5.8.7 : 1 12:00 10:00 : 2 2 1 1 ALT_DAYS May 17 1999 12:00 AM May 17 1999 10:00 PM Daily 2 [ ] 5.8.8 : 12:00 10:00 2 MONDAY May 17 1999 12:00 AM May 17 1999 10:00 PM Weekly 1 [ ] 5-18 Oracle WebDB 2.2
Oracle Reports Security FRIDAY May 21 1999 12:00 AM May 21 1999 10:00 PM Weekly 1 [ ] MONDAY_FRIDAY MONDAY FRIDAY [ ] 5.8.9 : 12:00 10:00 4:00 10:00 : EVERY_DAY 2 : UPDATE Jun 1 1999 04:00 PM Jun 1 1999 10:00 PM Monthly by Date 1 WebDB 5-19
Oracle Reports Security [ ] : REP_AVAILABLE EVERY_DAY UPDATE UPDATE 5-20 Oracle WebDB 2.2
Oracle Reports Security 5.8.10 : 12:00 10:00 : EVERY_DAY 2 : CHRISTMAS Dec 25 1999 12:00 AM Dec 26 1999 12:00 AM Yearly 1 [ ] : WORKDAYS_EX_XMAS EVERY_DAY CHRISTMAS CHRISTMAS WebDB 5-21
Oracle Reports Security 5.8.11 : 12:00 10:00 : EVERY_DAY 2 : 11 4 Monthly by Day 11 25 11 4 12 12 THANKSGIVING Nov 25 1999 12:00 AM Nov 26 1999 12:00 AM Monthly by Day 12 [ ] : WORKDAYS_EX_THANKS EVERY_DAY THANKSGIVING THANKSGIVING 5-22 Oracle WebDB 2.2
Oracle Reports Security 5.8.12 : 12:00 10:00 : EVERY_DAY : CHRISTMAS : THANKSGIVING WORKDAYS_EX_HOLS EVERY_DAY CHRISTMAS THANKSGIVING THANKSGIVING CHRISTMAS : EVERY_DAY : CHRISTMAS : THANKSGIVING HOLIDAYS CHRISTMAS THANKSGIVING [ ] WebDB 5-23
Oracle Reports Security 2 WORKDAYS_EX_HOLS EVERY_DAY HOLIDAYS HOLIDAYS 5.8.13 RW_ADMINISTRATOR 1. WebDB 2. Oracle Reports Security 3. 4. 5. EVERY_DAY 6. 7. 8. May 17 1999 12:00 AM 9. May 21 1999 10:00 PM 10. 5-24 Oracle WebDB 2.2
Oracle Reports Security 1 1999 5 17 1999 5 28 May 17 1999 May 28 1999 1 5 17 May 17 1999 May 1 1999 : by Date June 1 1999 July 1 1999 by Day Saturday May 1 1999 Saturday June 5 1999 Saturday July 3 1999 May 17 1999 May 17 1999 11. by Date January 1 February 1 March 1 by Day 12. 1 May 21 1999 2 13. WebDB 5-25
Oracle Reports Security May 17 1999 December 31 1999 14. 15. 16. 17. OK : : 5.8.14 RW_ADMINISTRATOR 1. WebDB 2. Oracle Reports Security 3. 4. 5-26 Oracle WebDB 2.2
Oracle Reports Security 5. WORKDAYS 6. 7. 8. 9. 2 1 10. 11. Oracle Reports Reports Server 12. 2 December 25 1999 12:00 a.m December 26 1999 12:00 a.m. 1999 12 25 13. 14. 15. 16. OK : WebDB 5-27
Oracle Reports Security 5.8.15 Reports Oracle WebDB 7.10.6 : 1. 2. 3. : Reports Server Reports Server Reports Server Oracle WebDB 7.10.13 : Reports Server Oracle WebDB 7.10.18 : 5-28 Oracle WebDB 2.2
Oracle Reports Security 4. 4.3.9 5.8.16 Oracle Reports 2 PAGESTREAM EMPID SMITH EMPID SMITH 1 10 SMITH Oracle WebDB 7.10.6 : 1. Oracle Reports 2. LOV Oracle WebDB 4.6.4 4.6.2 Low High WebDB 5-29
: LOV Low High 5 5 5 5.9 PL/SQL True False True False PL/SQL PL/SQL EMPNAME SMITH 5-30 Oracle WebDB 2.2
Oracle Reports 5.10 Oracle Reports Oracle Reports Reports Server DESNAME DESNAME WebDB 5-31
Oracle Reports 5.11 Oracle Reports Oracle Reports HTML HTML 3.0 Netscape Navigator 2.2 HTMLCSS PDF CSS HTML 3.0 PDF RTF PostScript Microsoft Word Word Microsoft Excel DELIMITER PostScript PostScript DESFORMAT 5-32 Oracle WebDB 2.2
6 WebDB Oracle 6.1 WebDB 1 WebDB WebDB WebDB WebDB WebDB Oracle 6-1
REDO 6.2 WebDB QBE WebDB SQL WebDB WWV_ACTIVITY_LOG WWV_ACTIVITY_LOG 6.3 1. WebDB 2. 3. 6-2 Oracle WebDB 2.2
WebDB 6.4 WebDB 6.4.1 WebDB 1. WebDB 2. WebDB 3. : WebDB 6.4.2 WebDB 1. WebDB 2. 3. WebDB Oracle 6-3
WebDB 6.4.3 I/O WebDB I/O 1. WebDB 2. WebDB I/O 6.4.4 WebDB DBA 1. WebDB 2. WebDB 3. 6.4.5 WebDB 1. WebDB 2. 6-4 Oracle WebDB 2.2
WebDB 6.5 WebDB 6.5.1 12:01 1. WebDB 2. 12:01 3. 12:01 1. WebDB 2. 12:01 1 3. 1. WebDB 2. 2 7 1 2 12:01 1 3. WebDB Oracle 6-5
WebDB : WebDB 6.5.2 0.5 WebDB 1. WebDB 2. WebDB 0.5 0.5 410 WebDB 3. 6-6 Oracle WebDB 2.2
WebDB : WebDB HTML Web 6.5.3 1. WebDB 2. 12:01 3. WebDB 6.5.4 IP IP 1. WebDB 2. IP 12:01 WebDB IP 3. IP IP IP WebDB Oracle 6-7
WebDB 6.5.5 WebDB 6.5.5.1 WebDB WebDB QBE 6.5.5.2 WebDB 1. WebDB 2. QBE QBE TIME STAMP COMPONENT TYPE 3. 1 4. 5. : QBE QBE 6-8 Oracle WebDB 2.2
WebDB 6.5.5.3 1. WebDB 2. WebDB 3. 4. WebDB Oracle 6-9
Oracle 6.6 Oracle 6.6.1 1. WebDB 2. 6.6.2 HTP Oracle Application Server HTP 1. WebDB 2. HTP HTP 3. HTP 6.6.3 1. WebDB 2. 3. QBE 6-10 Oracle WebDB 2.2
Oracle 6.6.4 1. WebDB 2. 1. WebDB 2. 6.6.5 1. WebDB 2. 1. WebDB 2. 1. WebDB 2. WebDB Oracle 6-11
Oracle 6.6.6 1. WebDB 2. 6-12 Oracle WebDB 2.2
7 Web 7.1 WebDB WebDB WebDB Oracle Web WebDB WebDB Web 7.2 WebDB WebDB DBA dbms_sys_sql WebDB Web 7-1
WebDB Web 1. WebDB 2. URL 3. URL 4. WebDB 5. WebDB WebDB WebDB Web WebDB 6. 2 7. 7-2 Oracle WebDB 2.2
Web 7.3 Web WebDB 1. WebDB 2. 3. MYSITE_ADMIN/MYSITE_ADMIN 4. 5. 6. MYSITE_ADMIN 7. 8. 9. 10. 11. 6 10 Web 7-3
Web 7-4 Oracle WebDB 2.2
8 8.1 WebDB QBE CHAR, VARCHAR2 : WebDB VARCHAR2 32KB DATE NUMBER RAW 8-1
8.2 WebDB Oracle WebDB Oracle CREATE CLUSTER Oracle CREATE FUNCTION PL/SQL Oracle CREATE INDEX 1 PL/SQL Oracle CREATE PACKAGE CREATE PACKAGE BODY Oracle CREATE PROCEDURE Oracle CREATE SEQUENCE Oracle CREATE SNAPSHOT 1 Oracle CREATE SNAPSHOT LOG Oracle CREATE SYNONYM 8-2 Oracle WebDB 2.2
Oracle CREATE TABLE Oracle CREATE TRIGGER 1 Oracle CREATE TYPE Oracle 8 Oracle CREATE VIEW : Oracle 8.1.5 WebDB Java Java WebDB HTML Web WebDB Oracle 8-3
8.3 WebDB Oracle Oracle SELECT INSERT UPDATE DELETE EXECUTE Oracle SELECT Oracle INSERT Oracle UPDATE Oracle DELETE Oracle EXECUTE : WebDB SELECT INSERT UPDATE DELETE 8-4 Oracle WebDB 2.2
8.4 2-1 - 1 1 1 8-5
Web % 1000 8-6 Oracle WebDB 2.2
8.5 8.5.1 SCOTT EMP SCOTT.EMP SCOTT 8-7
8.5.2 SCOTT.EMP SCOTT.EMP 1 1 2 of 4 8-8 Oracle WebDB 2.2
8.5.3 SCOTT.EMP 8-9
8.5.4 SCOTT.DEPT SCOTT.DEPT 8-10 Oracle WebDB 2.2
8.5.5 SCOTT.DEPT SCOTT.DEPT 8-11
8.5.6 SCOTTO.DEPT 20 SCOTT.EMP 8-12 Oracle WebDB 2.2
8.5.7 QBE SCOTT.EMP 4 QBE 8-13
QBE 8-14 Oracle WebDB 2.2
8.5.8 SCOTT.EMP SCOTT.EMP EMPNO MGR 8-15
8-16 Oracle WebDB 2.2
9 9.1 WebDB HTML WebDB HTML 1. WEBDB index_html begin htp.htmlopen; htp.headopen; htp.meta( Refresh,, 0; URL=http://tool.oracle.com/images/hello.html ); htp.headclose; htp.htmlclose; end; 2. hello.html C: orant webdb images Windows NT 3. index_html WEBDB 4. http://pc.us.oracle.com/webdb/webdb.index_html 5. WEBDB.index_html WebDB Oracle WebDB PL/SQL Gateway Setting WebDB 9-1
WebDB 9.2 WebDB Web WebDB WebDB WebDB URL DAD WebDB 1. WebDB 2. Oracle WebDB PL/SQL Gateway Setting WebDB 3. Database Access Descriptor Settings Oracle 4. Apply WebDB URL WebDB 9-2 Oracle WebDB 2.2
Oracle WebDB PL/SQL Gateway Setting WebDB 9.3 Oracle WebDB PL/SQL Gateway Setting WebDB Oracle WebDB PL/SQL Gateway Setting WebDB 1. Oracle WebDB wdbsrv.app 2. [WVGATEWAY] administrators all, administrators = user1, user2, user3@webdb user1 user2 user3 WebDB Oracle WebDB PL/SQL Gateway Setting WebDB 9-3
Oracle WebDB PL/SQL Gateway Setting WebDB 9-4 Oracle WebDB 2.2
10 10.1 WebDB Oracle WebDB WebDB EXECUTE EXECUTE 1. Oracle WebDB 2. 3. 4. 5. 6. 7. / Public 8. EXECUTE WebDB WebDB 10-1
WebDB 10-2 Oracle WebDB 2.2
Database Access Descriptor DAD HTTP WebDB Listener DAD National Language Support NLS HTML Hypertext Markup Language Web WebDB HTML PL/SQL IP IP address LAN 4 3 JavaScript HTML Netscape WebDB JavaScript MIME mime type MIME Multipurpose Internet Mail Extensions MIME Web NULL null value Oracle Oracle Connect String -1
Oracle Oracle Home Oracle SYLK Microsoft Excel WebDB WebDB role WebDB 2 DBA WebDB WEBDB_DEVELOPER WebDB DBA Web Web server Web List of Values LOV 1 application WebDB temporary tablespace image Web Web -2
wizard WebDB Web Web export end user WebDB object WebDB Oracle WebDB object information WebDB object schema WebDB SELECT INSERT UPDATE DELETE EXECUTE hierarchy 2 WebDB 3 Web foreign key -3
calendar SQL WebDB 1 row SCOTT.EMP 1 shared components WebDB JavaScript WebDB cluster join condition SQL SELECT 2 privilege WebDB DBA grant WebDB UI structured UI template WebDB UI Build In privilege WebDB 1-4
Common Gateway Interface CGI Web Web HTML CGI Web HTML component WebDB PL/SQL HTML component schema WebDB recursive relationship index execute privilege WebDB synonym primary key sequence schema -5
snapshot 1 snapshot log generate WebDB session WebDB check box WebDB " " " " WebDB substitution tag UI HTML HTML chart SQL WebDB 2 1 1 database administrator DBA DBA WebDB DBA WebDB query 1 SQL SELECT -6
activity log WebDB trigger 1 navigation toolbar 1. WebDB WebDB 2. WebDB Web version WebDB PRODUCTION with VALID PACKAGE PRODUCTION with INVALID PACKAGE hypertext link WebDB Web Web link bind variable SQL WebDB package -7
batch log WebDB parameter parameter entry field WebDB parameter entry form WebDB WebDB UI unstructured UI template WebDB UI HTML view table tablespace function PL/SQL -8
field-level validation OnBlur form-level validation form 1 WebDB form-level validation OK field-level validation bookmark URL Web browsing WebDB Browse In privilege WebDB WebDB WebDB frame driver 2 Web WebDB SQL frames view WebDB WebDB WebDB -9
procedure profile Oracle page request WebDB header HTML Web WebDB port TCP home page WebDB Web PL/SQL WebDB stored results WebDB stored attribute SCOTT.EXAMPLE_CHART P_OWNER SCOTT P_COMPONENT_NAME EXAMPLE_CHART master-detail form HTML WebDB menu WebDB URL Web WebDB -10
UI user interface UI template WebDB UI Web user name WebDB Scott WebDB SCOTT library 1 PL/SQL radio button 1 " " " " 2 WebDB Listener WebDB Web WebDB PL/SQL remote database link hypertext link QBE Query by Example QBE form WebDB QBE report SQL WebDB -11
role 1 lock wildcard WebDB % -12
D Database Access Descriptor DAD 1-4 DBA 1-5 H HTML 4-23 4-63 4-16 4-64 4-23 HTP 6-10 HTTP 1-2 I I/O 6-4 6-11 IP 6-7 6-7 2-2 J JavaScript 4-91 4-92 4-93 4-95 4-94 JOIN 4-32 L LOV 4-86 N NULL 3-7 O Oracle 1-11 HTP 6-10 WebDB 4-59 1-11 8-4 8-2 3-2 5-3 1-7 Oracle Reports 5-13 5-29 5-16 5-28 5-13 5-14 S SQL 4-32 4-34 4-32 4-59 4-40 Web 4-16 4-33 4-4 4-29 4-80 -1
U UI 4-87 UI 4-88 4-87 UI 4-89 4-9 W WEBDB_DEVELOPER 1-1 WebDB 2-2 6-4 6-12 6-2 Web 4-8 Web 7-1 7-1 4-81 4-82 SQL 4-84 4-81 4-82 4-85 4-83 4-84 4-33 8-5 4-86 LOV 4-80 4-80 4-81 4-82 4-85 4-14 4-8 4-66 4-67 4-61 4-63 4-5 4-44 4-22 4-13 4-1 4-2 4-14 4-59 4-16 4-33 4-17 4-18 4-23 4-20 4-29 4-51 4-68 4-51 4-79 6-7 3-2 3-3 WebDB 8-2 6-10 1-11 5-12 4-59 8-4 3-2 6-3 4-22 4-22 SQL 4-32 4-5 4-22 4-4 8-15 4-22 4-13 SQL 4-32 SQL 4-34 4-5 -2
4-13 4-4 6-1 6-2 IP 6-7 WebDB 6-1 6-3 6-5 6-8 6-5 6-7 I/O 6-4 6-5 6-3 6-2 6-10 6-10 6-11 5-3 6-3 3-8 4-18 3-7 3-7 4-18 4-61 JavaScript 4-91 UI 4-87 4-88 4-89 WebDB 1-1 4-80 4-82 4-83 4-84 4-85 4-86 8-5 4-66 4-63 4-64 4-67 1-12 4-61 4-64 4-65 4-70 8-2 4-32 1-11 1-11 5-8 4-3 8-4 4-46 5-12 5-9 5-2 5-12 5-11 5-8 4-46 10-1 5-9 5-11 5-12 2-2 3-8 UI 4-87 4-88 4-87 4-33 5-8 5-10 4-3 8-4 DELETE 8-4 EXECUTE 8-4 INSERT 8-4 SELECT 8-4 UPDATE 8-4 CGI - 5 4-11 IP 6-7 4-51 4-22 4-13 4-69 3-14 -3
-4 4-3 4-50 4-70 4-5 4-1 4-53 4-46 6-5 4-44 4-14 4-16 4-49 4-33 6-5 4-45 4-47 4-48 4-57 4-54 6-6 4-53 4-17 6-7 4-6 4-18 4-23 6-5 4-9 4-20 4-29 4-51 4-51 1-10 1-11 4-47 3-14 8-5 4-22 WebDB 8-2 4-59 4-18 4-1 4-2 4-44 4-22 4-13 4-11 4-9 4-14 4-59 4-33 4-17 4-18 4-23 4-20 4-29 4-44 4-46 4-44 8-2 WebDB 8-2 4-60 4-70 8-2 WebDB 8-2 4-60 5-3 4-2 5-8 4-2 8-2 8-2 2-2 6-4 2-2 2-2 6-12 6-2 2-2 1-1
4-21 4-60 WebDB 8-2 4-60 4-93 JavaScript 4-93 8-6 4-89 4-14 4-15 4-16 SQL 4-32 4-5 4-14 4-4 4-18 8-1 3-7 3-7 4-17 4-18 4-15 6-11 3-1 3-2 WebDB 4-59 1-11 5-12 8-4 6-10 5-3 4-51 8-2 6-10 5-3 3-2 3-1 4-76 JavaScript 4-95 4-85 UI 4-88 UI 4-89 4-76 4-87 4-88 4-87 4-89 6-8 6-9 6-8 6-8 4-16 4-83 4-85 4-80 8-5 SQL 4-40 4-5 4-16 4-60 WebDB 8-2 4-60 4-1 4-1 WebDB 2-3 4-45 4-49 4-45 4-6 4-69 4-70 4-69 4-23 4-33 SQL 4-32 4-33 4-4 2-1 Web 7-3 2-1 5-1 -5
-6 5-4 5-3 3-10 WebDB 8-2 4-59 5-10 3-10 4-54 4-57 4-54 4-56 4-54 6-6 4-57 4-54 4-54 4-72 4-73 4-72 4-53 8-5 4-33 4-5 4-80 4-22 4-14 4-4 4-33 4-29 UI 4-87 4-89 4-87 4-13 4-60 WebDB 8-2 4-60 3-6 4-18 4-20 4-29 3-5 WebDB 8-2 4-32 3-7 4-59 3-6 3-5 4-18 3-6 4-20 3-9 4-29 4-17 5-3 6-11 5-2 5-3 3-5 SQL 4-32 4-22 4-22 4-80 4-33 4-20 4-59 WebDB 8-2 4-59 3-10 3-10 4-93 4-17 4-5 4-11 4-17 4-18 4-19 8-8 4-20 4-93 4-64 4-65 4-57 4-54 4-55 4-64 3-1 WebDB 3-14
4-77 6-8 3-10 3-6 3-6 3-7 1-12 1-12 5-9 5-10 4-21 4-5 4-21 2-3 3-10 WebDB 8-2 4-59 3-12 3-10 4-17 4-72 5-3 5-3 5-2 6-8 IP 6-7 WebDB 6-6 6-5 6-8 6-5 6-5 4-44 JavaScript 4-94 4-86 4-66 4-67 4-7 4-44 4-78 6-4 4-14 - 10-10 4-57 4-57 8-6 4-18 4-5 4-18 8-10 8-11 8-12 4-23 WebDB 1-11 WebDB 2-4 4-5 4-23 5-3 5-4 I/O 6-4 1-5 6-3 6-4 5-3 5-1 6-2 2-2 ID 2-2 5-4 WebDB 1-1 5-8 5-11 5-2 5-3 4-59 4-14 1-2 1-3 9-3 -7
WebDB 9-3 4-69 SQL 4-32 4-79 4-77 4-70 4-77 4-76 4-78 2-3 4-14 8-7 SCOTT.EMP 8-7 8-15 SQL 4-35 SQL 4-38 4-39 SQL 4-40 8-8 8-9 8-8 8-7 8-11 8-10 8-12 8-13 QBE 4-57 4-5 4-20 4-20 3-7 3-6 8-13 3-5 4-29 4-30 4-31 4-29 SQL 4-32 4-4 Oracle 1-8 WEBDB_DEVELOPER 1-5 1-6 1-11 5-6 2-2 5-6 2-2 4-52 6-4 4-51 3-5 3-2 3-3 3-2 3-5 1-5 1-6 DBA 1-5 1-6 -8