ODI Real time Scenario's and Interview Questions
Pages
Introduction
ODI Architecture
Data Warehouse Concepts
ODI 12c Material
ODI Interview Questions
SQL interview questions
Wednesday, March 14, 2018
How to populate/retrieve records oracle in customize order?
Scenario:
I have records in the following order:
I need to retrieve the records in the following order:
(i.e., Priority of retrieve records should be based on currency value - 1. USA , 2 . IND 3. SL 4. PAK and 5. BAG)
Query and Output:
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment