Oracle OTBI - Logical Query Vs Physical Query - Database Lineage Details

[@kvsrallrounder1086]

Plz make more videos on this topic, here we can SQL query from OTBI, to generate BI report

[@jeeves251]

Great video. Can we use table aliases in logical SQL? I need to do a formula with a self join and can't get it working ugh

[@jennieroselarin2325]

Hi thank you for this video, it was a great help specially the database mapping, I just have a question on how can I differentiate which is which as I've encounter wherein it gives me the same DB object (GL_SEG_VAL_HIER_CF) and DB column (DEP0_PK1_VALUE) as reference in looking for presentation table for the company, location and account code ("- Balancing Segment"/"- Cost Center Segment"/"- Natural Account Segment"/Natural Account) or how can I have them appear as different columns containing their respective values. Thank you!

[@hasanmougharbel8030]

Hey there, god bless your efforts in this channel. As a newbie sql learner i have general enquiry. What is the major difference between Oracle database and mysql database. Is there any advantages i need to consider before choosing to work on one of them. Thanks for taking care of this.

[@kvsrallrounder1086]

I am learning HCM