Designed to exploit Oracle 10g's SQL, this book takes a comprehensive look at Oracle 10g's analytical functions, MODEL statements, and regular expressions. In addition, Advanced SQL Functions in Oracle 10g covers collection objects and object-oriented structures and introduces new Oracle 10g topics such as XML and statistical functions. The authors' logical and developmental approach to query building includes a review of older Oracle tools to help in the transition to newer material. This text will teach the reader how to: Format result sets with SQL*Plus reporting tools. Use aggregate functions for partitioning, ordering, and reporting. Perform calculations with the MODEL...
Nội dung trích xuất từ tài liệu:
Advanced SQL Functions in Oracle 10g
Advanced SQL Functions in Oracle 10g
Số trang: 417
Loại file: pdf
Dung lượng: 7.67 MB
Lượt xem: 35
Lượt tải: 0
Thông tin tài liệu:
Tìm kiếm theo từ khóa liên quan:
computer documentation computer tips installation tips data management database data architectureTài liệu có liên quan:
-
Trắc nghiệm 300 câu phân tích và thiết kế hệ thống
29 trang 122 0 0 -
863 trang 89 0 0
-
710 trang 45 0 0
-
Windows XP Hacks & Mods for Dummies
387 trang 38 0 0 -
0 trang 36 0 0
-
368 trang 34 0 0
-
Using Data Dictionary and Dynamic Performance Views
20 trang 34 0 0 -
Lecture Introduction to computing - Lesson 36: Data management
54 trang 34 0 0 -
Nhập môn Cơ sở Dữ liệu - Phần 5
51 trang 34 0 0 -
568 trang 33 0 0
