奥我市说我在sqlserver中定义了了一个view CREATE view aaa as (select a.ID,b.Mny,b.VDate from aaa a inner join bbb b on a.VID = b.VID)然后我在oracle中 CREATE VIEW aaa as SELECT a.ID,b.Mny,b.VDate FROM aaa a, bbb b WHERE a.VID = b.VID他怎么就不行呢?
create or replace VIEW aaa as SELECT a.ID,b.Mny,b.VDate FROM aaa a, bbb b WHERE a.VID = b.VID
--create table a(id int); --create table b(id int);create view ppp as select x.id from a x,b y where x.id=y.id;没问题啊 你的错误报告是啥啊?
BEGIN EXECUTE IMMEDIATE 'DROP view VW_VoucherView'; EXCEPTION WHEN OTHERS THEN NULL; END; CREATE VIEW aaa as SELECT a.ID,b.Mny,b.VDate FROM aaa a, bbb b WHERE a.VID = b.VID /这就是整个过程。。 错误报在"CREATE "
这样吧 你单独打开一个环境 运行 CREATE VIEW aaa as SELECT a.ID,b.Mny,b.VDate FROM aaa a, bbb b WHERE a.VID = b.VID; 把错误信息贴出来
做存储过程转换 过程区别是不小 oracle不能自动返回结果集 得用游标变量。
视图没啥区别啊
CREATE view aaa as
(select a.ID,b.Mny,b.VDate from aaa a
inner join bbb b
on a.VID = b.VID)然后我在oracle中
CREATE VIEW aaa
as
SELECT a.ID,b.Mny,b.VDate FROM aaa a,
bbb b
WHERE a.VID = b.VID他怎么就不行呢?
as
SELECT a.ID,b.Mny,b.VDate FROM aaa a,
bbb b
WHERE a.VID = b.VID
--create table b(id int);create view ppp
as
select x.id from a x,b y where x.id=y.id;没问题啊 你的错误报告是啥啊?
EXECUTE IMMEDIATE 'DROP view VW_VoucherView';
EXCEPTION WHEN OTHERS THEN NULL;
END;
CREATE VIEW aaa
as
SELECT a.ID,b.Mny,b.VDate FROM aaa a,
bbb b
WHERE a.VID = b.VID /这就是整个过程。。
错误报在"CREATE "
你单独打开一个环境
运行
CREATE VIEW aaa
as
SELECT a.ID,b.Mny,b.VDate FROM aaa a,
bbb b
WHERE a.VID = b.VID;
把错误信息贴出来