Home » RDBMS Server » Server Administration » Re: Null-Value Problem
Re: Null-Value Problem [message #375017] Thu, 19 July 2001 01:52
Cindy
Messages: 88
Registered: November 1999
Member
Try this:

SET VERIFY OFF
SET ECHO OFF

COLUMN sal JUSTIFY LEFT FORMAT $99,990.00
COLUMN comm JUSTIFY RIGHT FORMAT $999,999.00
COLUMN ename HEADING 'Employee' FORMAT A15
SPOOL filename.dat

SELECT ename, sal, comm
FROM table_name
WHERE condition1
AND condition2
/

SPOOL OFF

COLUMN sal CLEAR
COLUMN comm CLEAR
COLUMN ename CLEAR

SET verify ON
SET ECHO ON

Report message to a moderator

Previous Topic: SQL Output redirection
Next Topic: SQL Problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 11:33:15 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.