Answers

Question and Answer:

  Home  Oracle Database

⟩ How To Create a Testing Table in Oracle?

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.

 179 views

More Questions for you: