PL/SQL (MOSC)

MOSC Banner

Why does my ANSI SQL query work in 12C but not 19C for the exact same data?

in PL/SQL (MOSC) 3 commentsAnswered

Oracle Database 12C and 19

The following SQL query works in 12C but in our upgraded 19C database the query returns ambiguous results. Note, if I remove the joins to my two units look up tables the query works as expects but I can't see my unit names only the unit ids.

Note I'm using Oracle types as columns in the main tables that I'm interested in.

Can anyone see anything wrong with the formation of the query or explain possibly how this simple SQL query could work in 12C and not 19C.

BTW to the best of my knowledge, the new 19C database uses similar and conventional tuning.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center