Collections:
Create a Test Table for DML Testing in Oracle
How To Create a Testing Table in Oracle?
✍: FYIcenter.com
If you want to practice DML statements, you should create a testing table as shown in the script below:
CREATE TABLE fyi_links (id NUMBER(4) PRIMARY KEY, url VARCHAR2(80) NOT NULL, notes VARCHAR2(1024), counts NUMBER, created DATE DEFAULT (sysdate)); Table created.
You should keep this table for to practice other tutorial exercises presented in this collection.
2016-10-16, 399👍, 0💬
Popular Posts:
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...