Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Nested Decode NOT NULL

Status
Not open for further replies.
nareval

nareval

Programmer
Jul 12, 2000
1
0
0
US
Is it possible to use NOT NULL in a nested decode?<br>This is what I'm trying to do:<br>decode(field,NOT NULL, field value,decode(next field, NOT NULL, next field value, 'No Value Found'))<br><br>If not, how can I rewrite this to work?
 
Sort by date Sort by votes
If you use NOT NULL, it gets flagged as ORA-396: Missing Expression.<br>In order to accomplish what you want, you have to invert the test:<br><br>decode(field,NULL,decode(next_field,NULL,'No Value Found',next_field),field)<br><br>Rather cumbersome, but it works.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

soushi01
  • Locked
  • Question
Nested For Loop update statement (pl/sql) 1
Replies
2
Views
69
soushi01
soushi01
Davest11
  • Locked
  • Question
Table or View does not exist
Replies
11
Views
104
PHV
PHV
soushi01
  • Locked
  • Question
Nested Select statement (error output) 1
Replies
2
Views
45
soushi01
soushi01
raddycal
  • Locked
  • Question
decode with group by
Replies
2
Views
36
carp
carp
tekpr00
  • Locked
  • Question
Not getting the desired output
Replies
1
Views
39
r937
r937

Part and Inventory Search

Sponsor

Back
Top