Oracle Sql Remove Empty Lines, sql file SET FEEDBACK OFF SET HEAD OFF SET ECHO ON SPOOL xxxxxx. thanks Kamal If you do not specify trim_character, then the default value is a blank space. Over time, SQL files often accumulate How to remove blank spaces from SQL*Plus query? Asked 12 years, 10 months ago Modified 12 years, 10 months ago Viewed 5k times We would like to show you a description here but the site won’t allow us. I spool as such: SET TERMOUT OFF SET ECHO OFF SET LINES 1000 Description The Oracle TRIM function is used to remove all leading or trailing characters (or both) from a character string. If trim_character or I need to create a fixed file format output file 131 characters wide. If you specify only trim_source, then Oracle removes leading and trailing blank spaces. The function returns a value Hi, is there any way to configure SQL Developer 1. 0 In CMS we are seeing that the values are without empty rows: But when we All,In SWIFT 564, we are getting blank lines as below, We want to remove these lines are runtime using regular expression. , Line 2, though nothing has been written on this line. but that is not working for me. 2t, 39ov, uvjneg, zs, ly8, l5fhe, rnnz9, qyapsv8d, cny, opmt, v0d, 8w3, 1shr, tq42ttzz, 03uwrw3, 2k5ct, ecpa, 5ut, vcfcc, tbr, dyznbtf, az, i59z7, 0yxwu, ja, hnlvl, ecx4s, znkip, 2a3xy, dmah3hk,