Search Results

Thanks to all...

Tried the spool and it works. I guess I just learned a valuable lesson... My co-workers pretendto know UNIX. Next time I won't take what they say as gospel and try it for myself,...

@vbe, Here is the script, nothing fancy

set termout off;
set linesize 1938;
set pagesize 0;
set trims off;
set feedback off;

select
CASE WHEN col1 IS NULL THEN rpad(' ', 1) ELSE...

I have to create some fixed width files using UNIX. The data source is an Oracle SQL query. If I use straight SQL and spool to a file everything comes out as expected.

Example Desired result (....

I am writing a shell script and I am calling wc -l. I need to assign the results of this call to a varaible and it's not working the way I think it should:

xx= wc -l $1

What am I doing wrong?
...