Oracle 11g SQL语言速查手册：关键特性与参考 - CSDN文库

需积分: 5 82 浏览量更新于2024-06-25 收藏 1006KB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

资源详情

资源推荐

Syntax for SQL Statements

1-10 Oracle Database SQL Language Quick Reference

CREATE FUNCTION

CREATE [ OR REPLACE ] FUNCTION plsql_source

CREATE INDEX

CREATE [ UNIQUE | BITMAP ] INDEX [ schema. ] index

ON { cluster_index_clause

| table_index_clause

| bitmap_join_index_clause

}

[ UNUSABLE ] ;

CREATE INDEXTYPE

CREATE [ OR REPLACE ] INDEXTYPE [ schema. ] indextype

FOR [ schema. ] operator (paramater_type [, paramater_type ]...)

[, [ schema. ] operator (paramater_type [, paramater_type ]...)

]...

using_type_clause

[WITH LOCAL [RANGE] PARTITION ]

[ storage_table_clause ]

;

CREATE JAVA

CREATE [ OR REPLACE ] [ AND { RESOLVE | COMPILE } ] [ NOFORCE ]

JAVA { { SOURCE | RESOURCE } NAMED [ schema. ] primary_name

| CLASS [ SCHEMA schema ]

}

[ invoker_rights_clause ]

[ RESOLVER ( (match_string [,] { schema_name | - })...) ]

{ USING { BFILE (directory_object_name, server_file_name)

| { CLOB | BLOB | BFILE } subquery

| 'key_for_BLOB'

}

| AS source_char

} ;

CREATE LIBRARY

CREATE [ OR REPLACE ] LIBRARY plsql_source

CREATE MATERIALIZED VIEW

CREATE MATERIALIZED VIEW [ schema. ] materialized_view

[ OF [ schema. ] object_type ]

[ ( { scoped_table_ref_constraint

| column_alias [ENCRYPT [encryption_spec]]

}

[, { scoped_table_ref_constraint

| column_alias [ENCRYPT [encryption_spec]]

}

]...

)

]

{ ON PREBUILT TABLE

[ { WITH | WITHOUT } REDUCED PRECISION ]

| physical_properties materialized_view_props

}

[ USING INDEX

[ physical_attributes_clause

Note: You can specify the

[NO]

OPTIMIZE

DATA

clause in this

statement starting with Oracle Database 11g Release 2 (11.2.0.4).

剩余135页未读，继续阅读

weixin_40191861_zj

粉丝: 68
资源: 1万+

会员权益专享

图片转文字

全年可省5，000元立即开通

最新资源

资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！点击此处反馈