Home » SQL & PL/SQL » SQL & PL/SQL » how to insert the data
how to insert the data [message #36515] Sun, 02 December 2001 13:44 Go to next message
Eli
Messages: 3
Registered: December 2001
Junior Member
I already have the table. Right now, I have a problem how to insert the data to the table.
the data is like this :
sectionno=12001, courseno=ITSE1345, day=M, time=5:30PM, hours=4.5
the statement would be like this :
values ('12001','ITSE1345,.......
I don't know how to continue to the "day"
any idea for this?

----------------------------------------------------------------------
Re: how to insert the data [message #36528 is a reply to message #36515] Mon, 03 December 2001 04:48 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
write insert statement according to datatypes , not looking at data.

insert into table_name values('12001','ITSE','M','5:30PM',4.5);

----------------------------------------------------------------------
Re: how to insert the data [message #36633 is a reply to message #36515] Thu, 06 December 2001 19:43 Go to previous message
neeraj
Messages: 16
Registered: October 2001
Junior Member
What is the data type in to which you want to enter the day ?

----------------------------------------------------------------------
Previous Topic: Re: New triggers in Oracle 8i what are they
Next Topic: How to compile a PL/SQL code in Oracle 7.3 SQL prompt?
Goto Forum:
  


Current Time: Thu Mar 28 03:35:01 CDT 2024