How To Create an Oracle Testing Table?
Submitted by: AdministratorIf 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.
Submitted by: Administrator
>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.
Submitted by: Administrator
Read Online Oracle Database Job Interview Questions And Answers
Top Oracle Database Questions
| ☺ | How To Write Date and Time Interval Literals in Oracle? |
| ☺ | What Happens to Indexes If You Drop a Table? |
| ☺ | How To Recover a Dropped Table in Oracle? |
| ☺ | How To Call a Stored Function in Oracle? |
| ☺ | What Is SQL in Oracle? |
Top DB Oracle Categories
| ☺ | Oracle PL-SQL Interview Questions. |
| ☺ | Oracle DBA Interview Questions. |
| ☺ | Oracle D2K Interview Questions. |
| ☺ | OCI Interview Questions. |
| ☺ | Oracle RMAN Interview Questions. |
