发布时间:2013-08-20 11:24:39
Subquery FactoringThe WITH clause, or subquery factoring clause, is part of the SQL-99 standard and was added into the Oracle SQL syntax in Oracle 9.2. The WITH clause may be processed as an inline view or resolved as a temporary table. The advantage of the latter is that repeated referenc.........【阅读全文】
发布时间:2013-08-20 10:14:11
如何让别人,非DBA也可以kill session点击(此处)折叠或打开create or replace procedure kill_session( p_sid in number, p_serial# in number )asbegin for x in ( select * &n.........【阅读全文】
发布时间:2013-08-16 09:31:33
一、创建物化视图主要语法create materialized view [view_name] {TABLESPACE (表空间名)}--保存表空间 {BUILD [DEFERRED|IMMEDIATE(默认值)]} --延迟刷新.........【阅读全文】
发布时间:2013-08-16 09:27:18
点击(此处)折叠或打开create procedure refresh_mv ascursor c is select table_name from user_tables where table_name like '%MV%';beginfor i in c .........【阅读全文】