Basic Oracle Concepts and Programming Question:
How To Create an Oracle Testing Table?
Answer:
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.
>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.
| Previous Question | Next Question |
| How To End the Current Transaction in Oracle? | How To Commit the Current Transaction in Oracle? |