On Feb 16, 2008 7:19 PM, Ubence Quevedo <r0d3nt@xxxxxxxxxxx> wrote: > Scott, you are exactly right. I am looking to take various data in > multiple tables and create an output file delimited into specific > sections. I'll look more into the proper usage of select into as well > as the substring/field example you have given below. Then you'll be wanting lpad or rpad to make the fixed widths. It's pretty straight ahead. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend