Home » RDBMS Server » Server Administration » Formatting Text fields
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
Previous Topic: Need help constructing SQL query
Next Topic: Query With 'Like' Option
Goto Forum:
  


Current Time: Thu May 16 22:51:38 CDT 2024