Timeline for Error in execution case when nvl in oracle
Current License: CC BY-SA 4.0
Post Revisions
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 9, 2023 at 13:55 | vote | accept | JO OMIDI | ||
| Nov 28, 2022 at 7:19 | vote | accept | JO OMIDI | ||
| Jan 9, 2023 at 13:55 | |||||
| Nov 23, 2022 at 17:53 | answer | added | d r | timeline score: 0 | |
| Nov 22, 2022 at 15:08 | comment | added | JO OMIDI | I try this: (NVL(SUBSTR(FROM_DATE,1,10), (select max(TARIKHIJAD) FROM QV_JOZEAT_RIALI_FROSH GROUP BY ESHTERAKID)) ) and answer was: ORA-01427: single-row subquery returns more than one row | |
| Nov 22, 2022 at 14:55 | comment | added | JO OMIDI | The nvl argument selects a replacement for each field. I want the case when (NVL to use a query with another select to replace in NVL. for example: case when (NVL(SUBSTR(FROM_DATE,1,10)), then (select max(date_modif),ID FROM QV_JOZEAT_RIALI_FROSH GROUP BY date_modif,ID)) else (SUBSTR(FROM_DATE,1,10) end AS exp_date, | |
| Nov 22, 2022 at 14:45 | comment | added | Alex Poole |
You nvl doesn’t have a second argument, or a closing parenthesis. I guess it should nvl(substr(...), ‘NULL’) = ... but why not just check for null directly?
|
|
| Nov 22, 2022 at 14:34 | review | Close votes | |||
| Dec 7, 2022 at 3:04 | |||||
| Nov 22, 2022 at 14:32 | comment | added | JO OMIDI | My question was the error in using case when | |
| Nov 22, 2022 at 14:20 | history | edited | Abra | CC BY-SA 4.0 |
Added markdown.
|
| Nov 22, 2022 at 14:17 | comment | added | Chris Albert | Your question needs some work so the community can better help you. Take a look at how to ask a good question and give it another try. | |
| S Nov 22, 2022 at 14:07 | review | First questions | |||
| Nov 22, 2022 at 14:17 | |||||
| S Nov 22, 2022 at 14:07 | history | asked | JO OMIDI | CC BY-SA 4.0 | created from wizard |