Oracle connection string: |

'|' + 'Is used for string connection in Oracle '.

Select Rec. sheet_id,

Rec. orgid,

Org. orgname,

Case

When Rec. receive_flag = 2 then

(Case

When exists (select count (1)

Fromeosorg_t_organization

Where a. orgseq like '192. 99999. %'

And a. orgid = Rec. orgid) then

'[Group Company network operation department]'|Org. orgname--'[Group Company network operation department]'+Org. orgname

Else

Org. orgname

End)

Else

Org. orgname

End as pdforgname,

Rec. receive_flag

Fromoc_j_receive_org rec,

Eosorg_t_organization org

Where Rec. orgid = org. orgid

And Rec. receive_flag in (1, 2)

And Rec. sheet_id = 3281;