Create a Test Table for DML Testing in Oracle

Q

How To Create a Testing Table in Oracle?

✍: FYIcenter.com

A

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.

 

Set Up SQL*Plus Output Format in Oracle

What Are DML Statements in Oracle

Understanding SQL DML Statements for Oracle

⇑⇑ Oracle Database Tutorials

2020-02-07, 1474🔥, 0💬