SQL Language (MOSC)

MOSC Banner

Issue With Subquery Inside Target Table Expression Column

As stated, I am getting warnings which turn into run failures due to subquery(s) inside expression column of target table. The decode query looks something like:

DECODE((SELECT alias.column FROM actualTable alias WHERE alias.differentColumn = actualTable.column),........

The warning I get from this looks like:

Unresolved Identifiers: alias.column, alias.differentColumn

This issue doesn't exist in the same mapping I have in 11g and my thoughts were to use a subquery filter but I'm not entirely sure how I would go about doing that. Any insight would be greatly appreciated.

Tagged:

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center