Information Technology -
Database Language SQL
(Proposed revised text of DIS 9075)
July 1992
(Second Informal Review Draft) ISO/IEC 9075:1992, Database
Language SQL- July 30, 1992
Digital Equipment Corporation
Maynard, Massachusetts
Contents Page
Foreword.........................................................xi
Introduction.....................................................xiii
1 Scope ........................................................ 1
2 Normative references ......................................... 3
3 Definitions, notations, and conventions ...................... 5
3.1 Definitions ................................................ 5
3.1.1Definitions taken from ISO/IEC 10646 ....................... 5
3.1.2Definitions taken from ISO 8601 ............................ 5
3.1.3Definitions provided in this International Standard ........ 5
3.2 Notation ................................................... 7
3.3 Conventions ................................................ 9
3.3.1Informative elements ....................................... 9
3.3.2Specification of syntactic elements ........................ 9
3.3.3Specification of the Information Schema ....................10
3.3.4Use of terms ...............................................10
3.3.4Exceptions .................................................10
3.3.4Syntactic containment ......................................11
3.3.4Terms denoting rule requirements ...........................12
3.3.4Rule evaluation order ......................................12
3.3.4Conditional rules ..........................................13
3.3.4Syntactic substitution .....................................13
3.3.4Other terms ................................................14
3.3.5Descriptors ................................................14
3.3.6Index typography ...........................................15
3.4 Object identifier for Database Language SQL ................16
4 Concepts .....................................................19
4.1 Data types .................................................19
4.2 Character strings ..........................................20
4.2.1Character strings and collating sequences ..................20
4.2.2Operations involving character strings .....................22
4.2.2Operators that operate on character strings and return char-
acter strings...............................................22
4.2.2Other operators involving character strings ................23
4.2.3Rules determining collating sequence usage .................23
4.3 Bit strings ................................................26
4.3.1Bit string comparison and assignment .......................27
4.3.2Operations involving bit strings ...........................27
4.3.2Operators that operate on bit strings and return bit strings
............................................................27
4.3.2Other operators involving bit strings ......................27
ii Database Language SQL
4.4 Numbers ....................................................27
4.4.1Characteristics of numbers .................................28
4.4.2Operations involving numbers ...............................29
4.5 Datetimes and intervals ....................................29
4.5.1Datetimes ..................................................30
4.5.2Intervals ..................................................32
4.5.3Operations involving datetimes and intervals ...............34
4.6 Type conversions and mixing of data types ..................34
4.7 Domains ....................................................35
4.8 Columns ....................................................36
4.9 Tables .....................................................37
4.10 Integrity constraints ......................................40
4.10.Checking of constraints ....................................41
4.10.Table constraints ..........................................41
4.10.Domain constraints .........................................43
4.10.Assertions .................................................43
4.11 SQL-schemas ................................................44
4.12 Catalogs ...................................................45
4.13 Clusters of catalogs .......................................45
4.14 SQL-data ...................................................45
4.15 SQL-environment ............................................46
4.16 Modules ....................................................46
4.17 Procedures .................................................47
4.18 Parameters .................................................47
4.18.Status parameters ..........................................47
4.18.Data parameters ............................................48
4.18.Indicator parameters .......................................48
4.19 Diagnostics area ...........................................48
4.20 Standard programming languages .............................49
4.21 Cursors ....................................................49
4.22 SQL-statements .............................................51
4.22.Classes of SQL-statements ..................................51
4.22.SQL-statements classified by function ......................52
4.22.Embeddable SQL-statements ..................................55
4.22.Preparable and immediately executable SQL-statements .......56
4.22.Directly executable SQL-statements .........................58
4.22.SQL-statements and transaction states ......................59
4.23 Embedded syntax ............................................61
4.24 SQL dynamic statements .....................................61
4.25 Direct invocation of SQL ...................................64
4.26 Privileges .................................................64
4.27 SQL-agents .................................................66
4.28 SQL-transactions ...........................................67
4.29 SQL-connections ............................................70
4.30 SQL-sessions ...............................................72
Table of Contents iii
4.31 Client-server operation ....................................74
4.32 Information Schema .........................................75
4.33 Leveling ...................................................75
4.34 SQL Flagger ................................................76
5 Lexical elements .............................................79
5.1 <SQL terminal character> ...................................79
5.2 <token> and <separator> ....................................82
5.3 <literal> .................................................
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
在原生DBeaver的基础上,支持了DM、Kingbase、瀚高、神通等国产数据库 并且增加了数据库备份还原以及数据迁移等功能 (2000个子文件)
WMIUtils.cpp 12KB
WMIService.cpp 12KB
WMIObject.cpp 7KB
WMIServiceJNI.cpp 6KB
JNIMetaData.cpp 5KB
WMIObjectSink.cpp 4KB
WMIObjectJNI.cpp 4KB
WMIServiceModule.cpp 2KB
stdafx.cpp 22B
leaflet.css 14KB
e4-dark_dbeaver_prefstyle.css 4KB
site.css 687B
overview.css 377B
tutorials.css 363B
whatsnew.css 193B
e4-dark_erd_prefstyle.css 87B
erd-model.doc 13KB
JNIMetaData.h 2KB
WMIUtils.h 2KB
WMIServiceJNI.h 2KB
WMIObjectJNI.h 2KB
stdafx.h 2KB
WMIService.h 2KB
WMIObjectSink.h 1KB
WMIObject.h 839B
eclipse_license.html 9KB
view_template.html 8KB
index.html 2KB
package.html 181B
package.html 103B
package.html 58B
package.html 0B
ResultSetViewer.java 214KB
SQLEditor.java 193KB
LightGrid.java 162KB
SpreadsheetPresentation.java 124KB
DBUtils.java 103KB
UIUtils.java 81KB
DataSourceDescriptor.java 76KB
SQLCompletionAnalyzer.java 74KB
HexEditControl.java 72KB
OracleSchema.java 71KB
DataSourceSerializerModern.java 66KB
DriverDescriptor.java 64KB
DatabaseConsumerPageMapping.java 62KB
ObjectListControl.java 61KB
ERDEditorPart.java 55KB
PostgreDatabase.java 54KB
QueryLogViewer.java 54KB
PropertyTreeViewer.java 51KB
EntityEditor.java 49KB
ResultSetFilterPanel.java 48KB
ResultSetPersister.java 48KB
PostgreSchema.java 47KB
SQLEditorBase.java 47KB
ResultSetModel.java 47KB
OracleDataSource.java 47KB
DriverEditDialog.java 46KB
SQLUtils.java 45KB
DBExecUtils.java 45KB
EditForeignKeyPage.java 45KB
GraphicsToGraphics2DAdaptor.java 44KB
SQLScriptParser.java 44KB
SQLServerSchema.java 44KB
PostgreDataType.java 43KB
SQLQueryJob.java 43KB
MySQLCatalog.java 42KB
StreamTransferConsumer.java 42KB
GenericMetaModel.java 42KB
NavigatorUtils.java 42KB
DatabaseTransferConsumer.java 40KB
DatabaseNavigatorTree.java 40KB
DatabaseTasksTree.java 40KB
DBNDatabaseNode.java 40KB
CustomSashForm.java 40KB
JDBCTable.java 39KB
JDBCResultSetImpl.java 39KB
ComplexObjectEditor.java 38KB
GenericDataSource.java 38KB
DataSourceRegistry.java 37KB
PostgreDataSource.java 37KB
PostgreDebugSession.java 37KB
SSHTunnelConfiguratorUI.java 36KB
TabbedFolderList.java 36KB
JDBCCallableStatementImpl.java 36KB
PostgreUtils.java 36KB
BinaryContent.java 36KB
PostgreProcedure.java 35KB
CoreMessages.java 35KB
Parser.java 35KB
ViewerColumnController.java 34KB
MySQLDataSource.java 34KB
CommonUtils.java 34KB
JDBCDatabaseMetaDataImpl.java 34KB
JDBCResultSetCallable.java 32KB
CSmartCombo.java 32KB
StreamConsumerPageOutput.java 32KB
ObjectPropertiesEditor.java 32KB
DBeaverApplication.java 32KB
ResultSetHandlerMain.java 32KB
共 2000 条
- 1
- 2
- 3
- 4
- 5
- 6
- 20
资源评论
Java程序员-张凯
- 粉丝: 1w+
- 资源: 6650
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功