Shulou(Shulou.com)05/31 Report--

Editor to share with you how to write the sentence in Oracle. I hope you will have something to gain after reading this article. Let's discuss it together.

What is the construction statement of Oracle?

The table creation statement of oracle database. The specific syntax is as follows:

CREATE TABLE tablename (column_name datatype [null,not null], column_name datatype [null,not null],. [constraint])

Recommend "SQL tutorial"

Syntax description:

Tablename: the table name of the table to be created in the database. The table name in the same database cannot be repeated.

Column_name: the column name of the created table, and the column name cannot be repeated in a table

Datatype: the data type that holds the data in the column of the created table

Null,not null: allows the column to be empty or not empty, which is not empty by default

Constraint: set constraints for columns in a table, such as primary key constraints, foreign key constraints, unique constraints, etc.

Example:

Create table table_name (id numner (12), text verchar2 (255CHAR) not null,-- char type, one Chinese character occupies one length PID varchar2 (32 BYTE) NOT NULL,-- byte type, UTF8 one Chinese character occupies about two lengths status number (1) DEFAULT 0 null-- add default value if empty default value is 0) read this article I believe you have a certain understanding of "how to write table sentences in Oracle". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

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.