This document provides a tutorial of SQL routines and types using the Java\u2122 programming language.<\/p>\n
This document discusses the following features of the SQL Language:<\/p>\n
The use of routineswritten in the Java programming languagewithin SQL expressions and statements.<\/p>\n<\/li>\n
The use of user-defined types written in the Java programming language within SQL expressions and statements<\/p>\n<\/li>\n<\/ul>\n
| PDF Pages<\/th>\n | PDF Title<\/th>\n<\/tr>\n | ||||||
|---|---|---|---|---|---|---|---|
| 2<\/td>\n | undefined <\/td>\n<\/tr>\n | ||||||
| 5<\/td>\n | Contents <\/td>\n<\/tr>\n | ||||||
| 7<\/td>\n | Foreword <\/td>\n<\/tr>\n | ||||||
| 9<\/td>\n | Introduction <\/td>\n<\/tr>\n | ||||||
| 11<\/td>\n | 1 Scope <\/td>\n<\/tr>\n | ||||||
| 12<\/td>\n | 2 Normative references <\/td>\n<\/tr>\n | ||||||
| 13<\/td>\n | 3 Terms and definitions <\/td>\n<\/tr>\n | ||||||
| 14<\/td>\n | 4 Routines tutorial 4.1 Context of routines 4.2 Technical components <\/td>\n<\/tr>\n | ||||||
| 15<\/td>\n | 4.3 Overview 4.4 Example Java methods: region and correctStates <\/td>\n<\/tr>\n | ||||||
| 16<\/td>\n | 4.5 Installing region and correctStates in SQL <\/td>\n<\/tr>\n | ||||||
| 17<\/td>\n | 4.6 Defining SQL names for region and correctStates <\/td>\n<\/tr>\n | ||||||
| 18<\/td>\n | 4.7 A Java method with output parameters: bestTwoEmps <\/td>\n<\/tr>\n | ||||||
| 20<\/td>\n | 4.8 A CREATE PROCEDURE best2 for bestTwoEmps 4.9 Calling the best2 procedure <\/td>\n<\/tr>\n | ||||||
| 21<\/td>\n | 4.10 A Java method returning a result set: orderedEmps <\/td>\n<\/tr>\n | ||||||
| 22<\/td>\n | 4.11 A CREATE PROCEDURE rankedEmps for orderedEmps <\/td>\n<\/tr>\n | ||||||
| 23<\/td>\n | 4.12 Calling the rankedEmps procedure <\/td>\n<\/tr>\n | ||||||
| 24<\/td>\n | 4.13 Overloading Java method names and SQL names <\/td>\n<\/tr>\n | ||||||
| 25<\/td>\n | 4.14 Java main methods <\/td>\n<\/tr>\n | ||||||
| 26<\/td>\n | 4.15 Java method signatures in the CREATE statements <\/td>\n<\/tr>\n | ||||||
| 27<\/td>\n | 4.16 Null argument values and the RETURNS NULL clause <\/td>\n<\/tr>\n | ||||||
| 29<\/td>\n | 4.17 Static variables <\/td>\n<\/tr>\n | ||||||
| 30<\/td>\n | 4.18 Dropping SQL names of Java methods 4.19 Removing Java classes from SQL <\/td>\n<\/tr>\n | ||||||
| 31<\/td>\n | 4.20 Replacing Java classes in SQL <\/td>\n<\/tr>\n | ||||||
| 32<\/td>\n | 4.21 Visibility 4.22 Exceptions <\/td>\n<\/tr>\n | ||||||
| 33<\/td>\n | 4.23 Deployment descriptors <\/td>\n<\/tr>\n | ||||||
| 35<\/td>\n | 4.24 Paths <\/td>\n<\/tr>\n | ||||||
| 37<\/td>\n | 4.25 Privileges <\/td>\n<\/tr>\n | ||||||
| 38<\/td>\n | 4.26 Information Schema <\/td>\n<\/tr>\n | ||||||
| 39<\/td>\n | 5 Types tutorial 5.1 Overview 5.2 Example Java classes <\/td>\n<\/tr>\n | ||||||
| 41<\/td>\n | 5.3 Installing Address and Address2Line in an SQL system 5.4 CREATE TYPE for Address and Address2Line <\/td>\n<\/tr>\n | ||||||
| 43<\/td>\n | 5.5 Multiple SQL types for a single Java class 5.6 Collapsing subclasses <\/td>\n<\/tr>\n | ||||||
| 45<\/td>\n | 5.7 GRANT and REVOKE statements for data types 5.8 Deployment descriptors for classes <\/td>\n<\/tr>\n | ||||||
| 46<\/td>\n | 5.9 Using Java classes as data types <\/td>\n<\/tr>\n | ||||||
| 47<\/td>\n | 5.10 SELECT, INSERT, and UPDATE <\/td>\n<\/tr>\n | ||||||
| 48<\/td>\n | 5.11 Referencing Java fields and methods in SQL 5.12 Extended visibility rules <\/td>\n<\/tr>\n | ||||||
| 49<\/td>\n | 5.13 Logical representation of Java instances in SQL <\/td>\n<\/tr>\n | ||||||
| 50<\/td>\n | 5.14 Static methods <\/td>\n<\/tr>\n | ||||||
| 51<\/td>\n | 5.15 Static fields 5.16 Instance-update methods <\/td>\n<\/tr>\n | ||||||
| 53<\/td>\n | 5.17 Subtypes in SQL\/JRT data <\/td>\n<\/tr>\n | ||||||
| 54<\/td>\n | 5.18 References to fields and methods of null instances <\/td>\n<\/tr>\n | ||||||
| 55<\/td>\n | 5.19 Ordering of SQL\/JRT data <\/td>\n<\/tr>\n<\/table>\n","protected":false},"excerpt":{"rendered":" Information technology. Guidance for the use of database language SQL – Routines and types using the JavaTM<\/sup> programming language<\/b><\/p>\n |