I have the following case statement in my sql delimited query:
WHEN emp.emp_status in ('FB','PN','PB','LW','LP','LS','LT','LE','LI','WA') THEN 'A'
WHEN emp.emp_status in ('LF','LM','LO','LU','LA','LR') THEN 'L'
Although the result is just 1 character, per the vendor spec, it needs to be a length of 20.
How would I write that?
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.