I am looking for following query in Oracle
I have a table Tbl1
I need fetch all the data from Tbl1
But where Tbl1.Fld1 = Tbl2.Name return Tbl2.UID as Tbl2UID
where Tbl1.Fld2 = Tbl3.Name return Tbl3.UID as Tbl3UID
.. a fewmore till Tbl1.Fld10 = Tbl10.Name return Tbl10.UID as Tbl10UID
I may be able to write it with Case statement . But is there a more compact way of doing it?
Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.