ITPub博客

see below[@more@]declare /* relies on... create table t ( text varchar2(3) ) */type words_t is table of varchar2(10);words words_t :=words_t ( 'dog', 'fish', 'cat', 'ball', 'bat', 'spoke', 'pad' )/* 'ball' and 'spoke' will raise ORA-01401 */;n integer := 0;type error_indexes_t is table of integer index by binary_integer;error_indexes error_indexes_t;type error_codes_t is table of varchar2(255) index by binary_integer;error_codes error_codes_t;type error_context_t is table of varchar2(255) index

init parameter [@more@]The O7_DICTIONARY_ACCESSIBILITY initialization parameter controls restrictions on system privileges when you upgrade from Oracle7 to Oracle8i and higher releases. If the parameter is set to TRUE, access to objects in the SYS schema is allowed (Oracle7 behavior). If this parameter is set to FALSE, system privileges that allow access to objects in "any schema" do not allow access to objects in SYS schema. The default for O7_DICTIONARY_ACCESSIBILITY is FALSE. When t

/* check input datatpye*/ CREATE OR REPLACE FUNCTION ifnum(P_NUM IN VARCHAR2) RETURN VARCHAR2 AS V_TMP NUMBER; BEGIN IF P_NUM IS NULL THEN RETURN NULL; END IF; V_TMP := TO_NUMBER(P_NUM); RETURN 'T'; EXCEPTION WHEN OTHERS THEN RETURN 'N'; END;/**************************************************//* setting your utl_file_dir /alter system set utl_file_dir='/your DIR' scope=spfile; create or replace function output_data( p_query in varchar2,

[@more@]declarea integer := 1;b integer := 1;c integer := 0;string varchar(1000) := null ;string1 varchar(1000) := null ;beginfor a in 1..9 loopfor b in 1..9 loopif b <= a thenc := a * b;string := to_char( b ||'*'|| a|| '='||c ||' ');select concat(string1,string) into string1 from dual ;end if; end loop; dbms_output.put_line( string1 );string := null; string1 := null;end loop; end;**************************************************create table LRH_CONBY( EMPLOYEES_ID VARCHAR2(4), EMPLOYEES