Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: simple sql

Re: simple sql

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Fri, 25 Jul 2003 10:51:54 -0700
Message-ID: <3F216E3A.89F41256@exxesolutions.com>


Carlos wrote:

> "SPIDERMAN" <consultant2b_at_hotmail.com> wrote in message news:<_YUTa.71483$R92.17537_at_news2.central.cox.net>...
> > Could someone help me with writing a query that would accomplish the
> > following. Thank you.
> >
> >
> > PAY_TABLE: EMP_ID, DEPT_ID, COMMISSION
> >
> >
> >
> >
> >
> >
> >
> > Inserting into PAY_TABLE a new employee 10 who works for department 20 and
> > earns a
> >
> > commission that is equal to the commission earned by employee 3
>
> INSERT INTO PAY_TABLE ( EMP_ID, DEPT_ID, COMMISSION ) SELECT 10, 20
> b.COMMISSION FROM PAY_TABLE b WHERE b.EMP_ID = 3;
>
> Greetings, and don't ever forget Gwen Stacy.

As an instructor I would like to request that when students ask questions you provide hints ... not answers.

Thank you.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Fri Jul 25 2003 - 12:51:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US