12-02-2005
help with header of sql
i have this script here..
text=/d:/...../1.txt
ORACLE_HOME/bin/sqlplus -S............
...................................................
spool $text;
select
item || '|' ||
ord_no || '|' ||
price || '|' ||
from order_table
The output header of this spooled data will be
item||'|'||ord_no||'|'||price||'|'|
--------------------------------
F42777|073059|100|
However now i want the header to be like this and the output remains the same....is there a way to do it?
item|ord_no|price|
--------------------------------
F42777|073059|100|
thanks for great help!
9 More Discussions You Might Find Interesting
1. Linux
say i have these many file in a directory named exam.
1)/exam/newfolder/link.txt.
2)/exam/newfolder1/
and i create a tar say exam.tar
well the problem is,
when i read the tar file i dont find any metadata about the directories,as you cannot create a tar containig empty directories.
on the... (2 Replies)
Discussion started by: Tanvirk
2 Replies
2. Shell Programming and Scripting
Input
#HAC0253
EFVHIJHIJEFVTHIJOPKOPKTEFVEFVEFVOPKHIJOPKOPKHIJTTEFVEFVTEFV
#BASFS12
EFVEFVHIJEFVEFVTOPKEFVOPKTHIJTTHIJOPK
#ACG5115
TEFVEFVOIJEFVHIJHIJOPKOPKHIJHIJTTEFVEFVOPKTTEFVEFVOPKHIJOPKOPKOPK
#ECG5114
IJTOPKHIJEFVOEFVEFVOPKTTEFVEFVOPKHIJOPKOPKOPK
.
.
Output (5 Replies)
Discussion started by: patrick87
5 Replies
3. Shell Programming and Scripting
Hi,
In a script i am trying to run a SQL by connecting Sybase DB.
While executing the script I am getting the output with the header. means:
Employee_Name--------------------------- Anup Das
I need the Output:
Anup Das
Kindly advice. (2 Replies)
Discussion started by: anupdas
2 Replies
4. Shell Programming and Scripting
Hi All,
I have a file example.csv which looks like this
GrpID,TargetID,Signal,Avg_Num
CSCH74_1_1,2007,61,256
CSCH74_1_1,212007,647,679
CSCH74_1_1,12007,3,32
CSCH74_1_1,207,299,777
I want the output as
GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num
CSCH74_1_1,2007,61,256... (4 Replies)
Discussion started by: Vavad
4 Replies
5. UNIX for Dummies Questions & Answers
Friends,
I need help with the following in UNIX.
Merge all csv files in one folder considering only 1 header row and ignoring header of all other files.
FYI - All files are in same format and contains same headers.
Thank you (4 Replies)
Discussion started by: Shiny_Roy
4 Replies
6. Shell Programming and Scripting
i have the SQL as mentioned below.
i put this sql in a file and calling from the script and output of SQL
has been redirected to a file.
but when i open the sql output file i dont see the header in sql output.
how can i get the header also ?
====
SELECT RATE_CODE,NAME, CTR,TYPE
... (1 Reply)
Discussion started by: mail2sant
1 Replies
7. Shell Programming and Scripting
Hi,
I have an input like this
1 2 3 4
2 3 4 5
4 5 6 7
I would like to count the no. of columns and print a header with a prefix "Col".
I would also like to count the no. of rows and print as first column with each line number with a prefix "Row"
So, my output would be
... (2 Replies)
Discussion started by: jacobs.smith
2 Replies
8. Shell Programming and Scripting
Hello There...
I have a sample input file ..
number:department:amount
125:Market:125.23
126:Hardware store:434.95
127:Video store:7.45
128:Book store:14.32
129:Gasolline:16.10
I will be doing some manipulations on all the records except the header, but the header should always be... (2 Replies)
Discussion started by: juzz4fun
2 Replies
9. Shell Programming and Scripting
I've been struggling with this one for quite a while and cannot seem to find a solution for this find/replace scenario. Perhaps I'm getting rusty.
I have a file that contains a number of metrics (exactly 3 fields per line) from a few appliances that are collected in parallel. To identify the... (3 Replies)
Discussion started by: verdepollo
3 Replies
LEARN ABOUT CENTOS
item_value
mitem_value(3X) mitem_value(3X)
NAME
mitem_value - set and get menu item values
SYNOPSIS
#include <menu.h>
int set_item_value(ITEM *item, bool value);
bool item_value(const ITEM *item);
DESCRIPTION
If you turn off the menu option O_ONEVALUE (e.g., with set_menu_opts or menu_opts_off; see menu_opts(3X)), the menu becomes multi-valued;
that is, more than one item may simultaneously be selected.
In a multi_valued menu, you can used set_item_value to select the given menu item (second argument TRUE) or deselect it (second argument
FALSE).
RETURN VALUE
The function set_item_value returns one of the following:
E_OK The routine succeeded.
E_SYSTEM_ERROR
System error occurred (see errno).
E_REQUEST_DENIED
The menu driver could not process the request.
SEE ALSO
curses(3X), menu(3X).
NOTES
The header file <menu.h> automatically includes the header file <curses.h>.
PORTABILITY
These routines emulate the System V menu library. They were not supported on Version 7 or BSD versions.
AUTHORS
Juergen Pfeifer. Manual pages and adaptation for new curses by Eric S. Raymond.
mitem_value(3X)