Basic Oracle Concepts and Programming Question:
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.
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 Question | Next Question |
| What Are DML Statements in Oracle? | How To Set Up SQL*Plus Output Format in Oracle? |