Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

evaluated order of Pivot and UnPivot in select statement

Aketi JyuuzouNov 26 2009 — edited Nov 30 2009
My research which evaluated order of select statement is below.
 1 from
 2 where (Join condition)
 3 start with
 4 connect by
 5 where (filter of rows)
 6 group by
 7 having
 8 model
 9 select
10 order by
My question is Where Pivot clause and UnPivot clause ?

http://download.oracle.com/docs/cd/E16338_01/server.112/e10592/statements_10002.htm
This post has been answered by Lakmal Rajapakse on Nov 26 2009
Jump to Answer

Comments

Hi,

What ODI version are you using ?

Adrian

Paula Istrate-Oracle

Hi,

I had similar problems myself with numeric variables values in ODI 11g because columns are set to have 10 digits.

See below workarounds, hope will help you:
- upgrading to ODI 12c where the precision of the columns has been increased to 19 digits
- use for the variable Text or Alphanumeric Types - not numeric.

Regards,

Paula

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 28 2009
Added on Nov 26 2009
5 comments
5,169 views