How to use awk for printing line from database?

view full story

http://www.linuxquestions.org – Hi , I have inserted some records in a table having column "value1 varchar2(4000)" and want to spool in a file. I have written as below /********/ set echo off set feed off set hea off set wra off set lin 500 spo temp_table /********/ and fired select query as below select value1 from temp_table; spo off Now the output length of each column is 500 as i have given above. The data in the temp_table varry in length and seperated by semicolon";" as below. asdfg;sdeeeedf;;dfff (HowTos)