-
编辑 删除
Oracle取随机数函数
The basic function gets a random number, greater than or equal to 0 and less than 1, with 38 digits to the right of the decimal (38-digit precision).Alternatively, you can get a random Oracle number x, where x is greater than or equal to low and less than high.SELECT DBMS_RANDOM.VALUE,DBMS_RANDOM...
-
编辑 删除
DBMS_Utility学习
Comma_to_table 和 Table_to_Comma，比较有用。以下是例子：DECLARE v_len BINARY_INTEGER; v_tab DBMS_UTILITY.UNCL_ARRAY; v_idx BINARY_INTEGER; v_str VARCHAR2(200); BEGIN DBMS_UTILITY.COMMA_TO_TABLE ( 'a,b,c', --每个元素必须符合Ora...
-
编辑 删除
Export with Spool and Parallel Utl_File
Parallel Utl_File spool
-
编辑 删除
Multi-table insert using pipelined function
Thanks to Adrian Billington's work. This article is an extraction of:http://www.oracle-developer.net/display.php?id=429one source, two targetsConsider an example of loading customers and addresses...
