Skip to Main Content
Forums

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!

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

karianna

I've pinged Geertjan who's the Netbeans product lead, hopefully he'll jump on here an answer your Q soon.

karianna

Geertjan has said to email him directly: geertjan DOT wielenga AT oracle DOT com

1 person found this helpful
user4931850

Thank you, I have emailed Geertjan

Geertjan-Oracle

Thanks. Trying to find out where that NBM file is, sent you a mail in response. It is conceivable that NetBeans IDE 8.1 doesn't support that version anymore.

user4931850

This old plugin does work with NetBeans 8.1. My previous laptop has still got Netbeans 8.1 working with this plugin. I want to download the .nbm file again to install it on a new laptop.

Answer

You might try downloading the plugin here:

http://updates.netbeans.org/netbeans/updates/7.0/uc/final/certified/modules/extra/org-netbeans-modules-j2ee-sun-appsrv81…

It installs and works fine in NetBeans IDE 8.1.

Hope this helps,

--

Jiří Kovalský

NetBeans Community Manager

http://netbeans.org

Marked as Answer by user4931850 · Sep 27 2020
1 person found this helpful
user4931850

Thank you

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

Post Details

Locked on Aug 24 2009
Added on Jul 27 2009
#function, #pivot
3 comments
1,918 views