-1

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.

2
Contributors
5
Replies
6
Views
5 Years
Discussion Span
Last Post by hfx642
0

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

Edited by hfx642: n/a

0

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!

Edited by hfx642: n/a

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.