ODI Real time Scenario's and Interview Questions
Pages
(Move to ...)
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
‹
›
Home
View web version
No comments:
Post a Comment