Shulou(Shulou.com)06/01 Report--

1. Oracle creates the table

Format: create table xxx

(

Xxx_id char (10) not null

……

Xxx_name char (20) not null

Xxx_address char (100) null

)

Example: create a customer information table

CREATE TABLE studens

(

Studens_id char (10) NOT NULL

Studens_name char (50) NOT NULL

Studens_address char (50) NULL

Studens_city char (50) NULL

Studens_country char (50) NULL

Studens_email char (255) NULL

);

Description: according to the demand, preset the table field, set the character type for each field, and the column of the table can be set to empty or not empty.

When you create a table, the last field is defined with a semicolon after null or not null, otherwise you will be prompted as follows:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.