Introduction to SQL and PL/SQL

Front Cover
Firewall Media, Jan 1, 2007 - PL/SQL (Computer program language) - 389 pages
1 Review
 

What people are saying - Write a review

User Review - Flag as inappropriate

great book for practical purpose .......:)

Contents

Column Aliases 5
11
Column Format
58
Lab Assignment3
66
Synonym
72
Lab Assignment5
82
Numeric Functions
96
Character Functions
103
Conversion Functions
122
SQLPLUS Report Commands
184
Lab Assignment10
194
Lexical Units
200
Variables and Data Types
207
Operator Precedence
223
Control Structures
231
Sequential Control
248
Advantages of PLSQL
282

LOB and Miscellaneous Functions
128
Aggregate Functions Group Function
135
First Normal Form
142
Fourth Normal Form
150
RELATIONS JOIN REPORTS
159
Set Operators
169
Having Clause
175
Subquery
176
Declaring Cursors
290
Closing Cursors
299
Cursor Variables
308
The Cursor FOR Loop
318
Lab AssignmentI3
325
PROCEDURE AND FUNCTIONS
359
Index
385
Copyright

Common terms and phrases

Bibliographic information