Data fetch to flat file
Hello All,
There is one requirement for auditing purpose who requested to provide one table data to flat file (text file).
The table details are as below:
Structure of Table:
Col01 NOT NULL NUMBER(12)
Col02 NOT NULL NUMBER(12)
Col03 NOT NULL VARCHAR2(1)
Col04 NOT NULL NUMBER(4)
Col05 NOT NULL DATE
Col06 NOT NULL DATE
Col07 DATE
Col08 NUMBER(12)
Col09 VARCHAR2(30)
Col10 NUMBER(4)
Col11 <Schemaname>.XMLTYPE
Col12 NUMBER(1)
Total records in table:
COUNT(*)
----------
20338234
Size of the table:
SIZE_GB
----------
28.8183594
Average column length:
COLUMN_NAME AVG_COL_LEN
------------- -----------
Col01 8
Col02 8
Col03 2
Col04 3
Col05 8
Col06 8
Col07 8
Col08 7
Col09 8
Col10 3
There is one requirement for auditing purpose who requested to provide one table data to flat file (text file).
The table details are as below:
Structure of Table:
Col01 NOT NULL NUMBER(12)
Col02 NOT NULL NUMBER(12)
Col03 NOT NULL VARCHAR2(1)
Col04 NOT NULL NUMBER(4)
Col05 NOT NULL DATE
Col06 NOT NULL DATE
Col07 DATE
Col08 NUMBER(12)
Col09 VARCHAR2(30)
Col10 NUMBER(4)
Col11 <Schemaname>.XMLTYPE
Col12 NUMBER(1)
Total records in table:
COUNT(*)
----------
20338234
Size of the table:
SIZE_GB
----------
28.8183594
Average column length:
COLUMN_NAME AVG_COL_LEN
------------- -----------
Col01 8
Col02 8
Col03 2
Col04 3
Col05 8
Col06 8
Col07 8
Col08 7
Col09 8
Col10 3
0