Interesting procedure which can expand your query to a more complicated structure but closer to the CBO’s one, unfortunately not the same:)
Continue reading “Expand SQL queries using dbms_utility.expand_sql_text”
Today I’ll show you a small simple function to convert values from LONG to CLOB in SQL queries.
I’ve seen many articles where authors create their convert fuctions or create a table and insert the LONG value via INSERT INTO SELECT statement.
Oracle has also made its own, so we don’t need to create our own:)
Continue reading “Convert values from LONG to CLOB using dbms_metadata_util.long2clob in SQL queries”
After migration from 22.214.171.124. to 126.96.36.199 I discovered an interesting thing. I’ve read a lot about the new features and I was particularly interested in the Scalar Subquery Unnesting transformation. After a few tests, however, I found something that I hadn’t really expected 🙂
Continue reading “Oracle 12c: Scalar Subquery Unnesting and ROWNUM”