Read a table in different sequences
Hi,
I have a table with 3 columns A B C
I would like to access the table via column A in ascending sequence.
Then access the table via Column B and A both in descending sequence.
Then access C and A with C in descending and A in ascending sequences
If possible I would like to have these 'views' updated dynamically as data is added to the table.
Thanks,
Mike
Subject
Written By
Posted
Read a table in different sequences
March 10, 2020 03:33AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.