橡Oracle8i ORDBMS入門
|
|
|
- まな やたけ
- 6 years ago
- Views:
Transcription
1 Oracle8i ORDBMS The Database for Internet Computing Oracle8i ORDBMS : Page 1
2 2 Oracle8i ORDBMS : Page 2
3 Introduction ~ What is ORDBMS? ~ 3 Oracle8i ORDBMS : Page 3
4 4 Oracle8i ORDBMS : Page 4
5 status : activate / deactivate method : member methods objects identifier attributes 5 Oracle8i ORDBMS : Page 5
6 ( ) ( ) 6 Oracle8i ORDBMS : Page 6
7 7 Oracle8i ORDBMS : Page 7
8 Application Data 8 Oracle8i ORDBMS : Page 8
9 Oracle TOOL New! JPublisher OTT Developer R6.0 JDeveloper R2.0 Designer R6.0 Object Database Designer JDBC New! New! Jserver SQLJ Pro*C/C++ OCI Technology PL/SQL SQL Object Cache Server Side Client Side 9 Oracle8i ORDBMS : Page 9
10 Oracle8i Oracle8i UniSQL ObjectStore RDBMS Infomix DataBlade OODBMS DB2 10 Oracle8i ORDBMS : Page 10
11 PK/FK ( ) 11 Oracle8i ORDBMS : Page 11
12 Oracle Database Designer R6.0 Object Database Designer UML (Unified Modeling Language) UML DDL 12 Oracle8i ORDBMS : Page 12
13 UML? UML OMT BOOCH OOSE Objectory Fusion UML Unified Modeling Language 13 Oracle8i ORDBMS : Page 13
14 UML 14 Oracle8i ORDBMS : Page 14
15 Introduction ~ Oracle Objects Features ~ 15 Oracle8i ORDBMS : Page 15
16 ( ) ( ) ( ) ( ) ID ( ) 16 Oracle8i ORDBMS : Page 16
17 ( ) 17 Oracle8i ORDBMS : Page 17
18 Object Type ~ One of the key feature of Oracle Objects ~ 18 Oracle8i ORDBMS : Page 18
19 LOB REF VARCHAR2(n), CHAR,... RAW(n) NUMBER,... DATE LONG LONG RAW VARRAY NESTED TABLE CLOB, NCLOB BLOB BFILE REF SCOPED REF REF w/ ROWID 19 Oracle8i ORDBMS : Page 19
20 : RDBMS NUMBER 20 Oracle8i ORDBMS : Page 20
21 : (NUMBER,VARCHAR2,DATE,etc...) (REF ) (NESTED TABLE, VARRAY) LOB (CLOB, BLOB, BFILE) 21 Oracle8i ORDBMS : Page 21
22 : (REF ) 22 Oracle8i ORDBMS : Page 22
23 : CREATE OR REPLACE TYPE AS OBJECT <schema_name>. <type_name>, ( <attribute_name> <data_type> ) MEMBER <method_spec> NOTE : Oracle8i SQL 23 Oracle8i ORDBMS : Page 23
24 : Oracle8 Oracle8i 24 Oracle8i ORDBMS : Page 24
25 : CREATE TYPE person_type AS OBJECT ( first_name VARCHAR2(30), last_name VARCHAR2(30), birthday DATE, ssn NUMBER(10) ); / first_name last_name birthday ssn person_type 25 Oracle8i ORDBMS : Page 25
26 : CREATE TYPE employee_type AS OBJECT ( emp_id NUMBER(5), personal_info person_type, salary NUMBER(7,2), dept_no NUMBER(4), mgr_no NUMBER(5) ); / emp_id personal_info salary dept_no mgr_no employee_type first_name last_name birthday ssn dependency 26 person_type Oracle8i ORDBMS : Page 26
27 : CREATE TYPE department_type; -- / CREATE OR REPLACE TYPE employee_type AS OBJECT ( emp_id NUMBER(5), personal_info person_type, department_type salary NUMBER(7,2), dept REF department_type, mgr_no NUMBER(5)); / CREATE TYPE department_type AS OBJECT ( dept_no NUMBER(4), dept_name VARCHAR2(30), mgr REF employee_type); / employee_types 27 Oracle8i ORDBMS : Page 27
28 : CREATE TYPE employee_type AS OBJECT ( emp_id NUMBER(5), personal_info person_type, salary NUMBER(7,2), dept REF department_type, mgr REF employee_type ); / emp_id personal_info salary dept mgr employee_type emp_id personal_info salary dept mgr employee_type 28 Oracle8i ORDBMS : Page 28
29 : CREATE TYPE address_type AS OBJECT ( street_num VARCHAR2(40),..., zipcode CHAR(8)); / CREATE TABLE customers_rel ( cust_id NUMBER(5),..., address address_type,...); customers_rel address_type street_num street state zipcode Oracle8i ORDBMS : Page 29
30 : CREATE TYPE address_type AS OBJECT ( street_num VARCHAR2(30), street VARCHAR2(30), city VARCHAR2(30), state VARCHAR2(30), zipcode CHAR(8) ); / CREATE TABLE customers_rel ( cust_id NUMBER(5), name VARCHAR2(30), address address_type, sex CHAR(1) ); SELECT c.cust_id, c.name FROM customers_rel c WHERE c.address.zipcode = ; 30 Oracle8i ORDBMS : Page 30
31 : CREATE TYPE customer_type AS OBJECT ( cust_id NUMBER(5), name VARCHAR2(30), address address_type, sex CHAR(1) ); / CREATE TABLE customers_obj OF customer_type; customers_obj customer_type OID cust_id name address sex 31 Oracle8i ORDBMS : Page 31
32 : CREATE TABLE customers_obj OF customers_type (CONSTRAINT pk_customers_obj PRIMARY KEY (cust_id) USING INDEX TABLESPACE users STORAGE (INITIAL 100K NEXT 100K PCTINCREASE 0 MAXEXTENTS UNLIMITED) ) OBJECT ID SYSTEM GENERATED OIDINDEX oid_customers_obj TABLESPACE users; CREATE TABLE customers_obj OF customers_type (CONSTRAINT pk_customers_obj PRIMARY KEY (cust_id) USING INDEX TABLESPACE users STORAGE (INITIAL 100K NEXT 100K PCTINCREASE 0 MAXEXTENTS UNLIMITED) ) OBJECT ID PRIMARY KEY TABLESPACE users; 32 Oracle8i ORDBMS : Page 32
33 (OID) (OID) 33 Oracle8i ORDBMS : Page 33
34 Object Identifiers ~ One of the key feature of Oracle Objects ~ 34 Oracle8i ORDBMS : Page 34
35 (OID) : 2 35 Oracle8i ORDBMS : Page 35
36 (OID) : Oracle8i ORDBMS : Page 36
37 (OID) : 16 OIDINDEX 37 Oracle8i ORDBMS : Page 37
38 Object Reference ~ One of the key feature of Oracle Objects ~ 38 Oracle8i ORDBMS : Page 38
39 Employees REF Pointer to an Object Departments OID 1 1 REF Navigational access 39 Oracle8i ORDBMS : Page 39
40 (REF) : 2 REF REF REF 40 Oracle8i ORDBMS : Page 40
41 ( REF) : REF = REF REF 3 REF : 36bytes ROWID REF : 50bytes SCOPED REF : 16bytes Tab1 Tab2 Tab3 41 Oracle8i ORDBMS : Page 41
42 ( REF) : REF = REF SCOPED REF Tab1 SCOPED REF Tab2 42 Tab3 Oracle8i ORDBMS : Page 42
43 (REF) : = = 43 Oracle8i ORDBMS : Page 43
44 (REF) : CREATE TYPE department_type; -- / CREATE OR REPLACE TYPE employee_type AS OBJECT ( emp_id NUMBER(5), personal_info person_type, department_type salary NUMBER(7,2), dept REF department_type, mgr_no NUMBER(5)); / CREATE TYPE department_type AS OBJECT ( dept_no NUMBER(4), dept_name VARCHAR2(30), mgr REF employee_type); / employee_types 44 Oracle8i ORDBMS : Page 44
45 : REF CREATE TABLE departments_soid OF department_type; CREATE TABLE employees_soid OF employee_type; department_type employee_types 45 Oracle8i ORDBMS : Page 45
46 : REF CREATE TABLE departments_uoid OF department_type (CONSTRAINT pk_departments_uoid PRIMARY KEY (dept_no)) OBJECT ID PRIMARY KEY; CREATE TABLE employees_uoid OF employee_type (CONSTRAINT pk_employees_uoid PRIMARY KEY (emp_id),scope FOR (dept) IS departments_uoid) OBJECT ID PRIMARY KEY; department_type ALTER TABLE departments_uoid ADD (SCOPE FOR (mgr) IS employees_uoid); employee_types 46 Oracle8i ORDBMS : Page 46
47 : REF REF REF INSERT INTO employees_soid VALUES (1098, person_type( Kei, Aoki, 14-OCT-1973, ), , (SELECT REF(d) FROM departments_soid d WHERE d.dept_no = 1), 465); INSERT INTO employees_soid SELECT 1098, person_type( Kei, Aoki, 14-OCT-1973, ), , REF(d), 465 FROM departments_soid d WHERE d.dept_no = 1; 47 Oracle8i ORDBMS : Page 47
48 : REF DEREF SELECT DEREF(e.dept) FROM employees_soid e WHERE e.emp_id = 1097; REF SELECT e.dept.dept_no, e.dept.dept_name FROM employees_soid e WHERE e.emp_id = 1098; 48 Oracle8i ORDBMS : Page 48
49 : DANGLING REF REF ( ) DANGLING REF ( REF) Dangling REF 49 Oracle8i ORDBMS : Page 49
50 : DANGLING REF SQL DANGLING REF SELECT e.emp_id FROM employees_soid e WHERE e.dept IS DANGLING; SELECT e.emp_id FROM employees_soid e WHERE e.dept IS NOT DANGLING; DANGLING REF IS NULL 50 Oracle8i ORDBMS : Page 50
51 : DANGLING REF ANALYZE DANGLING REF NULL ANALYZE TABLE employees_soid VALIDATE REF UPDATE SET DANGLING TO NULL; Dangling REF 51 Oracle8i ORDBMS : Page 51
52 (REF) : REF REF UPDATE employees_soid e SET e.dept.mgr = 1000 WHERE e.emp_id = 1097; 52 Oracle8i ORDBMS : Page 52
53 Methods ~ One of the key feature of Oracle Objects ~ 53 Oracle8i ORDBMS : Page 53
54 ( ) 54 Oracle8i ORDBMS : Page 54
55 : PL/SQL, Java, C, C++ l MAP l ORDER 55 Oracle8i ORDBMS : Page 55
56 : CREATE TYPE person_type AS OBJECT (...); Constructor Method : person_type( ) 56 Oracle8i ORDBMS : Page 56
57 : NULL INSERT INTO employees_soid VALUES (1097, person_type( Tsuyoshi, Kitagawa, 08-AUG-1974, ), , (SELECT REF(d) FROM departments_soid d WHERE d.dept_no = 2), 675); INSERT INTO employees_soid VALUES (employee_type(1098, person_type( Kei, Aoki, 14-OCT-1973, NULL), , (SELECT REF(d) FROM departments_soid d WHERE d.dept_no = 1), 465)); 57 Oracle8i ORDBMS : Page 57
58 : ( ) : : CREATE TYPE 58 Oracle8i ORDBMS : Page 58
59 / : CREATE OR REPLACE TYPE employee_type AS OBJECT ( empno NUMBER(5), personal_info personal_type, sal NUMBER(7,2), comm NUMBER(7,2), dept REF department_type, mgr_no NUMBER(5), MEMBER FUNCTION total_income RETURN NUMBER, PRAGMA RESTRICT_REFEREMCES(total_income, WNDS, WNPS) ); CREATE OR REPLACE TYPE BODY employee_type AS MEMBER FUNCTION total_income RETURN NUMBER IS BEGIN RETURN SELF.sal + SELF.comm; END; END; 59 Oracle8i ORDBMS : Page 59
60 : CREATE TABLE employees_soid OF employee_type; SELECT e.emp_id, e.personal_info.first_name, e.personal_info.last_name, e.total_income() FROM employees_soid e; : SELECT e.emp_id, e.personal_info.first_name, e.personal_info.last_name, e.sal+e.comm FROM employees e; 60 Oracle8i ORDBMS : Page 60
61 : CREATE TABLE employees_soid OF employee_type; SELECT e.emp_id, e.personal_info.last_name, e.personal_info.last_name FROM employees e WHERE e.total_income() < 2500; : SELECT e.emp_id, e.personal_info.first_name, e.personal_info.last_name FROM employees e WHERE e.sal+e.comm < 2500; 61 Oracle8i ORDBMS : Page 61
62 : PRAGMA WNDS WNPS RNDS RNPS 62 Oracle8i ORDBMS : Page 62
63 : MAP ORDER 1 63 Oracle8i ORDBMS : Page 63
64 MAP : : DATE, NUMBER, VARCHAR2 ANSI SQL ORDER BY 64 Oracle8i ORDBMS : Page 64
65 ORDER : 2 NUMBER 2 65 Oracle8i ORDBMS : Page 65
66 MAP : CREATE TYPE ball_t AS OBJECT ( id NUMBER(4), name VARCHAR2(20), color VARCHAR2(20), MAP MEMBER FUNCTION ball_order RETURN INTEGER, PRAGMA RESTRICT_REFERENCES(BALL_ORDER, WNDS)); / CREATE OR REPLACE TYPE BODY ball_t AS MAP MEMBER FUNCTION ball_order RETURN INTEGER IS BEGIN RETURN ASCII(SUBSTR(SELF.color, 1, 1)); END; END; / 66 Oracle8i ORDBMS : Page 66
67 MAP : SQL> SELECT * FROM ball; ID NAME COLOR golf ball white 22 basket ball brown 43 tennis ball yellow 24 soccer ball black and white SQL> SELECT * FROM ball b ORDER BY VALUE(b); ID NAME COLOR basket ball brown 24 soccer ball black and white 10 golf ball white 43 tennis ball yellow SQL> 67 Oracle8i ORDBMS : Page 67
68 ORDER : CREATE TYPE ball_t AS OBJECT ( id NUMBER(4), name VARCHAR2(20), color VARCHAR2(20), ORDER MEMBER FUNCTION ball_order(in_ball ball_t) RETURN INTEGER, PRAGMA RESTRICT_REFERENCES(BALL_ORDER, WNDS, WNPS)); / CREATE OR REPLACE TYPE BODY ball_t AS ORDER MEMBER FUNCTION ball_order(in_ball ball_t) RETURN INTEGER IS BEGIN IF SELF.id < in_ball.id THEN RETURN -1; ELSIF SELF.id > in_ball.id THEN RETURN 1; ELSE RETURN 0; END IF; END; END; / 68 Oracle8i ORDBMS : Page 68
69 ORDER : SQL> SELECT * FROM ball b 2 WHERE VALUE(b) < ball_t(24,'basket ball','brown'); ID NAME COLOR golf ball white 22 basket ball brown SQL> 69 Oracle8i ORDBMS : Page 69
70 Collection ~ One of the key feature of Oracle Objects ~ 70 Oracle8i ORDBMS : Page 70
71 : 1 VARRAY (Variable Array) (NESTED TABLE) 71 Oracle8i ORDBMS : Page 71
72 VARRAY : 0 = 72 Oracle8i ORDBMS : Page 72
73 VARRAY : Oracle8i ORDBMS : Page 73
74 VARRAY : VARRAY 74 Oracle8i ORDBMS : Page 74
75 VARRAY : CREATE TYPE <type_name> AS <schema_name>. ( limit ) OF VARRAY VARYING ARRAY <element_type> NOTE : Oracle8i SQL 75 Oracle8i ORDBMS : Page 75
76 VARRAY : VARRAY VARRAY SQL 76 Oracle8i ORDBMS : Page 76
77 VARRAY : CREATE OR REPLACE TYPE employee_type AS OBJECT ( empno NUMBER(4), ename VARCHAR2(10), job VARCHAR2(9), hiredate DATE, mgr NUMBER(4), sal NUMBER(7,2), comm NUMBER(7,2) ); / CREATE OR REPLACE TYPE employee_va AS VARRAY(50) OF employee_type; / CREATE OR REPLACE TYPE department_type AS OBJECT ( deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13), employees employees_va ); / 77 Oracle8i ORDBMS : Page 77
78 VARRAY : VARRAY CREATE TABLE departments OF department_type (CONSTRAINT pk_departments PRIMARY KEY (deptno)) OBJECT ID PRIMARY KEY TABLESPACE users VARRAY employees STORE AS LOB department_employees_lob ( DISABLE STORAGE IN ROW STORAGE (INITIAL 100K NEXT 100K PCTINCREASE 0)); 78 Oracle8i ORDBMS : Page 78
79 VARRAY : VARRAY 4K DISABLE STORAGE IN ROW LOB TABLESPACE : users TABLESPACE : users NOTE : NOTE : DISABLE STORAGE IN ROW VARRAY 4K VARRAY 79 Oracle8i ORDBMS : Page 79
80 VARRAY : INSERT INTO departments VALUES (1, Marketing, Tokyo, employee_va( ) ); employee_type(1097, T.Kitagawa, Engineer, 01- APL-1997, 657, , 0), employee_type(657, T.Nikaido, Director, 01-OCT- 1995, 107, , 0) 80 Oracle8i ORDBMS : Page 80
81 NESTED TABLE : NESTED TABLE 81 Oracle8i ORDBMS : Page 81
82 NESTED TABLE : ( / ) 82 Oracle8i ORDBMS : Page 82
83 NESTED TABLE : NESTED TABLE 83 Oracle8i ORDBMS : Page 83
84 NESTED TABLE : CREATE TYPE AS TABLE OF <schema_name>. <type_name> <element_type> NOTE : Oracle8i SQL 84 Oracle8i ORDBMS : Page 84
85 NESTED TABLE : / NESTED TABLE / Oracle8i ORDBMS : Page 85
86 NESTED TABLE : CREATE OR REPLACE TYPE employee_type AS OBJECT ( empno NUMBER(4), ename VARCHAR2(10), job VARCHAR2(9), hiredate DATE, mgr NUMBER(4), sal NUMBER(7,2), comm NUMBER(7,2) ); / CREATE OR REPLACE TYPE employee_nt AS TABLE OF employee_type; / CREATE OR REPLACE TYPE department_type AS OBJECT ( deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13), employees employees_nt ); / 86 Oracle8i ORDBMS : Page 86
87 NESTED TABLE : NESTED TABLE CREATE TABLE departments OF department_type (CONSTRAINT pk_departments PRIMARY KEY (deptno)) OBJECT ID PRIMARY KEY TABLESPACE users NESTED TABLE employees STORE AS department_employees_store ((CONSTRAINT pk_department_employees_store PRIMARY KEY (NESTED_TABLE_ID, empno) USING INDEX TABLESPACE users STORAGE (INITIAL 100K NEXT 100K PCTINCREASE 0) STORAGE (INITIAL 100KNEXT 100K PCTINCREASE 0)); 87 Oracle8i ORDBMS : Page 87
88 NESTED TABLE : NESTED TABLE TABLESPACE : users NOTE : 88 Oracle8i ORDBMS : Page 88
89 NESTED TABLE : INSERT INTO departments VALUES (1, Marketing, Tokyo, employee_nt( ) ); employee_type(1097, T.Kitagawa, Engineer, 01- APL-1997, 657, , 0), employee_type(657, T.Nikaido, Director, 01-OCT- 1995, 107, , 0) 89 Oracle8i ORDBMS : Page 89
90 NESTED TABLE : INSERT INTO THE (SELECT employees FROM departments WHERE deptno = 1) VALUES ( ); 1098, K.Aoki, Engineer, 26-NOV-1999, 657, , 0 90 Oracle8i ORDBMS : Page 90
91 NESTED TABLE : DELETE FROM THE (SELECT employees FROM departments WHERE deptno = 1) e WHERE e.empno = 1098; 91 Oracle8i ORDBMS : Page 91
92 NESTED TABLE : UPDATE THE (SELECT employees FROM departments WHERE deptno = 1) e SET e.sal = WHERE e.empno = 1097; 92 Oracle8i ORDBMS : Page 92
93 VARRAY NESTED TABLE VARRAY NESTED TABLE (4K ) (SQL ) SQL DML 93 Oracle8i ORDBMS : Page 93
94 Object View ~ One of the key feature of Oracle Objects ~ 94 Oracle8i ORDBMS : Page 94
95 File Edit File Edit 95 Oracle8i ORDBMS : Page 95
96 File Edit 96 Oracle8i ORDBMS : Page 96
97 OID 97 Oracle8i ORDBMS : Page 97
98 : = pkoid 98 Oracle8i ORDBMS : Page 98
99 : CREATE TABLE dept ( deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13) ) (CONSTRAINT pk_dept PRIMARY KEY(deptno)); CREATE TABLE emp ( empno NUMBER(4), ename VARCHAR2(10), job VARCHAR2(9), hiredate DATE, mgr NUMBER(4), sal NUMBER(7,2), comm NUMBER(7,2), deptno NUMBER(2)) (CONSTRAINT pk_emp PRIMARY KEY (empno), CONSTRAINT fk_emp_deptno FOREIGN KEY (deptno) REFERENCES dept); 99 Oracle8i ORDBMS : Page 99
100 : CREATE TYPE dept_t AS OBJECT (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)); / CREATE TYPE emp_t AS OBJECT (empno NUMBER(4), ename VARCHAR2(10), job VARCHAR(9), hiredate DATE, mgr NUMBER(4), sal NUMBER(7,2), comm NUMBER(7,2), dept REF dept_t); / 100 Oracle8i ORDBMS : Page 100
101 : pkoid CREATE VIEW dept_view OF dept_t AS SELECT deptno, dname, loc FROM dept; 101 Oracle8i ORDBMS : Page 101
102 : pkoid (pkoid) CREATE VIEW dept_view OF dept_t WITH OBJECT OID (deptno) AS SELECT deptno, dname, loc FROM dept; 102 Oracle8i ORDBMS : Page 102
103 : pkoid (pkref) pkoid REF pkoid 103 Oracle8i ORDBMS : Page 103
104 : pkref pkref MAKE_REF MAKE_REF CREATE VIEW emp_view OF emp_t WITH OBJECT OID (empno) AS SELECT empno, ename, job, hiredate, mgr, sal, comm, MAKE_REF(dept_view,deptno) FROM emp; 104 Oracle8i ORDBMS : Page 104
105 : (VARRAY / NESTED TABLE) (REF) 105 Oracle8i ORDBMS : Page 105
106 : DML INSTEAD OF 106 Oracle8i ORDBMS : Page 106
107 : NESTED TABLE CREATE TYPE emp_t AS OBJECT ( empno NUMBER(4), ename VARCHAR2(10), job VARCHAR2(9), hiredate DATE, mgr NUMBER(4), sal NUMBER(7,2), comm NUMBER(7,2)); / CREATE TYPE emp_set_t AS TABLE OF emp_t; / CREATE TYPE dept_t AS OBJECT ( deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13), employees emp_set_t); / 107 Oracle8i ORDBMS : Page 107
108 : NESTED TABLE CREATE VIEW dept_view OF dept_t WITH OBJECT OID (deptno) AS SELECT d.deptno, d.dname, d.loc, CAST( MULTISET( SELECT e.empno, e.ename, e.job, e.hiredate, e.mgr, e.sal, e.comm FROM emp e WHERE e.deptno = d.deptno ) AS emp_set_t) FROM dept d; 108 Oracle8i ORDBMS : Page 108
109 DML File Edit 109 Oracle8i ORDBMS : Page 109
110 INSERT, UPDATE, DELETE INSTEAD OF File Edit INSTEAD OF 110 Oracle8i ORDBMS : Page 110
111 DECLARE... BEGIN... EXCEPTION... END INSTEAD OF 111 Oracle8i ORDBMS : Page 111
112 (1/5) CREATE TABLE dept ( deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13) ) (CONSTRAINT pk_dept PRIMARY KEY(deptno)); CREATE TABLE emp ( empno NUMBER(4), ename VARCHAR2(10), job VARCHAR2(9), hiredate DATE, mgr NUMBER(4), sal NUMBER(7,2), comm NUMBER(7,2), deptno NUMBER(2)) (CONSTRAINT pk_emp PRIMARY KEY (empno), CONSTRAINT fk_emp_deptno FOREIGN KEY (deptno) REFERENCES dept); 112 Oracle8i ORDBMS : Page 112
113 (2/5) CREATE TYPE emp_t AS OBJECT ( empno NUMBER(4), ename VARCHAR2(10), job VARCHAR2(9), hiredate DATE, mgr NUMBER(4), sal NUMBER(7,2), comm NUMBER(7,2)); / CREATE TYPE emp_set_t AS TABLE OF emp_t; / CREATE TYPE dept_t AS OBJECT ( deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13), employees emp_set_t); / 113 Oracle8i ORDBMS : Page 113
114 (3/5) CREATE VIEW dept_view OF dept_t WITH OBJECT OID (deptno) AS SELECT d.deptno, d.dname, d.loc, CAST( MULTISET( SELECT e.empno, e.ename, e.job, e.hiredate, e.mgr, e.sal, e.comm FROM emp e WHERE e.deptno = d.deptno ) AS emp_set_t) FROM dept d; 114 Oracle8i ORDBMS : Page 114
115 INSTEAD OF (4/5) CREATE OR REPLACE TRIGGER dept_ov_instr INSTEAD OF INSERT ON dept_view DECLARE emplist_tab emp_set_t; i INTEGER; BEGIN emplist_tab := :NEW.emplist; INSERT INTO dept VALUES(:NEW.deptno,:NEW.dname,:NEW.loc); IF (emplist_tab IS NOT NULL) THEN FOR i IN 1..emplist_tab.COUNT LOOP INSERT INTO emp VALUES(emplist_tab(i).empno,..., emplist_tab(i).comm, :NEW.deptno); END LOOP; END IF; END; 115 Oracle8i ORDBMS : Page 115
116 INSTEAD OF (5/5) CREATE OR REPLACE TRIGGER dept_ov_emplist_instr INSTEAD OF INSERT ON NESTED TABLE employees OF dept_view BEGIN INSERT INTO emp VALUES(:NEW.empno,:NEW.ename,:NEW.job, :NEW.mgr,:NEW.hiredate,:NEW.sal,:NEW.comm, :PARENT.deptno); END; 116 Oracle8i ORDBMS : Page 116
117 INSTEAD OF : DML INSTEAD OF Insert new objects into dept_v Insert new elements into dept_v.emplist dept_ov_instr dept_ov_emplist_instr 117 Oracle8i ORDBMS : Page 117
118 INSTEAD OF : INSTEAD OF :NEW :OLD :PARENT l :PARENT INSTEAD OF l :PARENT ROWID 118 Oracle8i ORDBMS : Page 118
119 Objects with Java ~ Manipulate objects through Java~ 119 Oracle8i ORDBMS : Page 119
120 JDBC, SQLJ (JPublisher) C++ (ODD : Object Database Designer) C, OCI (OTT : Object Type Translator) Oracle Precompilers OO4O (Oracle Objects for OLE) SQL, PL/SQL 120 Oracle8i ORDBMS : Page 120
121 API JDBC SQLJ Java API Java API Java SQL SQLJ JDBC ANSI 121 Oracle8i ORDBMS : Page 121
122 JDBC Driver ~APIs to access Database~ 122 Oracle8i ORDBMS : Page 122
123 JDBC Driver (1/3) JDBC-Thin Driver (Type 4) Java Net8 TCP/IP Web Browser 123 Oracle8i ORDBMS : Page 123
124 JDBC Driver (2/3) JDBC-OCI Driver (Type 2) Java Oracle OCI Net8 Application Server 124 Oracle8i ORDBMS : Page 124
125 JDBC Driver (3/3) JDBC-KPRB Driver (Server-side JDBC Driver) Java VM SQL PL/SQL Client-side JDBC Driver Oracle8i 125 Oracle8i ORDBMS : Page 125
126 JDBC Driver Web Browser JDBC-Thin Java Sockets Client Application JDBC-OCI OCI C Lib. SQL*Net SQL & PL/SQL Engines JDBC-KPRB Internal Lib. Java Stored Procedure 126 Oracle8i ORDBMS : Page 126
127 JDBC : JDBC Driver Statement Query Close 127 Oracle8i ORDBMS : Page 127
128 JDBC : DriverManager getconnection Connection createstatement Statement executequery ResultSet preparestatement executequery PreparedStatement preparecall CallableStatement setxxx getxxx getxxx Date, Time, Java 128 Oracle8i ORDBMS : Page 128
129 Oracle JDBC Driver JDK1.0.2,JDK1.1 JDBC1.22 Oracle : LOB REF 129 Oracle8i ORDBMS : Page 129
130 SQLJ ~Embeded SQL~ 130 Oracle8i ORDBMS : Page 130
131 SQLJ : Java SQL SQLJ JDBC Java SQL JDBC SQLJ code SQLJ Translator Java Code with JDBC calls Java Compiler Regular Java Class file Oracle8i Oracle8i 131 Oracle8i ORDBMS : Page 131
132 SQLJ : SQLJ Oracle, IBM, Tandem, Sybase, Javasoft,... ANSI/ISO SQLJ 132 Oracle8i ORDBMS : Page 132
133 JPublisher ~Utility to generate Java classes for handling objects~ 133 Oracle8i ORDBMS : Page 133
134 Object Type Java Class.java or.sqlj JPublisher (1/2) Java Java 3 l JDBC Mapping l Object JDBC (JDBC 2.0) Mapping : Default l Oracle Mapping 134 Oracle8i ORDBMS : Page 134
135 JPublisher (2/2) Command Line Imput File Java Class l get<attribute>( ), set<attribute>( ) -methods=true REF Class l <Type_Name>Ref.java 135 Oracle8i ORDBMS : Page 135
136 JPublisher SQL DDL Command Line Input File Oracle8i JPublisher Object Types Generated Java Classes Custom Java Classes Import Compiler Java Program 136 Oracle8i ORDBMS : Page 136
137 Handling Objects ~Using generated classes~ 137 Oracle8i ORDBMS : Page 137
138 -- (customer_tab) -- (stock_tab) -- (purchase_tab) Entity / Object Customer Stock Purchase Order Line Item List ( ),,,,, ( ) 138 Oracle8i ORDBMS : Page 138
139 address_t street : varchar2 city : varchar2 state : char zip : varchar2 phone_list_t varray of varchar2 line_item_list_t table of line_item_t line_item_t lineitemno : number quantity : number discount : number stockref : ref stock_info_t stockno : number cost : number tax_code : number customer_info_t purchase_order_t pono : number orddate : date shipdate : date custref : ref shiptoaddr : address_t lineitemlist : line_item_list_t address_t street : varchar2 city : varchar2 state : char zip : varchar2 line_item_list_t custono custname address phone_list : number : varchar2 : address_t : phone_list_t address_t street : varchar2 city : varchar2 state : char zip : varchar2 phone_list_t varray of varchar2 table of line_item_t 139 Oracle8i ORDBMS : Page 139
140 : address_t address_t street : varchar2 city : varchar2 state : char zip : varchar2 CREATE TYPE address_t AS OBJECT ( street VARCHAR2(200), <- Attribute city VARCHAR2(200), state CHAR(2), zip VARCHAR2(20) ); / 140 Oracle8i ORDBMS : Page 140
141 : stock_info_t stock_info_t stockno cost tax_code : number : number : number CREATE TYPE stock_info_t AS OBJECT ( stockno NUMBER, cost NUMBER, tax_code NUMBER ); / 141 Oracle8i ORDBMS : Page 141
142 : line_item_t line_item_t lineitemno quantity discount stockref : number : number : number : ref CREATE TYPE line_item_t AS OBJECT ( lineitemno NUMBER, stockref REF stock_info_t, quantity NUMBER, discount NUMBER ); / 142 Oracle8i ORDBMS : Page 142
143 : phone_list_t varray of varchar2 CREATE TYPE phone_list_t AS VARRAY(10) OF VARCHAR2(20); / line_item_list_t table of line_item_t CREATE TYPE line_item_list_t AS TABLE OF line_item_t; / 143 Oracle8i ORDBMS : Page 143
144 : customer_info_t customer_info_t custono : number custname : varchar2 address : address_t phone_list : phone_list_t address_t street : varchar2 city : varchar2 state : char zip : varchar2 phone_list_t varray of varchar2 CREATE TYPE customer_info_t AS OBJECT ( custno NUMBER, custname VARCHAR2(200), address address_t, phone_list phone_list_t, ORDER MEMBER FUNCTION cust_order(x IN customer_info_t) RETURN INTEGER, PRAGMA RESTRICT_REFERENCES (cust_order,wnds,wnps,rn DS,RNPS) ); / 144 Oracle8i ORDBMS : Page 144
145 : cust_order( ) CREATE OR REPLACE TYPE BODY custmoer_info_t AS ORDER MEMBER FUNCTION cust_order(x IN customer_info_t) RETURN INTEGER IS BEGIN RETURN custno - x.custno; END; END; / 145 Oracle8i ORDBMS : Page 145
146 : purchase_order_t purchase_order_t pono : number orddate : date shipdate : date custref : ref shiptoaddr : address_t lineitemlist : line_item_list_t address_t street : varchar2 city : varchar2 state : char zip : varchar2 line_item_list_t table of line_item_t CREATE TYPE purchase_order_t AS OBJECT ( pono NUMBER, custref REF customer_info_t, orderdate DATE, shipdate DATE, line_item_list line_item_list_t, shiptoaddr address_t, MEMBER FUNCTION total_value RETURN NUMBER, PRAGMA RESTRICT_REFERENCES (total_value,wnds,wnps) ); / 146 Oracle8i ORDBMS : Page 146
147 : total_value( ) CREATE OR REPLACE TYPE BODY purchase_order_t AS MEMBER FUNCTION total_value RETURN NUMBER IS i INTEGER; stock stock_info_t; line_item line_item_t; total NUMBER := 0; cost NUMBER; BEGIN FOR i IN SELF.line_item_list.COUNT LOOP line_item := SELF.line_item_list(i); SELECT DEREF(line_item.stockref) INTO stock FROM DUAL; total := total + line_item.quantity * stock.cost; END LOOP; RETURN total; END; END; 147 Oracle8i ORDBMS : Page 147
148 CREATE TABLE customer_tab OF customer_t (CONSTRAINT pk_customer_tab PRIMARY KEY(custno)); CREATE TABLE stock_tab OF stock_info_t (CONSTRAINT pk_stock_tab PRIMARY KEY(stockno)); CREATE TABLE purchase_tab OF purchase_order_t (CONSTRAINT pk_purchase_tab PRIMARY KEY(pono),CONSTRAINT fk_custref FOREIGN KEY(custref) REFERENCES customer_tab ON DELETE SET NULL) NESTED TABLE line_item_list STORE AS po_line_tab; 148 Oracle8i ORDBMS : Page 148
149 ALTER TABLE po_line_tab ADD ( SCOPE FOR (stockref) IS stock_tab); ALTER TABLE po_line_tab STORAGE (NEXT 10K PCTINCREASE 0 MINEXTENTS 1 MAXEXTENTS 121); CREATE INDEX po_nested_in ON po_line_tab(nested_table_id); CREATE UNIQUE INDEX po_nested ON po_line_tab(nested_table_id, lineitemno); 149 Oracle8i ORDBMS : Page 149
150 JPublisher #jpub -user=scott/tiger -mapping=jdbc -sql=purchase_order_t :PurchaseOrderT -methods=true purchase_order_t Java Class PurchaseOrderT.sqlj, PurchaseOrderTRef.java -mapping={jdbc objectjdbc oracle} jdbc & objectjdbc: JDBC oracle: oracle.sql.* 150 Oracle8i ORDBMS : Page 150
151 Sample : PurchaseOrderT.sqlj import java.sql.sqlexception;... public class PurchaseOrderT implements CustomDatum, CustomDatumFactory {... /* accessor methods */ public java.math.bigdecimal getpono() throws SQLException { return (java.math.bigdecimal) _struct.getattribute(0); }... public java.math.bigdecimal totalvalue () throws SQLException {... #sql [_ctx] {... }; return jpt_result; } } 151 Oracle8i ORDBMS : Page 151
152 Sample : Sample3.java... pstmt = conn.preparestatement( "SELECT VALUE(p) FROM purchase_tab p WHERE p.pono =?" ); pstmt.setint(1,1001); OracleResultSet rset = (OracleResultSet) pstmt.executequery(); PurchaseOrderT purchase = new PurchaseOrderT(); if (rset.next()) { purchase = (PurchaseOrderT) rset.getcustomdatum( 1,PurchaseOrderT.getFactory() ); } Oracle8i ORDBMS : Page 152
153 Sample : Sample3 > sqlj AddressT.sqlj... > javac Sample3.java > java Sample3 connected. [Name]: Jean Nance [Order No]: 1001 [Total]: disconnected. > 153 Oracle8i ORDBMS : Page 153
154 Sample : Sample4.sqlj... int ipono = 1001; PurchaseOrderT purchase = null; #sql {SELECT VALUE(p) INTO :purchase FROM purchase_tab p WHERE p.pono=:ipono}; if(purchase!= null) { CustomerInfoT cust = (CustomerInfoT) purchase.getcustref().getvalue(); String custname = cust.getcustname(); int purchaseno = purchase.getpono().intvalue(); BigDecimal totalvalue = purchase.totalvalue(); Oracle8i ORDBMS : Page 154
155 Sample : Sample4.sqlj > sqlj AddressT.sqlj >... > sqlj Sample4.sqlj > java Sample4 connected. [Name]: Jean Nance [Order No]: 1001 [Total]: disconnected. > 155 Oracle8i ORDBMS : Page 155
156 Conclusion ~ Why don t you use Oracle Objects? ~ 156 Oracle8i ORDBMS : Page 156
157 Oracle8 R8.0 Oracle8i (REF) (VARRAY NESTED TABLE) SQL*Loader 157 Oracle8i ORDBMS : Page 157
158 Oracle8i Oracle8 R8.0 Object Type System Collection LOB REF System-generated OID Methods Object Cache Object View OTT (Object Type Translator) User-defined OID Collection Enhancements Trigger Enhancements Object View Enhancements Partitioning Support for Objects SQL*Loader Support for Objects Parallel Query Support for Objects Extensible Indexing and Optimizer Java Stored Procedure EJB & CORBA/IIOP Support JPublisher Oracle8i 158 Oracle8i ORDBMS : Page 158
159 Oracle8i Application : Java Database : ORDBMS (Oracle Objects) 159 Oracle8i ORDBMS : Page 159
160 Oracle Corporation, All right reserved. Oracle Corporation Oracle Corporation Oracle Corporation ( ) ORACLE Oracle Corporation Rev.A Oracle8i ORDBMS : Page 160
Microsoft Word - 430_15_Developing_Stored_Procedure.doc
Java Oracle 1998 11 Java 3 Java Web GUI Java Java Java Oracle Java Oracle8i Oracle / Oracle Java Virtual Machine VM CORBA Enterprise JavaBeans Oracle Java Java Java Oracle Oracle Java Virtual Machine Oracle
0315_F1_8iJDBC-SQLJ.PDF
Page 1 1 Page 2 2 JDBC JDBC JDBC JDBC JDBC SQLJ SQLJ SQLJ SQLJ SQLJ Page 3 3 JDBC Java JDBC RDBMS JDBC ODBC JDBC SQL JDBC SQL Java API Java JDBC Java API RDBMS Java Java JDBC JDBC ODBC Javasoft SQL99 JDBC
BC4J...4 BC4J Association JSP BC4J JSP OC4J
lê~åäévá=gaéîéäçééê= 9.0.3/9.0.4 BC4J Creation Date: Oct 08, 2003 Last Update: Feb 27, 2004 Version 1.0 ...3... 3 BC4J...4 BC4J...4... 4... 5... 6...7... 8... 9 Association... 13... 15... 20... 22... 25
領域サイズの見積方法
White Paper 1998 3 1998 7 NULL 1998 9 2 8.03 Design & Migration Services Oracle Corporation Japan 1998 Printed in Japan Oracle and SQL*Loader are registered trademarks. Oracle7 Oracle Corporation Oracle
PowerPoint -O80_REP.PDF
Oracle8 Core Technology Seminar 1997109,31 Oracle8 OS: UNIX Oracle8 : Release8.0.3 Oracle8 Quick Start Package Lesson 5 -- Enhancements to Distributed Facilities Oracle8 -- - Oracle8 LOB Oracle8 -- - Updates
ストラドプロシージャの呼び出し方
Release10.5 Oracle DataServer Informix MS SQL NXJ SQL JDBC Java JDBC NXJ : NXJ JDBC / NXJ EXEC SQL [USING CONNECTION ] CALL [.][.] ([])
橡実践Oracle Objects for OLE
THE Database FOR Network Computing 2 1. 2 1-1. PL/SQL 2 1-2. 9 1-3. PL/SQL 11 2. 14 3. 16 3-1. NUMBER 16 3-2. CHAR/VARCHAR2 18 3-3. DATE 18 4. 23 4-1. 23 4-2. / 24 26 1. COPYTOCLIPBOARD 26 III. 28 1.
Oracle9i
Oracle9i 2002 2 Oracle9i... 4... 4... 4 Oracle... 4 SQL... 6... 6... 6... 7... 7... 9... 9... 9 CUBE... 10... 11... 11... 11 OR... 12... 12... 14... 14... 15... 15... 16... 16... 18... 18... 18... 19...
_02_3.ppt
XML DB Oracle Corporation Agenda RDB XML SQL/XML XML DB XML Oracle Corporation 2 Agenda RDB XML SQL/XML XML DB XML Oracle Corporation 3 RDB-XML RDB XML Oracle Corporation 4 XML RDB [Oracle] Extract ExtractValue
20050314_02-4.ppt
Oracle Database 10g Oracle XML DB 2005 3 14 1 Agenda Oracle XML DB XML SQL Oracle Database 10g Release 2 Copyright Oracle Corporation, 2005 All right reserved. 2 XML Oracle Database 10g Release 2 Oracle
Oracle9i Reportsのチューニング
Oracle9i Reports 2002 5 Oracle9i Reports...3...4...4...9...14...18 Oracle9i Forms...19...19...20 A...22 B...24 Oracle9i Reports 2 Oracle9i Reports Oracle9i Reports Oracle9i Oracle9i Reports 3 Oracle9i
D1印刷用.PDF
[ D-1 ] Windows Oracle8i for Windows Oracle8i for Windows / / Visual Basic - Oracle8i SQL Oracle Oracle8i for Windows Oracle8i Enterprise Edition Oracle8i Personal Edition Oracle8i Workgroup Server Oracle8i
tkk0408nari
SQLStatement Class Sql Database SQL Structured Query Language( ) ISO JIS http://www.techscore.com/tech/sql/02_02.html Database sql Perl Java SQL ( ) create table tu_data ( id integer not null, -- id aid
TopLink È... 3 TopLink...5 TopLink åø... 6 TopLink å Workbench O/R ~... 8 Workbench À ~... 8 Foundation Library å... 8 TopL
lê~åäé= qçéiáåâ= NMÖENMKNKPF Volume1 Creation Date: Mar 04, 2005 Last Update: Aug 23, 2005 Version 1.0 ...3... 3 TopLink 10.1.3 È... 3 TopLink...5 TopLink åø... 6 TopLink å... 7... 8 Workbench O/R ~...
1,.,,,., RDBM, SQL. OSS,, SQL,,.
1,.,,,., RDBM, SQL. OSS,, SQL,,. 3 10 10 OSS RDBMS SQL 11 10.1 OSS RDBMS............................ 11 10.1.1 PostgreSQL................................. 11 10.1.2 MySQL...................................
日本オラクル株式会社
FISC 6 Oracle Database 10g ~ ~ : 2005 7 26 : 2005 7 31 : 1.0 2004 4 (* ) FISC ) (* ) FISC 6 (* FISC 6 ) FISC 6 Oracle g Database 10 (FISC) http://www.fisc.or.jp FISC http://www.fisc.or.jp/info/info/050307-1.htm
TopLink å SampleClient.java... 5 Ò readallsample() querysample() cachesample() Ç..
lê~åäé= qçéiáåâ= NMÖENMKNKPF Volume2 Creation Date: Mar 04, 2005 Last Update: Aug 22, 2005 Version 1.0 ...3... 3 TopLink å...4 1... 4... 4 SampleClient.java... 5 Ò... 8... 9... 10 readallsample()... 11
1 SQL Server SQL Oracle SQL SQL* Plus PL/SQL 2 SQL Server SQL Server SQL Oracle SQL SQL*Plus SQL Server GUI 1-1 osql 1-1 Transact- SQL SELECTFROM 058
1 SQL Server SQL Oracle SQL SQL* Plus PL/SQL 2 SQL Server SQL Server SQL Oracle SQL SQL*Plus SQL Server GUI 1-1 osql 1-1 Transact- SQL SELECTFROM 058 2 Excel 1 SQL 1 SQL Server sp_executesql Oracle SQL
XML Consortium & XML Consortium 1 XML Consortium XML Consortium 2
& 1 2 TCO DB2 DB2 UDB DB DB V8.2 V8.2 DB2 DB2 UDB V8.1 V8.1 DB2 9 3 CLOB XML XML DB2 9 purexml XML XML DOC XML DOC XML DOC XML DOC VARCHAR/CLOB XML ( ) 4 XML & XML ( & ) DB2 XML SQL/XML DB2 DB2 : DB2 /
CAC
VOL.24NO.1 61 IMS Transaction 3270 DataBase Transaction OS/370 IMS Traditional Transaction Web Browser Transaction Internet WWW AP IIS APache WebLogic Websphere DataBase Oracle DB2 SQL Server Web Browser
1 ex01.sql ex01.sql ; user_id from (select user_id ;) user_id * select select (3+4)*7, SIN(PI()/2) ; (1) select < > from < > ; :, * user_id user_name
SQL mysql mysql ( mush, potato) % mysql -u mush -p mydb Enter password:****** mysql>show tables; usertable mysql> ( ) SQL (Query) : select < > from < > where < >; : create, drop, insert, delete,... ; (
早分かりS2Dao
2008 Spring 早分かり S2Dao Seasar プロジェクトコミッタ ( 株 ) エルテックス 大中浩行 2008 Spring Copyright 2004-2008 The Seasar Foundation and the others. All rights reserved. 1 アジェンダ はじめに S2Dao とは? S2Dao に必要なもの S2Dao を動かしてみる 挿入
橡j_Oracle_whitepaper.PDF
Pervasive-Oracle 1 1 Pervasive Software Pervasive-Oracle / Pervasive Oracle Pervasive-Oracle ISV Pervasive-Oracle Pervasive.SQL Oracle 2 Pervasive-Oracle Pervasive-Oracle Pervasive.SQL Oracle Open Database
DB12.1 Beta HandsOn Seminar
Oracle Database 12c Release 1 CoreTech Seminar Migration 日本オラクル株式会社磯部光洋 Program Agenda Migration 概要 新機能詳細 SQL Translation Framework Implicit Statement Results Enhanced SQL to PL/SQL Bind Handling Identity
untitled
Oracle Direct Seminar !? Oracle Database 11g - - Agenda Copyright 2009, Oracle. All rights reserved. 2 Agenda Copyright 2009, Oracle. All
ValueHolder... 9 Customer.java Oracle TopLink 10g(10.1.3) È Volume3 2
lê~åäé= qçéiáåâ= NMÖENMKNKPF Volume3 Creation Date: Mar 04, 2005 Last Update: Aug 23, 2005 Version 1.0 ...3... 3...4... 4... 6 ValueHolder... 9 Customer.java... 10...14 Oracle TopLink 10g(10.1.3) È Volume3
IBM Software Group DB2 Information Management Software DB2 V8 XML SQL/XML 2 XML XML UDF XMLExtender XML XML XMLCollection, XMLColumn XML UDF Informati
IBM Software Group XML Features in DB2 UDB V8 IBM Software Group DB2 Information Management Software DB2 V8 XML SQL/XML 2 XML XML UDF XMLExtender XML XML XMLCollection, XMLColumn XML UDF Information Integrator
FileMaker 16 ODBC と JDBC ガイド
FileMaker 16 ODBC JDBC 2004-2017 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMakerFileMaker Go FileMaker, Inc. FileMaker WebDirect FileMaker
Oracle Lite Tutorial
GrapeCity -.NET with GrapeCity - SPREAD Creation Date: Nov. 30, 2005 Last Update: Nov. 30, 2005 Version: 1.0 Document Control Internal Use Only Author Hiroshi Ota Change Logs Date Author Version Change
FileMaker ODBC and JDBC Guide
FileMaker 13 ODBC JDBC 2004-2013 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento FileMaker, Inc. FileMaker WebDirect Bento FileMaker,
Oracle Lite Tutorial
GrapeCity -.NET with GrapeCity - FlexGrid Creation Date: Nov. 30, 2005 Last Update: Nov. 30, 2005 Version: 1.0 Document Control Internal Use Only Author Hiroshi Ota Change Logs Date Author Version Change
Oracle Database 10gの新しいSQL性能: 正規表現、ネイティブ値、LOBパフォーマンスおよびその他の機能
Oracle Database 10g SQL : LOB Geoff Lee, Oracle Corporation Peter Linsley, Oracle Corporation Jonathan Gennick, O'Reilly & Associates Oracle SQL Oracle Detabase Oracle SQL API Oracle Database 10g SQL Oracle
S2DaoでもN:Nできます
S2Dao でも N:N できます 1 自己紹介 名前 : 木村聡 ( きむらさとし ) Seasarプロジェクトコミッタ : S2Struts S2Mai 舞姫 仕事 ( 株 ) フルネス フレームワーク 自動生成ツール 2 これまで書いたものとか 書籍 : Eclipse で学ぶはじめての Java Seasar 入門 ~ はじめての DI&AOP~ 雑誌 Web 記事 CodeZine DB
9iAS_DEV.PDF
Oracle9i Application Server for Windows NT 1.0.2.0.0 2001.2.1 1 1 PL/SQL...3 1.1...3 1.2 PL/SQL Web Toolkit...5 1.3 Database Access Descriptor...6 1.4 PL/SQL...8 1.5 PL/SQL...10 1.6 PL/SQL...12 2 SERVLET...13
untitled
Oracle Direct Seminar SQL Agenda SQL SQL SQL SQL 11g SQL FAQ Oracle Direct SQL Server MySQL PostgreSQL Access Application Server Oracle Database Oracle Developer/2000 Web Oracle Database
Oracle Lite Tutorial
GrapeCity -.NET with GrapeCity - InputMan Creation Date: Nov. 30, 2005 Last Update: Nov. 30, 2005 Version: 1.0 GrapeCity Microsoft Visual Studio.NET VB.NET Oracle Tips InputMan InputMan Oracle.NET Oracle
橡ExCtrlPDF.PDF
THE Database FOR Network Computing Oracle Oracle Oracle Oracle Oracle Oracle (Oracle Object for OLE Oracle Developer) SQL Oracle8 Enterprise Edition R8.0.5 for Windows NT Oracle8 Enterprise Edition R8.0.5
Oracle Database 10gの新しいSQL機能
Oracle Database 10g SQL 2003 11 Oracle Database 10g SQL... 4 Oracle Regular Expression... 5... 5... 5... 6... 6 Oracle Regular Expression... 7... 7... 7... 8 Oracle... 8... 8 DDL... 10 PL/SQL... 11...
,, create table drop table alter table
PostgreSQL 1 1 2 1 3,, 2 3.1 - create table........................... 2 3.2 - drop table............................ 3 3.3 - alter table............................ 4 4 - copy 5 4.1..................................
プレポスト【問題】
1/5 ページ プレポスト データベース基礎 受講日程受講番号氏名 1 データベースの特徴で間違っているものを選びなさい 1. データの一元管理が可能 2. データの重複が少ない 3. プログラムとの関係が1 対 1 4. データの整合性の確保 2 ANSI/SPARC による 3 層スキーマについて正しいものを選びなさい 1. 外部スキーマ : プログラムに必要な部分のデータ構造を定義概念スキーマ
Oracle9i JDeveloperによるWebサービスの構築
Oracle9i JDeveloper Web Web Web Web Web Web EJB Web EJB Web Web Oracle9iAS Apache SOAP WSDL Web Web Web Oracle9i JDeveloper Java XML Web Web Web Web Simple Object Access Protocol SOAP :Web Web Services
FileMaker 15 ODBC と JDBC ガイド
FileMaker 15 ODBC JDBC 2004-2016 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker Go FileMaker, Inc. FileMaker WebDirect FileMaker,
Microsoft Word - J doc
SQL*Plus for Windows 8.1.6 2000 5 : J01601-01 : : Oracle Windows Windows NT 4.0 Windows 2000 Windows 95 Windows 98 Windows NT Windows NT 4.0 Windows 2000 Oracle Oracle Oracle Corporation Oracle7 Oracle8i
目次 1 集計関数 / 分析関数とは 2 集計関数 / 分析関数のパフォーマンス効果 3 ケーススタディグループ小計やクロス集計を計算するランキングを表示する前月比較を表示する累計を計算する移動平均を計算する構成比を計算する Oracle8i SQL Oracle8i Oracle Oracle C
Oracle8i データウェアハウス機能活用法 ~ レポーティングに有効な集計関数 分析関数 ~ Creation Date: Oct. 11, 2000 Last Update: Oct. 11, 2000 Version: 1.0!! DWH etc Business Intelligence Oracle8i RDBMS DWH Oracle8i Oracle Corporation Japan
~~~~~~~~~~~~~~~~~~ wait Call CPU time 1, latch: library cache 7, latch: library cache lock 4, job scheduler co
072 DB Magazine 2007 September ~~~~~~~~~~~~~~~~~~ wait Call CPU time 1,055 34.7 latch: library cache 7,278 750 103 24.7 latch: library cache lock 4,194 465 111 15.3 job scheduler coordinator slave wait
Oracle Spatial
Oracle Spatial 2003 10 Oracle Spatial... 3 1.0... 3 2.0 ORDBMS... 5 2.1 ORDBMS... 5 2.2... 5 2.2.1... 6 2.2.2... 6 2.2.3... 6 2.2.4... 6 2.3... 7 2.3.1... 7 2.3.2... 7 2.3.3... 8 2.3.4... 8 2.3.5... 8
C3印刷用.PDF
[ C-3 ] Oracle8i On Windows Agenda Windows Oracle8i Oracle8i for Windows NT/2000 R8.1.7 Oracle HTTP Server Oracle intermedia Oracle Workflow Windows Oracle8i for Windows Oracle8i Enterprise Edition Oracle8i
意外と簡単!?
!?Access Oracle Oracle Migration Workbench MS-Access Oracle Creation Date: Oct 01, 2004 Last Update: Mar 08, 2005 Version: 1.1 !? Oracle Database 10g / GUI!? / Standard Edition!? /!?!? Oracle Database
IT 2
Knowledge-Works, Inc. Tokyo UML Caché IT 2 UML Caché Caché vocabulary UML Unified Modeling Language) UML UML / UML but UML UML UML DBMS / 2003 InternSystems DevCon Transformation Transformation on
3 Powered by mod_perl, Apache & MySQL use Item; my $item = Item->new( id => 1, name => ' ', price => 1200,
WEB DB PRESS Vol.1 79 3 Powered by mod_perl, Apache & MySQL use Item; my $item = Item->new( id => 1, name => ' ', price => 1200, http://www.postgresql.org/http://www.jp.postgresql.org/ 80 WEB DB PRESS
第 2 章 PL/SQL の基本記述 この章では PL/SQL プログラムの基本的な記述方法について説明します 1. 宣言部 2. 実行部 3. 例外処理部
はじめに コース概要と目的 Oracle 独自の手続き型言語である PL/SQL について説明します PL/SQL の基本構文 ストアド サブプログラム トリガーの作成方法 またストアド サブプログラムの管理について習得することを目的としています 受講対象者 これから PL/SQL を使用してアプリケーション開発をされる方 前提条件 SQL トレーニング コースを受講された方 もしくは 同等の知識をお持ちの方
自己管理型データベース: アプリケーションおよびSQLチューニング・ガイド
: SQL 2005 9 : SQL... 3 SQL... 6... 8... 9 SQL :... 9 SQL... 10... 11 SQL... 12 SQL TUNING SET... 13 SQL... 14 ADDM SQL... 14 SQL... 15 STS... 15... 16 SQL... 16 DBMS_SQLTUNE... 17... 17 SQL... 19 SQL
FileMaker ODBC と JDBC ガイド
FileMaker ODBC JDBC 2004-2019 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMakerFileMaker CloudFileMaker Go FileMaker, Inc. FileMaker
Windowsユーザーの為のOracle Database セキュリティ入門
Oracle on Windows etc http://www.oracle.co.jp/campaign/mb_tech/ Windows Server System Center / OTN Japan http://www.oracle.com/technology/global/jp/tech/windows/.net + Oracle Database.NET Developer Center
ハイウォーターマークを知る
THE Database FOR Network Computing Oracle Oracle Oracle7 Oracle8 Oracle8 Enterprise Edition R8.0.4 for Windows NTOracle7 Server R7.3.4 for Windows NT Oracle7Oracle8 Oracle,Oracle7,Oracle8 1.5.1.... 6 1.5.2.
データベース認識Webサービス
Olivier Le Diouris, Oracle Corporation PL/SQL PL/SQL SOAP SOAP SOAP Web Java Java SOAP Perl Perl PL/SQL SOAP PL/SQL 1. URL 2. SOAP 1. 2. 3. 1 JSR 109 J2EE JSR 109 J2EE J2EE PL/SQL Java 2 3 JPublisher PL/SQL
B2-Servlet-0112.PDF
B-2 Servlet/JSP Agenda J2EE Oracle8i J2EE Java Servlet JavaServer Pages PDA ( J2EE Java2 Enterprise Edition API API J2SE JSP Servlets RMI/IIOP EJB JNDI JTA JDBC JMS JavaMail JAF Java2 Standard Edition
Oracle Application Server 10g Release 3（10.1.3）- アジャイル・エンタープライズ（俊敏な企業）のためのデータ・アクセス
Oracle Application Server 10g Release 3 10.1.3 2005 8 Oracle Application Server 10g Release 3 10.1.3... 3 Oracle Application Server 10g Release 3 10.1.3 3... 4... 4 RAC... 6 JDBC... 7 JMX... 8... 9 Oracle...
Oracle Database Connect 2017 JPOUG
Oracle Database Connect 2017 / JPOUG 異なるデータベース間の SQL 比較と Oracle Database 12c の新機能 Noriyoshi Shinoda March 8, 2017 自己紹介篠田典良 ( しのだのりよし ) 所属 日本ヒューレット パッカード株式会社テクノロジーコンサルティング事業統括 現在の業務 Oracle Database をはじめ
PostgreSQL SQL チューニング入門 ~ Explaining Explain より ~ 2012 年 11 月 30 日 株式会社アシスト 田中健一朗
PostgreSQL SQL チューニング入門 ~ Explaining Explain より ~ 2012 年 11 月 30 日 株式会社アシスト 田中健一朗 アジェンダ 1.EXPLAIN とは 2. 表アクセスの基本 3. 結合の基本 4. 統計情報とは 5.EXPLAIN コマンド 6. 問題解決例 7. まとめ 2 1.EXPLAIN とは 実行計画とは - 目的地は 1 つでもアクセス方法は複数
KWCR3.0 instration
KeyWeb Creator R3.0 R3.0 for MS-Windows 2005 10 B25586-01 Oracle Oracle Oracle Corporation Copyright 2005, Oracle Corporation All Right Reserved KeyWeb Creator R3.0 2005 10 Copyright 1997-2005 KeyWeb Creator
2
1 2 3 4 5 6 7 8 tbody tr div [_im_enclosure] div [_im_repeater] span [_im_enclosure] span [_im_repeater] ol li ul li select option 9 10
Gartner Day
J2EE 1 J2EE C AP 2 J2EE AP DD java *.class java *.class java *.class *.class DD EAR, WAR, JAR orionapplicationclient.xmweb.xmapplication.jar.xml orion- orion-ejb- ml Oracle Application Server 10g *.jsp
eラーニング資料 e ラーニングの制作目標 データベース編 41 ページデータベースの基本となる概要を以下に示す この内容のコースで eラーニングコンテンツを作成予定 データベース管理 コンピュータで行われる基本的なデータに対する処理は 次の 4 種類です 新しいデータを追加する 既存のデータを探索
eラーニング資料 e ラーニングの制作目標 データベース編 41 ページデータベースの基本となる概要を以下に示す この内容のコースで eラーニングコンテンツを作成予定 データベース管理 コンピュータで行われる基本的なデータに対する処理は 次の 4 種類です 新しいデータを追加する 既存のデータを探索する 違うデータに変更する 要らなくなったデータを削除する 各システムごとに障害対策も含めて 正確にこのようなデータ処理のプログラムを作ることは大変なことです
Warehouse Builderにおける予測分析の使用
Warehouse Builder Oracle 2006 3 Warehouse Builder... 3 ETL... 4 DMBS_PREDICTIVE_ANALYTICS... 4... 5 1... 5 2... 5 3... 5... 6 SQL PREDICT... 7... 9 1... 9 2... 9 3... 9... 10 PL/SQL... 11... 12... 12...
Oracleの領域管理～トラブル防止のテクニック～
THE Database FOR Internet Computing Oracle ... 3... 4... 4... 5... 5... 7... 8... 9... 12... 13... 13... 16... 17... 18... 20... 22... 23... 23... 24... 25... 25... 26... 28... 31... 31... 31... 33...
Q&A集
& ver.2 EWEB-3C-N080 PreSerV for Web MapDataManager & i 1... 1 1.1... 1 1.2... 2 1.3... 6 1.4 MDM. 7 1.5 ( )... 9 1.6 ( )...12 1.7...14 1.8...15 1.9...16 1.10...17 1.11...18 1.12 19 1.13...20 1.14...21
Spring Framework Web Web Web DB AOP DI Java EE 3 Web WebMVC Web Java 4 DB H2 Database Java H2 Database http://www.h2database.com/ Version 1.0 Zip 5 H2 > cd $H2_HOME/bin > java cp h2.jar org.h2.tools.server
untitled
Oracle on Windows etc http://www.oracle.co.jp/campaign/mb_tech/ Windows Server System Center / OTN Japan http://www.oracle.com/technology/global/jp/tech/windows/.net + Oracle Database.NET Developer Center
OOW_I06
G XDK XML Agenda XDK Overview XML Parser XML Schema Processor (XML SQL Utility XML Class Generator XML Transviewer Beans XSQL Servlet Oracle XML Developer s Kit Oracle XML Devleloper s Kit (XDK XML DB
untitled
Release 11.5/Composer 2002-2006 Unify Corporation All rights reserved. Sacramento California, USA No part of this tutorial may be reproduced, transmitted, transcribed, stored in a retrieval system, or
052-XML04/fiÁ1-part3-’ÓŠ¹
& XML Data Store Part 3 Feature*1 AKIMOTO, Shougo i i i i i i inter 52 XML Magazine 04 i i i i i i i i P a r t 3 i i i i i XML Magazine 04 53 & XML Data Store Feature*1 i i inter i inter i inter inter
PostgreSQL カンファレンス 2013 証券取引バックオフィスにおける Oracle から PostgreSQL への マイグレーション SBI ジャパンネクスト証券株式会社 イアン バーウィック
PostgreSQL カンファレンス 2013 証券取引バックオフィスにおける Oracle から PostgreSQL への マイグレーション SBI ジャパンネクスト証券株式会社 イアン バーウィック PostgreSQL カンファレンス 2013 証券取引バックオフィスにおける Oracle から PostgreSQL への マイグレーション SBI ジャパンネクスト証券株式会社 イアン バーウィック
FileMaker ODBC and JDBC Guide
FileMaker 14 ODBC JDBC 2004-2015 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker Go FileMaker, Inc. FileMaker WebDirect FileMaker,
Oracle XML DB によるスケーラビリティおよびパフォーマンス検証 - MML v.3.0
Oracle XML DB MML v3.0 2004 5 27 1 Memo 1 Agenda XML MML v3.0 2 Oracle XML Oracle XML DB XML API Oracle XML DB W3C XML Schema 1.0 XPath 1.0 XSLT 1.0 Oracle W3C XML Schema Oracle 2 XML Oracle XML Developer
Oracle Developer Release 6i
Oracle Developer Release 6i 1.1 ...1...5...6 ORACLE DEVELOPER... 6...6...6 Oracle Developer...6...9...9... 10... 10...10...11...12... 13... 13... 13...14... 14 ORACLE DEVELOPER R6I... 14 R6i...15...15...15
組織変更ライブラリ
2003 6 1...1 2...2 3...4 3.1...4 3.2...5 3.3...6 3.4...6 4...7 4.1...7 4.2...9 4.3...9 4.4...10 4.5...10 5 Web...11 5.1 WebUI...11 5.2Oracle 9iFS WebUI...12 6Oracle9i AS...13 6.1OiD...13 6.2 SSO...13 7...14
PowerRDBconnector説明書(SQLServer編）
COBOL COBOL SQL COBOL COBOL COBOL OPEN REWRITE REWRITE SQL Server SQL Server PowerRDBconnector or NetCOBOL C C COBOL C C NetCOBOL [] NetCOBOL [] NetCOBOL SQL Server SQL Server NetCOBOL []
Visual Studio Oracle Database 11g アプリケーション開発入門
Oracle on Windows etc http://www.oracle.co.jp/campaign/mb_tech/ Windows Server System Center / OTN Japan http://www.oracle.com/technology/global/jp/tech/windows/.net + Oracle Database.NET Developer Center
com.ibm.etools.egl.jsfsearch.tutorial.doc.ps
EGL JSF ii EGL JSF EGL JSF.. 1................. 1 1:.... 3 Web.......... 3........... 3........ 4......... 7 2:...... 7..... 7 SQL.... 8 JSF.... 10 Web.... 12......... 13 3: OR....... 14 OR... 14.15 OR.....
OM.indd
_ INDEX 3 4 5 6 7 8 9 Platinum 10 Gold 12 Silver 14 Bronze 16 18 20 FAQ 21 22 1997 10 15 Platinum Platinum IT 保々雅世 3 IT Control Real Application Cluster Grid Oracle Application Server 10g CLE MASTER ORA
Microsoft PowerPoint - 3-Forms-Others.ppt
3 Form Builder その他の新機能 Oracle Developer R6.0 新機能 3-1 CONTENTS PL/SQL8 サポート 項目の色 フォントの直接設定 階層ツリー コントロール 戻り値を含む DML 実行時の動作 Forms でのパスワード管理 3-2 ここでは 2 章で触れなかった Form Builder のその他の新機能に付いて紹介します Oracle Developer
Oracle Web Conferencing Oracle Collaboration Suite 2 (9.0.4) Creation Date: May 14, 2003 Last Update: Jan 21, 2005 Version: 1.21
Oracle Web Conferencing Oracle Collaboration Suite 2 (9.0.4) Creation Date: May 14, 2003 Last Update: Jan 21, 2005 Version: 1.21 ... 2... 3...3...4...5 Oracle9i Platform...10 Oracle Collaboration Suite...12...15...23
untitled
Caché Agenda InterSystems Caché 2009.1.NET Gateway (2009.1) Truncate Caché Databases ( ( Studio Caché ObjectScript SQL Object Security InterSystems (200x.1, 200x.2) 5.2 : 2006/6 2007.1 : 2007/6 2008.1
キャラクタ・セットの移行に関するベスト・プラクティス
2003 9 ... 3 Oracle Database 10g... 3... 3... 4 Unicode... 6 Unicode... 6... 7... 8... 8... 9... 9... 10... 10... 10... 11... 11 US7ASCII... 13... 14... 14 Export/Import... 14 CSALTER... 15 Export Import
Introduction Purpose This training course demonstrates the use of the High-performance Embedded Workshop (HEW), a key tool for developing software for
Introduction Purpose This training course demonstrates the use of the High-performance Embedded Workshop (HEW), a key tool for developing software for embedded systems that use microcontrollers (MCUs)
KeySQL for Microsoft Windows 6.0 : B28350-01 Copyright 2006, Oracle Corporation. All rights reserved. Printed in Japan. * Oracle Corporation Oracle Co
KeySQL for Microsoft Windows 6.0 2006 3 : B28350-01 Copyright 2006, Oracle Corporation All Right Reserved Oracle Oracle Oracle Corporation KeySQL for Microsoft Windows 6.0 : B28350-01 Copyright 2006, Oracle
Oracle Database 10g Release 2を使用したデータベース・パフォーマンス
Oracle Database 10g Release 2 2005 9 Oracle Database 10g Release 2... 3... 3... 3 Automatic Workload Repository AWR... 3 Automatic Database Diagnostic Monitor ADDM... 4 Automatic SQL Tuning SQL... 4 SQL
honbun.indd
Development of Web Reservation System for Sirakaba Lodge in Aichi University (1) Object-Oriented Modeling and Implementation of Database Application Yong Jiang, Satoru Horii and Yasuhiro Taga Faculty of
KeySQL R5.1 Release Note
KeySQL for Microsoft Windows 5.1 2005 10 : B19176-02 Copyright 2005, Oracle Corporation All Right Reserved Oracle Oracle Oracle Corporation KeySQL for Microsoft Windows 5.1 : B19176-02 Copyright 2005,
S2Dao入門
2007 Spring S2Dao 入門 大中浩行 (a.k.a. せとあずさ ) 2007 Spring Copyright 2004-2007 The Seasar Foundation and the others. All rights reserved. 1 自己紹介 大中浩行 (a.k.a. せとあずさ ) azusa@fieldnotes.jp http://www.fieldnotes.jp/d/
橡PervasiveSQL2000ReviewersGuide.PDF
Pervasive.SQL 2000 Reviewer s Guide Pervasive.SQL TM 2000 Reviewer s Guide Rev.1 11/99 Pervasive Software Inc. The Freedom to Create Applications for Everyone, Everywhere ...3 Pervasive.SQL 2000...4 Pervasive.SQL
answer.indd
1 1 1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 supplier(supplier_no, city) supplier_article(supplier_no, article) 2 3 1.9 1.10 3 3.1 3.2 3.3 3 4 3.4 1801 16 3 1 'test' 3.5 4 4.1 4.2 4.3 SET DATEFORMAT ymd; 4.4 SELECT
Oracle Change Management Pack, Oracle Diagnostics Pack, Oracle Tuning Packインストレーション・ガイド リリース2.2
Oracle Enterprise Manager Oracle Change Management Pack, Oracle Diagnostics Pack, Oracle Tuning Pack 2.2 2000 11 : J02263-01 Oracle Change Management Pack, Oracle Diagnostics Pack, Oracle Tuning Pack 2.2
PowerPoint Presentation
上級プログラミング 2( 第 5 回 ) 工学部情報工学科 木村昌臣 今日のテーマ データベース入門 データベースシステムの用意の仕方 データベースを作ってみる データベースを使ってみる データベースプログラミング JDBCを使った検索プログラム JDBCを使った更新プログラム データベース入門 今回の説明は Windows 環境を前提としているため Linux など他のプラットフォーム上で作業を行う場合は
dbMAGIC Ver8.2 SQLガイド
dbmagic dbmagic SQL dbmagic SQL dbmagic 1999 2 5 (1) (2) (3) (4) (3) Windows WindowsNT Microsoft Corporation Java Sun Microsystems,Inc. dbmagic Copyright 1999 ii SQL 1 1 1 1.1 : : : : : : : : : : : : :
RX600 & RX200シリーズ アプリケーションノート RX用仮想EEPROM
R01AN0724JU0170 Rev.1.70 MCU EEPROM RX MCU 1 RX MCU EEPROM VEE VEE API MCU MCU API RX621 RX62N RX62T RX62G RX630 RX631 RX63N RX63T RX210 R01AN0724JU0170 Rev.1.70 Page 1 of 33 1.... 3 1.1... 3 1.2... 3
Microsoft Word - ACCESSINGO...
Java から Oracle へのアクセス Salman Khan はじめに Java プログラムを記述してデータベースにアクセスしたいとします 何を使えばよいでしょうか JDBC または SQLJ でしょうか 両方とも API ( またはドライバ またはパッケージ... どのようにでも呼ぶことができます ) で データベースにアクセスできます なぜ 1 つではなく 2 つの API があるのでしょうか
Oracle8i Java ストアド・プロシージャ開発者ガイド, リリース8.1
Oracle8i Java 8.1 2000 2 J00965-01 Oracle8i Java, 8.1 J00965-01 Oracle8i Java Stored Procedures Developer s Guide, Release 2 (8.1.6) A81358-01 Tom Portfolio Dave Alpern, Gray Clossman, Matthieu Devin,
Oracle DatabaseとIBM DB2 UDBの技術的比較: パフォーマンスを重視
Oracle Database IBM DB2 UDB : 2005 9 Oracle Database IBM DB2 UDB :... 3... 4 Oracle Database Oracle Database IBM DB2... 4... 5... 5... 6... 7... 9... 10... 10 Oracle Database 10g Oracle Real Application