Summary: in this video tutorial, you will learn how to use the Oracle CREATE TABLE statement to create a new table in the Oracle database.
Introduction to Oracle CREATE TABLE statement
To create a new table in Oracle Database, you use the CREATE TABLE statement. The following illustrates the basic syntax of the CREATE TABLE statement:
CREATE TABLE table_name (
column_1 data_type column_constraint,
column_2 data_type column_constraint,
...
table_constraint
);
Code language: SQL (Structured Query Language) (sql)
In this syntax:
First, specify the table name
Second, list all columns of the table within the parentheses. In case a table has multiple columns, you need to separate them by commas (,). A column definition includes the column name followed by its data type e.g., NUMBER, VARCHAR2, and a column constraint such as NOT NULL, primary key, check.
Third, add table constraints if applicable e.g., primary key, foreign key, check.
#oracleplsql #banglatutorial #oracle #universityofscholars #trustcoding #786ahsanarif #oraclejavacertification
