Collections:
Create a New Table in Your Schema in Oracle
How To Create a New Table in Your Schema 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 by Selecting Rows from Another Table in Oracle
⇐ Types of Tables Supported by Oracle in Oracle
2019-06-01, 1552🔥, 0💬
Popular Posts:
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...