Differences

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

oracle:object_types_collections_to_json [October 12, 2017 4:14 am]
sqlines
oracle:object_types_collections_to_json [October 12, 2017 4:26 am] (current)
sqlines
Line 141: Line 141:
*/ */
</code> </code>
 +
 +===== Use SQLines Data to Migrate Object Types to JSON in Other Databases =====
 +
 +Now having the PL/SQL function that converts complex object types data to JSON, you can use SQLines Data tool to transfer it into any other database.
 +
 +You need to edit the //sqlines_tsel.txt// configuration file to specify the SELECT list expression for your table, for example:
 +
 +| SCOTT.AIR_STATS, ID, airport_list_to_json(data) AS data; |
 +
 +Now SQLines Data tool will apply //airport_list_to_json// PL/SQL function to transform object type values to JSON.
 +
 +