VIEW: APPS.PAYLV_US_STATE

Source

View Text - Preformatted

SELECT STATE_CODE, STATE_ABBREV, STATE_NAME, STATE_NAME ORDER_BY FROM pay_us_states UNION ALL SELECT null, null, null, ' ' order_by FROM dual

View Text - HTML Formatted

SELECT STATE_CODE
, STATE_ABBREV
, STATE_NAME
, STATE_NAME ORDER_BY
FROM PAY_US_STATES UNION ALL SELECT NULL
, NULL
, NULL
, ' ' ORDER_BY
FROM DUAL