-
编辑 删除
init parameter
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
-
编辑 删除
export custom table data into any file on your operation system
/* 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,
-
编辑 删除
multiplication table output on sqlplus
[@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
