How To Insert DATE

hello

I have a very tiny, tiny problem
I want to create a table with following attributes:

create table Employee
(emp_id number(4)
 name varchar(15)
 age number(3)
 date_hired date? <-- not sure about this command!!  address varchar (30));

I want to insert this values(example only)

insert into emplyoee
values ('0001', 'John', '23', '18-JAN-2001', 'Chicago');

can someone teach me how to

1) set emp_id as a primary key.
2) insert date such as 18-JAN-2001.
3) save all data into a floppy.

do you have any suggestion on books, newsletters, web, magazine etc, etc?

please help me out here.

i'm a newbie to SQL.

thanx in advance.

Sent via Deja.com
http://www.deja.com/ Received on Sat Feb 03 2001 - 04:41:17 CST