I am trying to generate a fixed length text file from Oracle 9i table.
My expected output is
1-10 First Name
11-20 Last Name
My output is going to look like this:
Steveson Cathy Washington DC
Robbs Valles Maryland
What is best way i can do, UTL_FILE or Spool or some other approach? If so how to do?
This post first appeared at Oracleinaction (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself).
I will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…