Data Types in Oracle

Numeric Datatypes

• NUMBER - The NUMBER datatype stores fixed and floating-point numbers. Number having precision p and scale s. The precision p can range from 1 to 38. The scale s can range from -84 to 127.

Time and date Datatypes

• DATE - The DATE datatype stores point-in-time values (dates and times) in a table. The DATE datatype stores the year (including the century), the month, the day, the hours, the minutes and the seconds (after midnight). Oracle date format is DD-MON-YY. And the size Fixed at 7 bytes for each row in the table.

• INTERVAL DAY TO SECOND - A period of time which is represented as days, hours, minutes, and seconds. The precision values specify the number of digits in the DAY and the fractional SECOND fields of the date. The precision can be from 0 to 9 and defaults to 2 for days and 6 for seconds. And the size of this fixed at 11 bytes.

• INTERVAL YEAR TO MONTH - A period of time which is represented as years and months. The precision value specifies the number of digits in the YEAR field of the date. The precision can be from 0 to 9 and defaults to 2 for years and the size of this fixed at 5 bytes.

• TIMESTAMP - A specific value which representing a date and time, including fractional seconds and the value of this is 7 to 11 bytes which is depends on the precision.

• TIMESTAMP WITH TIME ZONE - A value representing a date and time, plus an associated time zone setting. The time zone can be an offset from UTC, such as '-5:0' or a region name, such as 'US/Pacific' and the size of this fixed at 13 bytes.

• TIMESTAMP WITH LOCAL TIME ZONE - This is Similar to TIMESTAMP WITH TIME ZONE, except that the data is normalized to the database time zone when it is stored and adjusted to match the client's time zone when retrieved and the values varies from 7 to 11 bytes which is depends on precision.

Binary Datatypes

• BLOB - It is unstructured binary data in the database, which can store up to 128 terabytes of binary data in the database.

• BFILE - It is the variable-length raw binary data in the database and variable for each row in the table up to 2000 bytes per row. A maximum size of the BFILE must be specified. Provided for backward compatibility.

• RAW - It is also the variable-length raw binary data in the database and the variable for each row in the table up to 231 - 1 bytes, or 2 gigabytes per row.

• LONG RAW - It is the Binary data representing row addresses, which is fixed at 10 bytes or 6 bytes for each row in the table.

Here's a free e-book on oracle: Oracle Database Concepts

“World’s First Autonomous Self-Driving Database” Announced by Oracle

Oracle has announced the world’s first autonomous self-driving database.

#news