Basic Oracle Concepts and Programming Question:
Download Questions PDF

How To Create a Testing Table in Oracle?

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.

Download Oracle Database Interview Questions And Answers PDF

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