Here is a link to the reading plans talk I did with Chris Saxon of Ask Tom Office hours last week.
https://www.youtube.com/watch?v=WaqdsaepmY8
If nothing else this might be good to help you get to sleep. 😴
Enjoy!
Here is a link to the reading plans talk I did with Chris Saxon of Ask Tom Office hours last week.
https://www.youtube.com/watch?v=WaqdsaepmY8
If nothing else this might be good to help you get to sleep. 😴
Enjoy!
A rather huge problem in debugging queries over the years
was the dreaded “ambiguous column” error.
It wasn’t something I ran into a lot, but when I did it always seemed to
come up in rather large queries and was unbelievably hard to figure out which
column.
Now in 23ai we finally have an error message that at least
gives a clue:
ORA-00918: CREATED: column ambiguously specified - appears
in RVD_SCALAR_ALLUSERS and RVD_SCALAR_ALLOBJECTS
Apparently other error messages have also been enhanced to
be more helpful as well. I’ve personally
not bumped into any of them just yet, but this is great news.
Well that only took about 100 years. 😏
I’ll be discussing how to read plans in Oracle on the 15th of July 2025. Join in for a fun filled discussion about this fundamental skill for Oracle Professionals. Register Here!
See you there!
Full link here in case the hyperlink doesn't work:
https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=67493840316866131103361221956880470211&p2_join_yn=&p2_prev_page=3&clear=2&session=514799324044833&cs=1M0-Xs3clx05hEC13jfdZAc-IBLW2WgJOIo8pioS6UbbAeWfNGa8KHThFPZAAXcUaM43RD9P0FkA0JtpDexy-GA