OracleDB compability issue - %sqlplot histogram

[tonykploomber]

Found the issue while introducing oracle integration testing

When we trying to execute following command: %sqlplot histogram

We will see the error:

DatabaseError: (oracledb.exceptions.DatabaseError) ORA-00942: table or view does not exist
[SQL: WITH plot_something_subset AS (SELECT * FROM plot_something_fcf825 FETCH FIRST 3 ROWS ONLY) SELECT MIN("x"), MAX("x") FROM "plot_something_subset"]
(Background on this error at: https://sqlalche.me/e/20/4xp6)

However, I am able to execute the simple query command %sql SELECT * FROM plot_something_fcf825

Need to check the part in our internal CTE of histogram

[edublancas]

this error is weird, we often get syntax errors but this is saying the table doesn't exist. let's find out the root cause, and decide if we want to fix it or not depending on how much an effort this will imply