Basic Oracle Concepts and Programming Question:

How To Create a Testing Table in Oracle?

Oracle Database Interview Question
Oracle Database Interview Question

Answer:

If you want to practice DML statements, you should create a testing table as shown in the script below:

CREATE TABLE ggl_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.


Previous QuestionNext Question
What Are DML Statements in Oracle?How To Set Up SQL*Plus Output Format in Oracle?