This is a question that querying me for a while. I use SQL Developer on a duplicated testing database, then update the query to a backend application that connects to the realtime database.Notice that tables with XML columns only works in backend application but outputing empty result in SQL developer.

I have tried Tools – Preferences – Database -Advanced – Display XML Value In Grid, but it doesn’t help.

Even though I query a non-XML column in those tables, I still get empty result.

Also notice SQL developer can display binary columns, but that application can’t and needs conversion first.

I can use backend application to test those XML tables and that’s fine, but now there is a chanllege to import those tables into Power BI,where also showing empty result.

I was wondering if I can do something in SQL script to make those tables visible.