Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: plsql problem
m.himansu_at_sify.com (Himansu) wrote in message news:<33194ce2.0110190230.167ca5ae_at_posting.google.com>...
> Hi Everybody !
>
> I've a problem in Pl/sql...I don't know if it is possible too.
>
> I want to enter suppose 10 records into a table from sql*Plus in
> interactive mode...I want it to ask me each time the fields of the new
> record and enter it into the table.
> I tried it with loops(both for and while)in pl/sql blocks and also in
> Procedures.
> What happens is that after I entered the first record, it enters that
> record 10 times(if there is not a primary key in the table)in stead of
> asking me for giving the field values of another record.
> Pls help me soon...
I'm sure that I will not be the only person to respond with the statement: "Send in the code!" No one has any idea what you're actually doing and will not until we can see the code.
Jim Lyons
UT Austin
Received on Fri Oct 19 2001 - 11:27:26 CDT