PLSQL袖珍参考手册(第4版)(Oracle.PLSQL.Language.Pocket.Reference)

沫沫

PLSQL袖珍参考手册(第4版)(Oracle.PLSQL.Language.Pocket.Reference)


文档节选：Introduction 1
Acknowledgments 1
Conventions 2
PL/SQL Language Fundamentals 2
PL/SQL Character Set 2
Identifiers 3
Boolean, Numeric, and String Literals 4
Numeric Literals 5
Datetime Interval Literals 6
Delimiters 6
Comments 8
Pragmas 8
Statements 9
Block Structure 9
Variables and Program Data 11
Scalar Datatypes 12
LOB Datatypes 18
Implicit Datatype Conversions 19
NULLs in PL/SQL 19
Declaring Variables 19
Anchored Declarations 22
Programmer-Defined Subtypes 23
Conditional and Sequential Control 23
Conditional Control Statements 23
Sequential Control Statements 27
Loops 28
Simple Loop 29
Numeric FOR Loop 29
Cursor FOR Loop 30
WHILE Loop 30
REPEAT UNTIL Loop Emulation 31
EXIT Statement 31
CONTINUE Statement (Oracle Database 11g) 31
Loop Labels 33
Database Interaction 34
Sequences in PLSQL 34
Transaction Management 34
Autonomous Transactions 37
Cursors in PL/SQL 38
Explicit Cursors 38
Implicit Cursors 42
Dynamic Cursors 45
DBMS_SQL 46
SQL Injection and Bind Variables 47
Cursor Variables 48
Cursor Expressions 49
Exception Handling 50
Declaring Exceptions 51
Raising Exceptions 53
Scope 54
Propagation 54
Records in PL/SQL 56
Declaring Records 57
Referencing Fields of Records 58
Assigning Records 58
Records and DML 59
Nested Records 60
Collections in PL/SQL 61
Declaring a Collection 63
Initializing a Collection 64
Adding and Removing Elements 65
Nested Table Functions 65
Collection Methods 68
Collections and Privileges 71
Nested Collections 71
Bulk Binds 71
Built-in Functions and Packages 75
Built-in Functions 75
Built-in Regular Expression Functions 87
Built-in Packages 93
Stored Procedures and Functions 97
Procedures 98
Functions 99
Parameters 100
Local Programs 103
Program Overloading 104
Forward Declarations 106
Table Functions 106
Function Result Cache 107
Privileges and Stored PL/SQL 109

游客，如果您要查看本帖隐藏内容请回复

目景生情

什么？你说的这个是真的？

19830366

每天来学习，跟三通一起成长！

yuaijun8

坚持学习，成就技术技术之王！

hongdouzi555

什么？你说的这个是真的？

lindeone

感谢分享收藏

ReturnDream

xuexile   

hier

无论每天强迫签到还是什么，这个网站实在太棒了

boyfaqiang

每天来学习，跟三通一起成长！

sheeptiger

每天来学习，跟三通一起成长！