Extract Data and Display in a Vertical Format Excluding Null Columns, Show Leading / Trailing Spaces SUPP_QUERY
(Doc ID 562742.1)
Last updated on OCTOBER 24, 2019
Applies to:Oracle Order Management - Version 11.0 to 12.0.5 [Release 11 to 12.0]
Information in this document applies to any platform.
*** Checked for relevance on 05-Jan-2015 ***
The script's primary function is to extract data from single tables and display in a user friendly / readable format. It is particularly useful for viewing data on tables with a large number of columns. The script can also be used to identify fields containing leading and / or trailing spaces.
The script can be downloaded from SUPP_QUERY
This script can be used by anybody that wishes to extract data from APPs databases.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document