SQL - 🌟
Oracle - ⭕️
Databases - ⛁
Product Manager - 🙊
World Traveler - 🧳
But how do you check a view has the joins you want?
Get the full underlying query in Oracle Database with
dbms_utility.expand_sql_text ( 'SELECT * FROM view', output_sql_text => :clob_var )
print :clob_var
@sqlmaria.com demos
Thanks to @sqlmaria.com for helping me write this post :)
Thanks to @sqlmaria.com for helping me write this post :)