DA Morgan wrote:
> fitzjarrell_at_cox.net wrote:
>
> > db2group88_at_yahoo.com wrote:
> >
> >>so if i want to do a insert into a new table where data is from
> >
> > another
> >
> >>table from row 2 to row 10, what should be right query?
> >
> >
> > insert into mynewtable
> > select a.col1, a.col2, a.col3, a.col4 from
> > (select rownum rn, col1, col2, col3, col4 from mytable) a
> > where a.rn between 2 and 10;
> >
> > Substitute the proper columns from your source table (all of them)
for
> > the col1, col2, col3, col4 placeholders in BOTH queries.
> > David Fitzjarrell
>
> Surely this was a classroom assignment.
As David's reply gives a 'solution' that inserts indeterminate rows
into the new table yet demonstrates insert...select and subqueries I
rather like it. A smart student will read it and determine what he
needs to do, a not so smart student will copy and paste and then later,
assuming they have a competent instructor who marks it wrong, might not
be quite so willing to post homework without at least describing it so.
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
Received on Fri Jan 07 2005 - 07:05:35 CST
