Introduction to Oracle CREATE TABLE statement
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
On this page of the site you can watch the video online Introduction to Oracle CREATE TABLE statement with a duration of hours minute second in good quality, which was uploaded by the user TrustCoding 03 October 2024, share the link with friends and acquaintances, this video has already been watched 101 times on youtube and it was liked by 4 viewers. Enjoy your viewing!
