Re: question on delete statement

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)