PL/SQL (MOSC)

MOSC Banner

union all and order by together

edited Aug 17, 2015 11:27AM in PL/SQL (MOSC) 2 commentsAnswered ✓

Hi

Im trying to use union all and order by in below sql query .Do help out

select vendor_id

     || '|'|| set_of_books_id

     ||'|'|| TO_CHAR (last_update_date, 'DY MON DD HH24:MI:SS YYYY')

      from ap_invoices_all

     where vendor_id like '%1234%'

union all

select vendor_id

     || '|'|| set_of_books_id

     ||'|'|| TO_CHAR (last_update_date, 'DY MON DD HH24:MI:SS YYYY')

      from ap_invoices_all

     where vendor_id like '%134%'

order by last_update_date;

Im getting ORA-00904: "LAST_UPDATE_DATE": invalid identifier

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center