Answers

Question and Answer:

  Home  Oracle Database

⟩ How To Create an Oracle Testing Table?

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

>cd (OracleXE home directory)

>.insqlplus /nolog

SQL> connect HR/globalguideline

Connected.

SQL> CREATE TABLE ggl_links (id NUMBER(4) PRIMARY KEY,

url VARCHAR2(16) NOT NULL,

notes VARCHAR2(16),

counts NUMBER(4),

created DATE DEFAULT (sysdate));

Table created.

You should keep this table for to practice other tutorial exercises presented in this collection.

 198 views

More Questions for you: