Tip Details Add a Related Tip
Rate as: Positive Negative

Oracle decode error

I've been trying to get a really ugly Oracle DECODE statement to work and I keep getting an error: 

ORA-00939: too many arguments for function

Finally figured out that Oracle limits the DECODE statement to 255 arguments and this includes all of the arguments -- the expression, search, and result arguments.
Rating: no ratings, 0 total Votes
Categories: Oracle databases errors
Added: on Dec 01, 2008 at 10:08 am
Added By: an anonymous user
Searches: oracle error decode database argument

Comments on this Tip

Add a Comment
There are no comments for this tip
Your Comment:
(how to format)
Rate This Tip:

Verify Humanity:
Sorry, we know it's annoying, but please enter the characters shown in the image to the left so that we know you're an actual person and not an evil spammer. Thanks.
       

Related Tips

MySQL Decode Equivalent

Categories: MySQL Oracle databases
100% positive, 0 comments
– Tip added by an anonymous user on Jul 10, 2008 at 5:00 pm

pairing record error on iPhone and iPod Touch

Categories: iPhone iPod Touch errors
53% positive, 3 comments - last added on Jan 18, 2009 at 4:15 am
– Tip added by songbird on Jan 24, 2008 at 8:04 am

Wii error codes 32002 and 52030

100% positive, 3 comments - last added on Dec 27, 2008 at 9:55 pm
– Tip added by an anonymous user on Jan 18, 2008 at 8:14 am

Finding slow MySQL queries

100% positive, 0 comments
– Tip added by dbdude on Jun 24, 2008 at 9:22 pm

Keep Parallels from hanging

Categories: Mac parallels crash errors
100% positive, 1 comment - last added on Jun 01, 2009 at 11:07 am
– Tip added by an anonymous user on Aug 26, 2008 at 2:08 pm

Javascript Error: unterminated regular expression literal

50% positive, 0 comments
– Tip added by marty on Jun 26, 2008 at 1:20 pm

Speed up iPhoto load time

Categories: iPhoto speed databases
50% positive, 0 comments
– Tip added by an anonymous user on Mar 02, 2009 at 4:03 pm

Optimize your MySQL database

100% positive, 0 comments
– Tip added by an anonymous user on Dec 07, 2008 at 5:04 pm
Link: wiki.mysqltuner.com

Errors playing audio books on iphone and ipod touch

100% positive, 0 comments
– Tip added by an anonymous user on Nov 11, 2008 at 7:36 am

Minimize round trips to the server for best performance

100% positive, 0 comments
– Tip added by an anonymous user on Jun 18, 2008 at 4:07 pm
Link: www.sql-server-pro.com

Importing databases in MS SQL

100% positive, 0 comments
– Tip added by an anonymous user on May 29, 2008 at 2:47 pm

BOOTMGR is missing

Categories: Windows Vista errors repair
100% positive, 2 comments - last added on Mar 12, 2008 at 1:16 am
– Tip added by an anonymous user on Feb 12, 2008 at 11:38 am

MySQL equivalent to Oracle NVL

Categories: MySQL Oracle database
no ratings, 0 comments
– Tip added by an anonymous user on Jul 31, 2009 at 4:01 pm

Time Machine backup errors

no ratings, 0 comments
– Tip added by an anonymous user on Feb 16, 2009 at 12:13 pm
Link: carnationsoftware.com

Backup the registry of your computer.

no ratings, 0 comments
– Tip added by an anonymous user on Jan 05, 2009 at 1:48 pm
Link: the-registry-repair-software-review.com

Missing DLL files

Categories: Windows DLL repair errors
no ratings, 0 comments
– Tip added by an anonymous user on Dec 31, 2008 at 4:38 pm
Link: www.dll-files.com

Optimizing your MySQL tables

no ratings, 0 comments
– Tip added by an anonymous user on Oct 21, 2008 at 11:18 am

Disable the SQL Server splash screen

no ratings, 0 comments
– Tip added by an anonymous user on Oct 14, 2008 at 8:23 am

iChat camera in use error

no ratings, 0 comments
– Tip added by an anonymous user on Aug 11, 2008 at 8:23 pm

Running X11 programs from the terminal

no ratings, 0 comments
– Tip added by an anonymous user on Jan 28, 2008 at 8:04 am

Related Categories