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.

Member Avatar

And how much are you willing to pay for someone to convert this?
I don't come cheap!

okay then i don't need your suggestion..

Member Avatar

Sorry... But we are members of this forum to provide help... Not a service.

hey i didn't ask service.. even i asked help only

Member Avatar

I'm sorry, but...
"please convert this below query to plsql format"
and
"convert the above query to plsql."
is NOT asking for help.
It's asking for someone to do YOUR work for you.
Please abide by the forum rules.
Thank-You!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.