PLSQL CONCAT multiple rows in one string

     
       select CONCAT(REPLACE(listagg( ENTITY_NAME, chr(300)||'(') within group( order by NAME_TYPE_FLG DESC),',',' ')  ,')')AS X
 FROM  CISADM.CI_PER_NAME PN
            WHERE PN.PER_ID ='2252300000'
           AND  PN.NAME_TYPE_FLG IN(   'ALT' , 'PRIM')


output

another solution

SELECT wm_concat('('||ENTITY_NAME||')') 
 FROM
        (   SELECT PER_ID, PN.ENTITY_NAME
            FROM  CISADM.CI_PER_NAME PN
            WHERE PN.PER_ID ='2252300000'
           AND  PN.NAME_TYPE_FLG IN(   'ALT' , 'PRIM')
           ORDER BY PN.NAME_TYPE_FLG DESC
       )
       GROUP BY PER_ID ;

sql server truncate log script

 use ttt
 go
 sp_removedbreplication
    go
    alter database ttt set recovery simple
    go
    dbcc shrinkfile('ttt_log',200)
    go
    alter database ttt set recovery FUll
    go

Call Oracle Stored Procedure using Sql server Database Link

 BEGIN
DECLARE @P_DATE DATETIME=GETDATE()
DECLARE @P_EMPNO VARCHAR(10)
SET @P_EMPNO='2268224413'
DECLARE @P_TRAN_TYPE INTEGER =1
DECLARE @P_LOCNO VARCHAR(10)
SET @P_LOCNO='IT2020'
DECLARE @P_EXCEPTION DECIMAL



EXECUTE ( 'begin PUNCH.INSERT_ATTEND00_FINGER(?,?,?,?,?); end;', @P_DATE, @P_EMPNO, @P_TRAN_TYPE,@P_LOCNO, @P_EXCEPTION OUTPUT) AT FP_ORA;

SELECT @P_EXCEPTION

END