Flylib.com
List of Tables
Previous page
Table of content
Next page
Chapter 1: Introduction
Table 1-1: Commonly Used Oracle Data Types
Table 1-2: Special Values
Chapter 3: Using Simple Functions
Table 3-1: Character Functions
Table 3-2: Numeric Functions
Table 3-3: Conversion Functions
Table 3-4: Format Parameters
Table 3-5: Regular Expression Metacharacters
Table 3-6: Regular Expression Functions
Table 3-7: Aggregate Functions
Chapter 4: Storing and Processing Dates and Times
Table 4-1: TO_CHAR() and TO_DATE() Conversion Functions
Table 4-2: Datetime Formatting Parameters
Table 4-3: How Two-Digit Years Are Interpreted
Table 4-4: Datetime Functions
Table 4-5: Time ZoneRelated Functions
Table 4-6: Timestamp Types
Table 4-7: Timestamp-Related Functions
Table 4-8: Time Interval Types
Table 4-9: Time IntervalRelated Functions
Chapter 7: Advanced Queries
Table 7-1: Set Operators
Table 7-2: Ranking Functions
Chapter 8: Changing Table Contents
Table 8-1: Concurrent Transactions
Table 8-2: Serializable Transactions
Chapter 9: Database Security
Table 9-1: Commonly Used System Privileges
Table 9-2: Some Columns in user_sys_privs
Table 9-3: Commonly Used Object Privileges
Table 9-4: Some Columns in user_tab_privs_made
Table 9-5: Some Columns in user_col_privs_made
Table 9-6: Some Columns in user_tab_privs_recd
Table 9-7: Some Columns in user_col_privs_recd
Table 9-8: Roles to be Created
Table 9-9: Some Columns in user_role_privs
Table 9-10: Some Columns in role_sys_privs
Table 9-11: Some Columns in role_tab_privs
Chapter 10: Creating Tables, Sequences, Indexes, and Views
Table 10-1: Some Columns in
user_tables
Table 10-2: Some Columns in
user_tab_columns
Table 10-3: Constraints
Table 10-4: Some Columns in
user_constraints
Table 10-5: Some Columns in
user_cons_columns
Table 10-6: Some Columns in
user_sequences
Table 10-7: Some Columns in
user_indexes
Table 10-8: Some Columns in
user_ind_columns
Table 10-9: Some Columns in
user_views
Chapter 11: Introducing PL/SQL Programming
Table 11-1: Predefined Exceptions
Table 11-2: Some Columns in
user_procedures
Table 11-3: Some Columns in
user_triggers
Chapter 13: Collections
Table 13-1: Some Columns in user_varrays
Table 13-2: Some Columns in user_nested_tables
Table 13-3: Collection Methods
Chapter 14: Large Objects
Table 14-1: DBMS_LOB Methods
Table 14-2: Exceptions Thrown by READ()
Table 14-3: Exceptions Thrown by WRITE()
Table 14-4: Exception Thrown by APPEND()
Table 14-5: Exceptions Thrown by COMPARE()
Table 14-6: Exceptions Thrown by COPY()
Table 14-7: Exception Thrown by CREATETEMPORARY()
Table 14-8: Exceptions Thrown by ERASE()
Table 14-9: Exceptions Thrown by FILECLOSE()
Table 14-10: Exception Thrown by FILECLOSEALL()
Table 14-11: Exceptions Thrown by FILEEXISTS()
Table 14-12: Exceptions Thrown by FILEGETNAME()
Table 14-13: Exceptions Thrown by FILEISOPEN()
Table 14-14: Exceptions Thrown by FILEOPEN()
Table 14-15: Exception Thrown by FREETEMPORARY()
Table 14-16: Exception Thrown by GETCHUNKSIZE()
Table 14-17: Exception Thrown by GETLENGTH()
Table 14-18: Exception Thrown by INSTR()
Table 14-19: Exception Thrown by ISOPEN()
Table 14-20: Exception Thrown by ISTEMPORARY()
Table 14-21: Exceptions Thrown by LOADFROMFILE()
Table 14-22: Exceptions Thrown by LOADBLOBFROMFILE()
Table 14-23: Exceptions Thrown by LOADCLOBFROMFILE()
Table 14-24: Exception Thrown by OPEN()
Table 14-25: Exceptions Thrown by SUBSTR()
Table 14-26: Exceptions Thrown by TRIM()
Table 14-27: Exceptions Thrown by WRITEAPPEND()
Chapter 15: Running SQL Using Java
Table 15-1: DataSource Attributes
Table 15-2: OracleDataSource Attributes
Table 15-3: Compatible Type Mappings
Table 15-4: short, int, and long Types
Table 15-5: float and double Types
Table 15-6: Classes and Compatible Oracle Database Types
Table 15-7: Classes and Interfaces of the oracle.jdbc Package
Chapter 16: High Performance SQL Tuning
Table 16-1: Plan Table Columns
Table 16-2: Execution Plan Operations
Appendix: Oracle Data Types
Table A-1: Oracle SQL Types
Table A-2: Oracle PL/SQL Types
Previous page
Table of content
Next page
Oracle Database 10g SQL (Osborne ORACLE Press Series)
ISBN: 0072229810
EAN: 2147483647
Year: 2004
Pages: 217
Authors:
Jason Price
,
McGraw-Hill
BUY ON AMAZON
Beginning Cryptography with Java
Certificate Revocation and Path Validation
Key and Certificate Management Using Keystores
CMS and S/MIME
Appendix A Solutions to Exercises
Appendix C Using the Bouncy Castle API for Elliptic Curve
The .NET Developers Guide to Directory Services Programming
Introduction to LDAP and Active Directory
System.DirectoryServices Overview
Active Directory and ADAM Schema
Group Management
The Reflection Method
SQL Tips & Techniques (Miscellaneous)
Working with Queries, Expressions, and Aggregate Functions
Understanding Transaction Isolation Levels and Concurrent Processing
Writing External Applications to Query and Manipulate Database Data
Monitoring and Enhancing MS-SQL Server Performance
Working with Stored Procedures
Cisco IP Telephony (CIPT) (Authorized Self-Study) (2nd Edition)
Cisco Unified Communications
Configuring User Features, Part 2
Encryption
Configuring Cisco IP Telephony Authentication and Encryption
Database Management Tools
C++ How to Program (5th Edition)
Summary
explicit Constructors
Introduction
Exercises
Bitwise Operators
Extending and Embedding PHP
Working with Arrays and HashTables
zval* Array API
Extension Globals
Looking for Libraries
Summary
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies