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".
2020-02-29, 895👍, 0💬
Popular Posts:
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How To Import One Table Back from a Dump File in Oracle? If you only want to import one table back t...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
How do you know if SQL Server is running on your local system in SQL Server? After installing SQL Se...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...