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是一个通用的数据库管理工具和SQL客户端
共5610个文件
java:3454个
png:1013个
properties:609个
需积分: 46 9 下载量 8 浏览量
2019-08-08
03:31:17
上传
评论
收藏 11.26MB ZIP 举报
温馨提示
DBeaver 是一个通用的数据库管理工具和 SQL 客户端,支持 MySQL, PostgreSQL, Oracle, DB2, MSSQL, Sybase, Mimer, HSQLDB, Derby, 以及其他兼容 JDBC 的数据库。DBeaver 提供一个图形界面用来查看数据库结构、执行SQL查询和脚本,浏览和导出数据,处理BLOB/CLOB 数据,修改数据库结构等等。
资源推荐
资源详情
资源评论
收起资源包目录
DBeaver是一个通用的数据库管理工具和SQL客户端 (5610个子文件)
splash.bmp 527KB
dbeaver-256x256x32.bmp 256KB
dbeaver_back.bmp 151KB
dbeaver-48x48x32.bmp 9KB
dbeaver-32x32x32.bmp 4KB
dbeaver-48x48x8.bmp 3KB
dbeaver-32x32x8.bmp 2KB
dbeaver-16x16x32.bmp 1KB
dbeaver-16x16x8.bmp 634B
generate.cmd 2KB
gen_headers.cmd 316B
show_sigs.cmd 177B
copy_contrib.cmd 145B
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 13KB
e4-dark_dbeaver_prefstyle.css 3KB
site.css 687B
overview.css 377B
tutorials.css 363B
whatsnew.css 193B
e4-dark_erd_prefstyle.css 87B
Chinook.db 1.08MB
jkiss_wmi.dll 216KB
jkiss_wmi.dll 156KB
erd-model.doc 13KB
dbeaver.e4xmi 4KB
.eclipseproduct 80B
org.jkiss.dbeaver.dataSourceProvider.exsd 26KB
org.jkiss.dbeaver.dataTransfer.exsd 7KB
org.jkiss.dbeaver.databaseEditor.exsd 7KB
org.jkiss.dbeaver.aggregateFunction.exsd 6KB
org.jkiss.dbeaver.dataFormatter.exsd 6KB
org.jkiss.dbeaver.utils.exsd 6KB
org.jkiss.dbeaver.tools.exsd 6KB
org.jkiss.dbeaver.dataTypeProvider.exsd 5KB
org.jkiss.dbeaver.networkHandler.exsd 4KB
org.jkiss.dbeaver.sqlFormatter.exsd 4KB
org.jkiss.dbeaver.sqlPlanView.exsd 4KB
org.jkiss.dbeaver.resourceHandler.exsd 4KB
org.jkiss.dbeaver.dataSourceView.exsd 4KB
org.jkiss.dbeaver.dataManager.exsd 4KB
org.jkiss.dbeaver.resultset.presentation.exsd 3KB
org.jkiss.dbeaver.sql.convert.exsd 3KB
org.jkiss.dbeaver.resultset.panel.exsd 3KB
org.jkiss.dbeaver.objectManager.exsd 3KB
org.jkiss.dbeaver.dashboard.exsd 3KB
org.jkiss.dbeaver.product.bundles.exsd 3KB
org.jkiss.dbeaver.commandLine.exsd 3KB
org.jkiss.dbeaver.sqlPresentation.exsd 3KB
org.jkiss.dbeaver.resources.exsd 3KB
org.jkiss.dbeaver.sqlCommand.exsd 3KB
org.jkiss.dbeaver.mockGenerator.exsd 2KB
org.jkiss.dbeaver.data.gis.geometryViewer.exsd 2KB
org.jkiss.dbeaver.debug.configurationPanels.exsd 2KB
org.jkiss.dbeaver.ext.erd.export.format.exsd 2KB
org.jkiss.dbeaver.mavenRepository.exsd 2KB
org.jkiss.dbeaver.language.exsd 2KB
org.jkiss.dbeaver.pluginService.exsd 2KB
org.jkiss.dbeaver.workbenchHandler.exsd 2KB
org.jkiss.dbeaver.postgresql.serverType.exsd 2KB
org.jkiss.dbeaver.application.exsd 2KB
org.jkiss.dbeaver.service.exsd 2KB
org.jkiss.dbeaver.generic.meta.exsd 2KB
org.jkiss.dbeaver.ui.propertyConfigurator.exsd 2KB
org.jkiss.dbeaver.driverManager.exsd 1KB
org.jkiss.dbeaver.net.ssh.exsd 1KB
mylyn-overview-small.gif 82KB
mylyn-overview.gif 59KB
wn_mylyn48_hov.gif 2KB
ov_mylyn48.gif 2KB
ov_legend48.gif 2KB
tu_task48_hov.gif 2KB
ov_legend48_hov.gif 2KB
wn_mylyn48.gif 2KB
tu_task48.gif 2KB
ov_mylyn48_hov.gif 2KB
tu_query48_hov.gif 2KB
tu_query48.gif 2KB
progress_3.gif 1KB
progress_9.gif 1KB
progress_2.gif 1KB
progress_8.gif 1KB
progress_6.gif 1KB
progress_0.gif 1KB
progress_5.gif 1KB
progress_7.gif 1KB
progress_1.gif 1KB
progress_4.gif 1KB
udt.gif 630B
nickname.gif 587B
home.gif 582B
remoteServer.gif 577B
共 5610 条
- 1
- 2
- 3
- 4
- 5
- 6
- 57
资源评论
weixin_39840924
- 粉丝: 492
- 资源: 1万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- note test a bc d e f g h
- MERGE.csv.zip
- 15白落梅:你是锦瑟我为流年:三毛的万水千山-3491776.mobi
- 微信小程序源码 实现 城市切换 demo 根据城市首字母排序城市 选择城市
- 12因为懂得 所以慈悲-张爱玲的倾城往事 (白落梅经典散文系列)-3321089.mobi
- 基于 C# 实现的串口温度监控软件
- 基于STM32F103RBT6单片机+SIM868自动收货机主控板硬件(原理图+PCB)工程文件.zip
- 微信小程序源码 车源宝 二手车交易平台 源码下载
- 专注于在线教育领域,打造更好的网课系统,网校系统,知识付费系统
- ADM487EARZ-REEL7 产品规格书pdf
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功