ITPub博客

1 语法 　　在Oracle中，可以创建以下两种临时表： 　　1) 会话特有的临时表 　　CREATE GLOBAL TEMPORARY ( ) 　　ON COMMIT PRESERVE ROWS； 　　2) 事务特有的临时表 　　CREATE GLOBAL TEMPORARY ( ) 　　ON COM...

create or replace type t_ret_table is table of varchar2(20);create or replace function f_test(var_num in integer) return t_ret_table isvar_out t_ret_table;beginvar_out := t_ret_table();var_out.extend(...

REGR_ (Linear Regression) Functions 功能描述：这些线性回归函数适合最小二乘法回归线，有9个不同的回归函数可使用。 REGR_SLOPE：返回斜率，等于COVAR_POP(expr1, expr2) / VAR_POP(expr2) REG...

create or replace package my_output as procedure put( s in varchar2 ); procedure put_line( s in varchar2 ); procedure new_line; function get_line( n in number ) return varchar2; ...

oracle 中好像没有提供参数化的视图功能。不过，可以用以下方法变通：create or replace package pkg_pv isprocedure set_pv(pv varchar2);function get_pv return varchar2;end;/create or replace package body pk...

--本文档可以直接拷贝运行。/*oracle复合数据类型PL/SQL有两种复合数据结构：记录和集合。记录由不同的域组成，集合由不同的元素组成。*//*一、记录类型类似C语言中的结构，有两种定义方式：显式定义和隐式定义。*/c...

DBMS_PROFILERThe DBMS_PROFILER package was introduced in Oracle8i to allow developers to profile the run-time behaviour of PL/SQL code, making it easier to identify performance bottlenecks which can t...

在网站应用的开发中，一个较流行的方法便是使用 php 编程，php编程方法简单明了，直接在html 中嵌入php 代码，对于开发基于数据库的动态应用十分方便。但是，许多开发员在用php开发基于Oracle 数据库的应用时，仍沿...

同事的分区表总结，转载一下。1.1 分区表PARTITION table在ORACLE里如果遇到特别大的表，可以使用分区的表来改变其应用程序的性能。1.1.1 分区表的建立： 某公司的每年产生巨大的销售记录，DBA向公司建议每季度的数...

树形查询create table test(bm number(8),bmmc varchar2(20),sjbm number(8));insert into test values(1,'aaa',0);insert into test values(11,'aaa1',1);insert into test values(12,'aaa2',1);insert into test v...

Finally, the next example adds a START WITH clause to specify a root row for the hierarchy, and an ORDER BY clause using the SIBLINGS keyword to preserve ordering within the hierarchy:SELECT last_name...

Using Oracle's Parallel Execution Features [@more@] Parallel Features The full list of Oracle parallel execution features currently includes the following Parallel Query Parallel DML Parallel DDL Parallel Data Loading Parallel Recovery Parallel Replication How Parallel Execution Works Operations That Can Be Parallelized Oracle can parallelize operations that involve processing an entire table or an entire partition. These operations include: SQL queries requiring at least one full table sca

create or replace function encrypt_data(p_text varchar2, p_key varchar2) return varchar2 isv_text varchar2(4000);v_enc varchar2(4000);beginif p_text is null thenreturn null;elsev_text := rpad(p_text, ...

GeneralTable Related Data Dictionary Objectstab$col$DBAALLUSERdba_col_commentsall_col_commentsuser_col_commentsdba_external_tablesall_external_tablesuser_external_tablesdba_external_locationsall_exter...

select SYS_CONTEXT('USERENV','TERMINAL') terminal,SYS_CONTEXT('USERENV','LANGUAGE') language,SYS_CONTEXT('USERENV','SESSIONID') sessionid,SYS_CONTEXT('USERENV','INSTANCE') instance,SYS_CONTEXT('USEREN...

ops$tkyte@DEV816> variable x varchar2(25)ops$tkyte@DEV816> ops$tkyte@DEV816> exec :x := 'How Now Brown Cow';PL/SQL procedure successfully completed.ops$tkyte@DEV816> ops$tkyte@DEV816> declare2 l_data ...

In Oracle Database 10g, PL/SQL now offers two new clauses in the FORALL statement, INDICES OF and VALUES OF, which allow you to choose very selectively which rows from the driving array should be proc...

AUTONOMOUS TRANSACTION(自治事务)的介绍 在基于低版本的ORACLE做一些项目的过程中,有时会遇到一些头疼的问题.,比如想在执行当前一个由多个DML组成的transaction(事务)时,为每一步DML记录一些信息到跟踪表中,由于事...

在ultraedit安装目录下找到wordfile.txt，在后边追加以下文本。/L10"PL/SQL" Nocase Line Comment = -- Block Comment On = /* Block Comment Off = */ File Extensions = SQL/Delimiters = ...

technically, under the covers, at the most "basic level", they are the same.A "normal" plsql cursor is static in defintion.Ref cursors may be dynamically opened or opened based on logic.Declare type...