怎样实现。。。。功能 (100分)

dxd0222 · 2002-12-19

在sql plus中（pl/sql）怎样访问ODBC连接？？？？？？？？？？

在oracle中实现sql server的类似功能：
UPDATE titles
SET price = price * 2
FROM titles INNER JOIN publishers ON titles.pub_id = publishers.pub_id
AND pub_name = 'New Moon Books'

tab1:
1 a
1 b
2 c
3 d

tab2:
1 aa
2 bb
3 cc

我想update语句实现修改tab1为下面的结果：
tab1:
1 aa
1 aa
2 bb
3 cc

请大虾帮忙

xianjun · 2002-12-19

可以这样：
UPDATE titles
SET price = price * 2
FROM titles where titles.pub_id in (select publishers.pub_id
from publishers where pub_name = 'New Moon Books')
或者
UPDATE titles
SET price = price * 2
FROM titles where exists (select 'x'
from publishers where pub_id = titles.pub_id and pub_name = 'New Moon Books')

ugvanxk · 2002-12-19

UPDATE titles
SET price = price * 2
FROM titles INNER JOIN (select pub_id from publishers where pub_name = 'New Moon Books') publishers ON titles.pub_id = publishers.pub_id

dxd0222 · 2002-12-19

tab1:
1 a
1 b
2 c
3 d

tab2:
1 aa
2 bb
3 cc

我想update语句实现修改tab1为下面的结果：
tab1:
1 aa
1 aa
2 bb
3 cc

请大虾帮忙

jsxjd · 2002-12-19

UPDATE titles
SET pub_name= publishers.pub_name
FROM titles,publishers
where publishers.pub_id = pub_name.pub_id

dxd0222 · 2002-12-19

FROM titles,publishers
*
ERROR 位于第 3 行:
ORA-00933: SQL 命令未正确结束

fireworld · 2002-12-19

UPDATE titles
SET pub_name= select publishers.pub_name
FROM titles,publishers
where publishers.pub_id = pub_name.pub_id

xianjun · 2002-12-19

update tab1
set name = (select name from tab2 where tab2.id = tab1.id)

dxd0222 · 2002-12-20

在sql plus中（pl/sql）怎样访问ODBC连接？？？？？？？？？？

xianjun · 2002-12-20

应该只能通过用C或Java写DLL，DLL访问ODBC连接，再DLL给PL/SQL调用了吧

怎样实现。。。。功能 (100分)

dxd0222

Unregistered / Unconfirmed

xianjun

Unregistered / Unconfirmed

ugvanxk

Unregistered / Unconfirmed

dxd0222

Unregistered / Unconfirmed

jsxjd

Unregistered / Unconfirmed

dxd0222

Unregistered / Unconfirmed

fireworld

Unregistered / Unconfirmed

xianjun

Unregistered / Unconfirmed

dxd0222

Unregistered / Unconfirmed

xianjun

Unregistered / Unconfirmed

Similar threads