C # Unified query for Batch table Wm_concat rows and columns conversion row count

Columns that need to be displayed
sql = string. Format (@ "
SELECT Wm_concat (COL. COLUMN_NAME)
From User_tab_cols COL
WHERE COL. table_name = ' {0} '
", fromtable);
String col = "" + DAC. ExecuteScalar (CommandType.Text, SQL);
Get data that has been imported
sql = string. Format (@ "SELECT {2}
from {0}
WHERE SUBSTR (SRQ, 1, 5) | | Case INSTR (SUBSTR (SRQ, 6, 2), '-')
When 2 Then
' 0 ' | | REPLACE (SUBSTR (SRQ, 6, 2), '-', ')
ELSE
SUBSTR (SRQ, 6, 2)
END = ' {1} '
ORDER by To_number (SBH, ' 999999 ') ", toTable, Periodcode, col
);

DataTable dt = DAC. executedatatable (SQL);

C # Unified query for Batch table Wm_concat rows and columns conversion row count