请问能在PL SQL中建立视图吗
DECLAREBEGIN
CREATE OR REPLACE VIEW view
AS SELECT
a.name,a.age,a.tel,
b.name1,b.age2,
c.name3,c.age3,
FROM a,b,c
WHERE a.id=b.id
AND a.dizhi=c.dizhi
END; CREATE DATABASE 数据库名
ON
（NAME=数据库名,
FILENAME=如'F:\SQL\ 数据库名.mdf',
SIZE= 1,
FILEGROETH=10%)
LOG ON
(NAME=数据库名_LOG,
FILENAME=如'F:\SQL\ 数据库名_LOG.Ldf',
SIZE=5,FILEGROWTH=10%)
注：数字和文件存储路径根据自己需要而定 declare
begin
execute immediate 'create or replace view test as select col1,col2 from temp';
end ;
页:
[1]