case when query sql dalam oracle

case when di oracle

 

Bismillah

[sourcecode language="sql"]CASE WHEN (ENGINE_NO IS NULL) THEN
CASE WHEN (SUBSTR(TYPECODE,1,2) = 'FA' OR SUBSTR(TYPECODE,1,2) = 'DG'
OR SUBSTR(TYPECODE,1,2) = 'DH' OR SUBSTR(TYPECODE,1,2) = 'DJ') THEN 'MLH'|| '' || FRAME_NO
ELSE 'MH1'|| '' || FRAME_NO END
ELSE FRAME_NO1 || '' || FRAME_NO
END AS FRAMENUMBERFULL[/sourcecode]



Alhamdulillah