I have a batch_requests table where there is a start_date and end_date column with datatype as date.
<code>Create table BATCH_rEQUESTS
(Request NUMBER NOT NULL,
START_DATE DATE,
END_DATE DATE)
</code>
<code>Create table BATCH_rEQUESTS
(Request NUMBER NOT NULL,
START_DATE DATE,
END_DATE DATE)
</code>
Create table BATCH_rEQUESTS
(Request NUMBER NOT NULL,
START_DATE DATE,
END_DATE DATE)
The query below throws invalid number error when i ad case statement to it–
<code>select request, details,start,to_char(end_date,'DD/MM/YYY'),case when end_date is null then 'N' else 'Y' end as status from batch_Requests;
</code>
<code>select request, details,start,to_char(end_date,'DD/MM/YYY'),case when end_date is null then 'N' else 'Y' end as status from batch_Requests;
</code>
select request, details,start,to_char(end_date,'DD/MM/YYY'),case when end_date is null then 'N' else 'Y' end as status from batch_Requests;
I am unable to identify what is wrong here.