format of output is weird Post: 302343840

Sponsored Content

Top Forums Shell Programming and Scripting format of output is weird Post 302343840 by jim mcnamara on Thursday 13th of August 2009 07:55:05 PM

08-13-2009

Registered User

This is a sqlplus problem, not unix.

Place this above the select statement:

Code:

COL FIRST_NAME       format a8 trunc   head 'fname'
COL LAST_NAME        format a8 trunc   head 'lanme'
COL TNUMBER          format a8 trunc   head 'tnum'
COL CAMPAIGN_NAME    format a8 trunc   head 'cname'
COL TEAM_TITLE       format a8 trunc   head 'ttitle'
COL PRODUCT_TYPE_ID  format a8 trunc   head 'prod typ'
COL PRODUCT_ID 		 format a8 trunc   head 'prod id'
COL PRODUCT_NAME     format a8 trunc   head 'prod name'
COL UPDATED_DT       format a8 trunc   head 'prod dt'

I gave each column 8 characters (a8). You get to correct that. If any columns are numeric us format 9999 - with enough 9's to cover the width of the column. OTherwise you get ##### instead.

the head clause is also yours to edit. The number of chars in the head clause needs to be no longer than the format statement allows the column to be.

Consider learning about sqlplus.

jim mcnamara

View Public Profile for jim mcnamara

Find all posts by jim mcnamara

10 More Discussions You Might Find Interesting

1. AIX

Weird bootlist output

just setup a new system today - 9117 570, using HMC for console but not partitioned. I installed this system twice. the first time it started off as 5300-00, then updated to ML03. before the update, I believe I mirrored the rootvg, and then altered the bootlist, at that point, the display was...

2. Shell Programming and Scripting

weird echo output?

#!/bin/bash INPUT=$1 if then INPUT=0$1 TRACKNUMBER=$INPUT fi TRACKNUMBER=$INPUT echo "Track Number:" $TRACKNUMBER if then echo "File Does Not Exist!: split-track"${TRACKNUMBER}".wav" exit 0 fi CUEFILE="$2"

3. UNIX for Dummies Questions & Answers

weird 'ls' output

Hi, Anyone knows why I can't display the contents of my directory and how to fix this? http://i50.tinypic.com/4smfth.jpg Thanks in advance for any advise. Deanne Double post. Continued here.

4. Shell Programming and Scripting

In bash getting weird output from function ?

My script- result="" times() { echo "inside the times function" result=8 echo "Inside function $result" return $result } result=$(times) echo "the value is "$? echo "the value of result $result" when I run I get this, why the value still remain 0. $ ./func the value is 0 the value...

5. Shell Programming and Scripting

Find files older than X with a weird file format

I have an issue with a korn shell script that I am writing. The script parses through a configuration file which lists a heap of path/directories for some files which need to be FTP'd. Now the script needs to check whether there are any files which have not been processed and are X minutes old. ...

6. Shell Programming and Scripting

Traceroute script weird output

This script is giving weird output #!/bin/bash NETPATH=(`/bin/traceroute -n 4.2.2.2 | awk '{print $2}'`) for i in "${NETPATH}" do echo $i done The output: to 11.11.11.1 1.1.1.1 99.111.208.2 traceroute_test.sh traceroute_test.sh

7. Shell Programming and Scripting

Weird tail output over ssh

Hello; Am trying to correct the formatting of tail output over ssh. Using the following code: echo "" > $FILE for BOX in $SERVERS do echo "Processing on $BOX" |tee -a $FILE echo "===============================" >> $FILE sudo ssh $BOX 'TERMINAL="vt100" /usr/bin/sh -s' <...

8. HP-UX

[Solved] Weird 'ls -l' output

Hello folks, I've found an HP-UX server with a rare 'ls -l' output. Please see the attached file. Anybody knows how can I change the output to not have this extra tabulations? Thanks in advance!

9. UNIX for Advanced & Expert Users

Weird output from ps command

Hi Guys, I am regular Solaris user. I came across a weird problem that puzzled me. Hope you guys can help. I found that process's state(command & arguments) in two different variants of ps command is different. Can anyone explain how is this possible? bash-3.2$ ps -eLo pid,s,comm,args |...

10. Shell Programming and Scripting

Grep two files: -F flag gives weird output

Hi Members, I'm confused with grep -F option. Goal is to get all the lines from file2 that have exact gene name from gene list (file one). File one has list of genes: File two has lot more information pertinent to genes in file one: I use three following commands: 1) grep -wf gene...

LEARN ABOUT HPUX

trunc

trunc(3M)																 trunc(3M)

NAME

       trunc(), truncf(), truncl(), truncw(), truncq() - truncation functions

SYNOPSIS

   HP Integrity Server Only
DESCRIPTION

       The function rounds its argument to the integral value, in floating-point format, nearest to but no larger in magnitude than the argument.

   Integrity Server Only
       is a version of it takes a argument and returns a result.

       is a version of it takes a argument and returns a result.

       is an version of it takes an argument and returns an result.

       is equivalent to on HP-UX systems.

USAGE

       To use these functions, compile either with the default option or with the and options.

       To use (for Integrity servers) or compile also with the option.

       To use these functions, make sure your program includes Link in the math library by specifying on the compiler or linker command line.

       For more information, see the at the following site:

RETURN VALUE

       If x is returns x.

       If x is NaN, returns NaN.

       may raise the inexact exception if x is non-integral and finite.

ERRORS

       No errors are defined.

SEE ALSO

       ceil(3M),  floor(3M),  fabs(3M),  fmod(3M),  fegetround(3M),  fesetround(3M),  lrint(3M),  llrint(3M),  lround(3M),  llround(3M), rint(3M),
       round(3M), math(5), fenv(5).

STANDARDS CONFORMANCE

       : ISO/IEC C99 (including Annex F, ``IEC 60559 floating-point arithmetic'')

																	 trunc(3M)

10 More Discussions You Might Find Interesting

1. AIX

Weird bootlist output

Discussion started by: davew1099

2. Shell Programming and Scripting

weird echo output?

Discussion started by: TinCanFury

3. UNIX for Dummies Questions & Answers

weird 'ls' output

Discussion started by: Deanne

4. Shell Programming and Scripting

In bash getting weird output from function ?

Discussion started by: boy18nj