please convert this below query to plsql format
select
(select count(*) from cadastredefunct t
where t.areacode= 'PTH01'
AND T.SECTIONNUMBER = 'D'
and t.defunctnumber <> 'ONGD') as total,
(select count(*) from cadastredefunct t
where t.areacode = 'PTH01'
AND T.SECTIONNUMBER = 'D'
and t.status = 'COMP'
and t.defunctnumber <> 'ONGD') as completed,
(select count(*) from cadastredefunct t
where t.areacode='PTH01'
and t.sectionnumber='D'
and t.status='INVALID') as Invalid,
(select count(*) from cadastredefunct t
where t.areacode = 'PTH01'
AND T.SECTIONNUMBER = 'D'
AND T.STATUS IS NULL
and t.defunctnumber <> 'ONGD') as YTS,
(select count(*) from cadastredefunct t
where t.areacode= 'PTH01'
AND T.SECTIONNUMBER = 'D'
AND (T.STATUS = 'OUT OF SCOPE RVK' OR upper(t.status) = 'RVK HOLD' OR upper(t.status) = 'RVKHOLD')) AS RVKHold,
(select count(*) from cadastredefunct t
where t.areacode = 'PTH01'
AND T.SECTIONNUMBER = 'D'
AND (T.STATUS = 'VECTOR NOT AVAILABLE IN INPUT GML' OR upper(t.status) = 'NOT AVAILABLE IN INPUT GML')) AS VecNAHold,
(select count(*) from cadastredefunct t
where t.areacode = 'PTH01'
AND T.SECTIONNUMBER = 'D'
AND T.STATUS = 'OUT OF SCOPE(<1950 - >2000)') AS OSSHold,
(select count(*) from cadastredefunct t
where t.areacode = 'PTH01'
AND T.SECTIONNUMBER = 'D'
and (STATUS = 'AVAILABLE IN VECTOR')) AS OtherHOLD,
(select count(*) from cadastredefunct t
where t.areacode = 'PTH01'
AND T.SECTIONNUMBER = 'D'
AND T.STATUS = 'QUERY') AS HLDQUERY,
(select count(*) from cadastredefunct t
where t.areacode = 'PTH01'
AND T.SECTIONNUMBER = 'D'
AND T.STATUS ='EDGE') AS EDGE,
(select count(*) from cadastralparcel t
where t.areacode = 'PTH01'
AND T.SECTIONNUMBER = 'D') as CurrentTotal,
(select count(*) from cadastralparcel t
where t.areacode = 'PTH01'
AND T.SECTIONNUMBER = 'D'
and t.isdone = 'Y') as CurrentCompleted,
(select count(*) from cadastralparcel t
where t.areacode ='PTH01'
AND T.SECTIONNUMBER = 'D'
AND T.isdone IS NULL) as CurrentYTS,
(select count(*) from cadastralparcel t
where t.areacode = 'PTH01'
AND T.SECTIONNUMBER = 'D'
AND (T.holdcomment = 'OUTOF SCOPE RVK' OR upper(t.holdcomment) = 'RVK HOLD' OR upper(t.holdcomment) = 'RVKHOLD') and isdone = 'H') AS CurrentRVKHOLD,
(select count(*) from cadastralparcel t
where t.areacode = 'PTH01'
AND T.SECTIONNUMBER = 'D'
and (holdcomment = 'AVAILABLE IN VECTOR' OR holdcomment = 'VECTOR NOT AVAILABLE ININPUT GML' or holdcomment = 'NOT AVAILABLE IN INPUT GML') AND ISDONE = 'H') AS CurrentHOLD,
(select count(*) from cadastralparcel t
where t.areacode = 'PTH01'
AND T.SECTIONNUMBER = 'D'
AND T.holdcomment = 'QUERY'
AND ISDONE = 'H') AS CurrentHLDQUERY,
(select count(*) from cadastralparcel t
where t.areacode = 'PTH01'
AND T.SECTIONNUMBER = 'D'
AND T.holdcomment = 'EDGE'
AND ISDONE = 'H') AS CurrentEDGE,
(select count(*) from cadastralparcel t
where t.areacode = 'PTH01'
AND T.SECTIONNUMBER = 'D'
AND T.holdcomment = 'OUT OF SCOPE(<1950 - >2000)' AND ISDONE = 'H') AS CurrentOUTOFSCOPE
from dual
convert the above query to plsql.
