Chapter 3, Problem 2RQ

Explanation of Solution

Datatypes supported by Oracle 12c:

• While creating a table in the database, each and every column of the table will be having its own data type and the user can select the data type according to his or her requirements.
• The datatypes supported by Oracle 12c include:
  • CHAR
  • DATE
  • VARCHAR2
  • NUMBER

CHAR:

• This data type is used to store the character strings of fixed length.
• The size will be specified in brackets.
• The maximum length of the character will be 255.
• Even blank space is counted as a character.
• For example, create a table named p, which includes a char column (x). The length of each column in 10 bytes.

Create Table p{x Char(10)};

VARCHAR2(n):

• This data type is used to store alphabetical and numeric data length variables.
• It is more flexible than Char data type, with its maximum capacity of 4000 characters.
• Here, n represents the maximum length of the column.
• For example, create a table named p, which includes a char column (x)...