schema的常用脚本:getaview.sql
添加时间: 2008-4-24 20:26:15 作者: Oracle指导 阅读次数:8 来源: http://www.d9soft.com
getaview.sql --获得某个视图脚本
set heading off
set feedback off
set linesize 1000
set trimspool on
set verify off
set termout off
set embedded on
set long 50000
column column_name format a1000
column text format a1000
spool &1..sql
prompt create or replace view &1 (
select decode(column_id,1,'',',') || column_name column_name
from user_tab_columns
where table_name = upper('&1')
order by column_id
/
prompt ) as
select text
from user_views
where view_name = upper('&1')
/
prompt /
spool off
set heading on
set feedback on
set verify on
set termout on
上下文章:
上一篇文章: Oracle中如何去定位未知的对象 下一篇文章: Oracle数据操作和控制语言详解