Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How To Insert DATE
Thank you very very much to all of you, who have made my life very
easier. i'm actually a computer science college student and just
started to learn database. i am novice.
by the way, thanx a lot to all of you who have posted replies to my
question. thanx.
In article <95gn8d$qvp$1_at_nnrp1.deja.com>,
jokesmalaysia_at_my-deja.com wrote:
> 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/
>
Sent via Deja.com
http://www.deja.com/
Received on Sat Feb 03 2001 - 16:14:45 CST