Differences

This shows you the differences between two versions of the page.

--- sqlways:command-line:sqlways-ini:oracle-section [July 24, 2018, 12:28:18 PM] – alexandr.kirpichny
+++ sqlways:command-line:sqlways-ini:oracle-section [May 31, 2023, 05:28:08 PM] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 \\
-[[http://www.ispirer.com|Ispirer Home Page]]
+[[https://www.ispirer.com|Ispirer Website]]
-[[http://www.ispirer.com/products|Ispirer SQLWays Product Page]]
+[[https://www.ispirer.com/products/oracle-migration|Ispirer Capabilities - Oracle Migration]]
-[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]]
+[[https://www.ispirer.com/download/download-demo|Free Trial]]
 ====== Sqlways.ini File - Section [ORACLE] ======
@@ Line 55: / Line 53: @@
 | **PREFETCH_SIZE** | This option identifies the number of rows you want to read from the datafile before a data save for Direct path loads. The default is to read all the rows and save data at the end of the load. |
 | **CONVERT_LONG_RAW_TO_BLOB** | This option controls whether to convert LONG RAW data type to BLOB. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "Yes". |
+| **SP_RESULTSET_AS_OUT_REFCURSOR** | This option specifies how the result sets should be returned from procedure. If "No" specified, the SYS_REFCURSOR variables will be declared, if "Yes" - the OUT SYS_REFCURSOR parameters will be add for procedure. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No". |
+| **CONCAT_NULL_STRINGS_AS_NULL** | By default, Ispirer Toolkit converts string concatenation as is. But in order to reproduce the same behavior in the case of null strings in Oracle and PostgreSQL, we can add a check for the presence of nulls among the concatinating strings. And if there are null values, the resulting string becomes null. \\ Possible values - "Yes", "No" and Empty. \\ Default value - Empty. |
@@ Line 63: / Line 63: @@
   convert_clustered_index_to=IOT
-\\
-[[http://www.ispirer.com|Ispirer Home Page]]
-[[http://www.ispirer.com/products|Ispirer SQLWays Product Page]]
-[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]]