SQL Language (MOSC)

MOSC Banner

Data fetch to flat file

edited Mar 7, 2013 2:20PM in SQL Language (MOSC) 17 commentsAnswered ✓
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center