CREATETABLEtest_import ( src_noNUMBER(5), src_descVARCHAR2(20), load_dateDATE);CREATEORREPLACEPROCEDUREload_c2t_test IS c_stringVARCHAR2(250); cntBINARY_INTEGER; my_tabledbms_utility.uncl_array;BEGINFORt_recIN(SELECT*FROMc2t_test)LOOPdbms_utility.comma_to_table(t_rec.readline, cnt, my...
dbms_utilitycanonicalize(text) comma_to_table(text,int4,text[]) table_to_comma(text[],int4,text) db_version(text,text) exec_ddl_statement(text)utl_urlescape(text,bool,text) unescape(text,text)utl_encodebase64_encode(raw) base64_decode(raw) text_encode(text,text,int4) text_decode(text...
31.30.1. dbms_utility.get_hash_value 31.30.2. Use dbms_utility.name_resolve to find a package 31.30.3. Use dbms_utility.name_tokenize to split a name 31.30.4. Call dbms_utility.db_version to get the version and its compatible version 31.30.5. Use dbms_utility.comma_to_table, dbms_ut...
使用TRUNCATE TABLE DSC不会为动态PL/SQL语句添加模式名称。 CREATE OR REPLACE PROCEDURE schemName.sp_dd_table ( itablename VARCHAR2 ) IS l_table VARCHAR ( 255 ) ; BEGIN l_table :='truncatetable ' || itable_name ; --- dbms_utility.exec_ddl_statement(l_table); dbms_output.put_line...
dbms_utility.analyze_schema ( '&OWNER', 'ESTIMATE', NULL, 5 ); END ; / 8.2检查当前的范围。 SELECT e.owner, e.segment_type , e.segment_name , count(*) as nr_extents , s.max_extents , to_char ( sum ( e.bytes ) / ( 1024 * 1024 ) , '999,999.90') as MB ...
by no longer relying on the physical native id of the object (e.g. table) and instead rely on the name space (e.g. schema/table/column), therefore preventing invalid change detection when the database was re-created (backup/restore), or when pointing from development to production server...
The Oracle Database 11g Pre-Upgrade Information Utility (utlu112i.sql) estimates the additional space that is required in the SYSTEM tablespace and in any tablespaces associated with the components that are in the database (for example, SYSAUX, DRSYS). For a manual upgrade, be sure to run th...
Such elements include parameters, privileges, datatypes, Recovery Manager keywords, SQL keywords, SQL*Plus or utility commands, packages and methods, as well as system-supplied column names, database objects and structures, usernames, and roles. You can specify this clause only for a NUMBER ...
If the dump file set or master table for the job have been deleted, the attach operation will fail. Altering the master table in any way will lead to unpredictable results. Example(示例) The following is an Example(示例) of using theATTACHparameter. It assumes that the job,hr.export_job...
ExcelGen is a PL/SQL utility to create Excel files (.xlsx, .xlsb) out of SQL data sources (query strings or cursors), with automatic pagination over multiple sheets. It supports encryption, cell merging, various formatting options through a built-in API or CSS, table layout, formulas and ...