Basic Oracle Concepts and Programming Question:

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.