Abstract
Chapter 3 introduced just enough data definition (DDL) syntax to enable you to create the seven case tables for this book, using simple CREATE TABLE commands without any constraint specifications. This second DDL chapter goes into more detail about some data definition aspects, although it is still not intended as a complete reference on the topic. (Discussion of the CREATE TABLE command alone covers more than 100 pages in the Oracle Database documentation.)
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
Sequence objects and their CURRVAL and NEXTVAL expressions are described later in the chapter, in Section 7.7.
- 2.
When the database initialization parameter MAX_STRING_SIZE has the value of STANDARD, then the VARCHAR2 datatype has a maximum size of 4,000 bytes. When the parameter is set to EXTENDED in Oracle12c or above, then the maximum is 32,767 bytes.
- 3.
When MAX_STRING_SIZE has the value of STANDARD, then the RAW datatype has a maximum size of 2,000 bytes; when the parameter is set to EXTENDED in Oracle 12c or above, then the maximum is 32.767 bytes.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2014 Tim Gorman
About this chapter
Cite this chapter
Gorman, T. (2014). Data Definition, Part II. In: Beginning Oracle SQL. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-6557-3_7
Download citation
DOI: https://doi.org/10.1007/978-1-4302-6557-3_7
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-6556-6
Online ISBN: 978-1-4302-6557-3
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books