How To Create a Testing Table?
Page 1 of 1
How To Create a Testing Table?
by Micheal Sat Jan 16, 2010 9:33 pm
If you want to practice DML statements, you should create a testing table as shown in the script
below:
CREATE TABLE fyi_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
below:
CREATE TABLE fyi_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
Micheal- Admin
- Posts : 243
Join date : 2010-01-10 -
Similar topics» How To Create a Table Index?
» How To Create a New Table by Selecting Rows from Another Table?
» How To Create a New Table by Selecting Rows from Another Table?
» How To Create a New Table?
» How To Create a New Table in Your Schema?
» How To Create a New Table by Selecting Rows from Another Table?
» How To Create a New Table by Selecting Rows from Another Table?
» How To Create a New Table?
» How To Create a New Table in Your Schema?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
» Accessing tables of other users in SQL
» Grouping commands in SQL
» Operations on Result Sets in SQL
» Subqueries in SQL
» Joining Relations in SQL
» Delete comand in SQL
» Update command in SQL
» Insert command in SQL