🔥🔥 Don’t Miss Out on Our End of Autumn Sale. If you have any questions, feel free to click the bottom right corner to contact our customer service..

Concat us[email protected]
Shopping Cart

No products in the cart.

🔍
BS ISO/IEC 19075-4:2021

BS ISO/IEC 19075-4:2021

$198.66

Information technology. Guidance for the use of database language SQL – Routines and types using the JavaTM programming language

Published By Publication Date Number of Pages
BSI 2021 62
PDF Format Searchable Printable Preview Now
Guaranteed Safe Checkout
Category:

If you have any questions, feel free to reach out to our online customer service team by clicking on the bottom right corner. We’re here to assist you 24/7.
Email:[email protected]

This document provides a tutorial of SQL routines and types using the Java™ programming language.

This document discusses the following features of the SQL Language:

  • The use of routineswritten in the Java programming languagewithin SQL expressions and statements.

  • The use of user-defined types written in the Java programming language within SQL expressions and statements

PDF Catalog

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

Related products

BS ISO/IEC 19075-4:2021
$198.66