Skip to Main Content

SQL & PL/SQL

Pivot function and Missing expression error

Parth DivekarJul 27 2009 — edited Jul 27 2009
select * from (
select T.PAT_MRN_ID, T.ABBREVIATION,CONCEPT_VALUE from TBL_WORKLFOw T
)
pivot
(
max(concept_value)
for ABBREVIATION in (select ABBREVIATION from TBL_WORKLFOW )
)

this query is throwing "missing expression"..error.

Can some one help figuring out the problem.
This post has been answered by Frank Kulash on Jul 27 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 24 2009
Added on Jul 27 2009
3 comments
1,752 views