Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: question on delete statement
Anurag Varma wrote:
> "Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message
> news:3EF37CE6.1E82AEB9_at_exxesolutions.com...
> > Anurag Varma wrote:
> >
> > > "Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message
> > > news:3EF36687.48564458_at_exxesolutions.com...
> > > --snip--
> > > >
> > > > Look at the standard syntax for updating tables with nested tables and
> > > objects.
> > > > Update and Delete against a SELECT is the norm.
> > > >
> > > > --
> > > > 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)
> > >
> > > Daniel,
> > >
> > > I know deletes based on nested selects are a norm.
> > > This thread is referring to the join based delete/update syntax.
> > >
> > > Tell me .. is this a valid syntax according to you:
> > >
> > > update (select lprice, price
> > > from localtab, maintab
> > > where maintab.item = localtab.item)
> > > set lprice = price
> > > /
> > >
> > > maintab = (item, price) with PK on item
> > > and
> > > localtab = (item, lprice)
> > >
> > > Now I know this can be written as (and this is the norm):
> > > update localtab set lprice = (select price from maintab
> > > where maintab.item =
> > > localtab.item)
> > > /
> > >
> > > Anurag
> >
> > By norm do you mean what most developers do or valid syntax. I don't think
> > most developers perform bulk binding
> > but I would certainly consider it the norm in the work that my teams do.
> >
> > --
> > 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)
> >
> >
>
>
>
I'd love to humor you but I won't ... I was reacting to:
"maintab = (item, price) with PK on item
> and
> localtab = (item, lprice)"
and if you can get that to work ... go for it.
-- 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 Jun 20 2003 - 17:07:53 CDT