Yet another newbie question

#1

Hi all,
I'm using a standard SQL command but Oracle seems to have a different
version.

update A,B
set a.col1 = 'something'
where a.col2>=b.col2 and a.col3<=b.col3

Why doesn't this seem to work?

Thanks,
Sashi

#2

"Sashi" <smalladi (AT) gmail (DOT) com> a écrit dans le message de news: f4b15387-b8cc-4ce9-a9d2-fb8d74d88e1f...oglegroups.com...

Quote:

Hi all,
I'm using a standard SQL command but Oracle seems to have a different
version.

update A,B
set a.col1 = 'something'
where a.col2>=b.col2 and a.col3<=b.col3

Why doesn't this seem to work?

Thanks,
Sashi

Because it is not in the Oracle SQL syntax.
http://download.oracle.com/docs/cd/B...7.htm#i2067715

Regards
Michel

#3

On Sep 2, 10:40*am, Sashi <small... (AT) gmail (DOT) com> wrote:

Quote:

Hi all,
I'm using a standard SQL command but Oracle seems to have a different
version.

update A,B
set a.col1 = 'something'
where a.col2>=b.col2 and a.col3<=b.col3

Why doesn't this seem to work?

Thanks,
Sashi

Actually, that doesn't look like standard SQL to me. The standard says

UPDATE table name ...
where table name can be a base table or a view.

So I assume you learned "standard SQL" on some other DBMS that
extended the standard a little. So as Michel mentioned, look up the
Oracle syntax. It actually more closely follows the SQL Standard.

Ed

#4

Thanks for the pointers, guys.

This is what I've come up with:

update A
set a.col1 = 'something'
where exists
(select 1
from B
where a.col2>=b.col2 and a.col3<=b.col3 )

Is my syntax correct for what I'm aiming to do?
As for what I'm aiming to do, I hope it's clear.

I have two tables, A and B and a column in A needs to be updated to
true if two columns in A (source and destination) fall in a range,
given that all ranges are in table B as two columns (start and end).

And the syntax I quoted is from Sybase, which is where I acquired it.

Thanks,
Sashi

#5

On Sep 3, 11:19*am, Sashi <small... (AT) gmail (DOT) com> wrote:

Quote:

Thanks for the pointers, guys.

This is what I've come up with:

update A
set a.col1 = 'something'
where exists
(select 1
from B
where a.col2>=b.col2 and a.col3<=b.col3 )

Is my syntax correct for what I'm aiming to do?

Looks like it. For syntax, it us usually quicker to try it.

Quote:

As for what I'm aiming to do, I hope it's clear.

I have two tables, A and B and a column in A needs to be updated to
true if two columns in A (source and destination) fall in a range,
given that all ranges are in table B as two columns (start and end).

Seems reasonable.

Quote:

And the syntax I quoted is from Sybase, which is where I acquired it.

Hence my comment about SQL extension (ie, non-standard) syntax. Don't
blame Oracle for not following Sybase extensions by saying Oracle is
not following the standard SQL syntax.

Quote:

Thanks,
Sashi

You are welcome. I hope that helped.
Ed

#6

"Ed Prochak" <edprochak (AT) gmail (DOT) com> wrote

On Sep 3, 11:19 am, Sashi <small... (AT) gmail (DOT) com> wrote:

Quote:

Thanks for the pointers, guys.

This is what I've come up with:

update A
set a.col1 = 'something'
where exists
(select 1
from B
where a.col2>=b.col2 and a.col3<=b.col3 )

Is my syntax correct for what I'm aiming to do?

Looks like it. For syntax, it us usually quicker to try it.

Quote:

As for what I'm aiming to do, I hope it's clear.

I have two tables, A and B and a column in A needs to be updated to
true if two columns in A (source and destination) fall in a range,
given that all ranges are in table B as two columns (start and end).

Seems reasonable.

Quote:

And the syntax I quoted is from Sybase, which is where I acquired it.

Hence my comment about SQL extension (ie, non-standard) syntax. Don't
blame Oracle for not following Sybase extensions by saying Oracle is
not following the standard SQL syntax.

Quote:

Thanks,
Sashi

You are welcome. I hope that helped.
Ed

===============

That is standard Ansi syntax. Nothing Sybase specific. Just took Oracle a
while to adopt Ansi standards.

--
Terry Dykstra

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Yet another newbie question

comp.databases.oracle.misc comp.databases.oracle.misc

Yet another newbie question - 09-02-2009 , 09:40 AM

Re: Yet another newbie question - 09-02-2009 , 10:17 AM

Re: Yet another newbie question - 09-02-2009 , 11:02 AM

Re: Yet another newbie question - 09-03-2009 , 10:19 AM

Re: Yet another newbie question - 09-03-2009 , 01:35 PM

Re: Yet another newbie question - 09-03-2009 , 02:06 PM