Formatting Text fields [message #371934] |
Fri, 22 December 2000 10:55 |
Deanna
Messages: 9 Registered: December 2000
|
Junior Member |
|
|
Within my view I have a field that consists of characters with no spaces
AAATTTGATTTTAAAGGG
I need to format this field such that it has 10 characters, space, 10 characters, space etc...
The field has a variable length from row to row,
one row can be 30 characters long, another 45.
The field is defined as : VARCHAR2 (1500)
In additon I need to foramt the data such that one line is 180 characters then wordwrap to the next line which is 180 characters ... etc
Any suggestions would be greatly appreciated
|
|
|