Datatypes

Each value in the database has a datatype, which associates a set of properties with it – for example, a DATE column can accept dates only, not strings or numbers. Datatypes may be built-in or user-defined.

Thumbnail image for 10 Important Lessons in Data Modeling

10 Important Lessons in Data Modeling

Follow these ten data modeling guidelines to make sure that your application database design is accurate, usable and scalable.

Read the Full Article →
Thumbnail image for An Easy Guide to PL/SQL Collections

An Easy Guide to PL/SQL Collections

Oracle PL/SQL collections are of three types: Index By Tables, Nested Tables, Varrays. Here’s a comparison chart of the types of PL/SQL collections based on parameters such as size, ease of modification, and persistence.

Read the Full Article →
Thumbnail image for The BOOLEAN Datatype in Oracle

The BOOLEAN Datatype in Oracle

Oracle database has a BOOLEAN datatype only in PL/SQL, not in SQL. There is no direct way to represent that a column value is TRUE or FALSE. However, the BOOLEAN datatype can be easily simulated in Oracle with these implementation ideas.

Read the Full Article →
Thumbnail image for The Difference between CHAR, VARCHAR and VARCHAR2

The Difference between CHAR, VARCHAR and VARCHAR2

Oracle has three datatypes to store strings. – CHAR, VARCHAR and VARCHAR2. How do they differ from each other? When should you use which? This article gives you the lowdown on the subject.

Read the Full Article →
Page 2 of 2
1
2