Collections:
Create a New Table in Oracle
How To Create a New Table in Oracle?
✍: FYIcenter.com
If you want to create a new table in your own schema, you can log into the server with your account, and use the CREATE TABLE statement. The following script shows you how to create a table:
>.\bin\sqlplus /nolog SQL> connect HR/fyicenter Connected. SQL> CREATE TABLE tip (id NUMBER(5) PRIMARY KEY, 2 subject VARCHAR(80) NOT NULL, 3 description VARCHAR(256) NOT NULL, 4 create_date DATE DEFAULT (sysdate)); Table created.
This scripts creates a testing table called "tip" with 4 columns in the schema associated with the log in account "HR".
⇒ Create a New Table with SELECT Statements in Oracle
⇐ What Are DDL Statements in Oracle
2020-02-29, 1473👍, 0💬
Popular Posts:
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
Where to find answers to frequently asked questions on Introduction to Date and Time Handling in MyS...
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...