Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Sql code help
Grant Collins wrote:
>
>
> Hi,
>
> Can anyone help me? I am doing a project using sql scripts. I am
trying to
> write a script that will insert data a number of times into a table.
Instead
> of just once at a time. Can anyone help me with this?
>
> Is there anyother way of putting data into table instead of the
> insert into <tablename> values (....);?
>
> Many thanks
>
> Grant
> collinz_at_clara.co.uk
>
> try this: Example==> Accept name Prompt 'Please enter the Name: '
Accept job Prompt 'Please enter the Job: ' (and so on......) Insert into Emp values('&name','&job');I don't think there's another way of inserting data into a table without using the ( INSERT into table_name VALUES ).
-- Posted via CNET Help.com http://www.help.com/Received on Sun Feb 04 2001 - 22:30:08 CST
![]() |
![]() |