01-09-2009
Column header
Hello all,
We are trying to run a script in Oracle DB from AIX.
We need to set the Column Header while executing the query to generate the Output.
For eg.
select city, name from emp;
It need to generate report in .csv format as
CITY NAME
atla tom
cincin jack
How I can write a shell to get the column heading as CITY, NAME in unix.
Thanks and Regards,
Milan
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
$ cat log.txt
Name Age Sex Lcation nfld alias xsd
CC 25 M XYZ asx KK Y
BB 21 F XAS awe SS N
SD 21 M AQW rty SD A
How can I replace the column with header "Lcation" with the column with header "alias" and delete the "alias" column?
so that the final output will become:
Name Age Sex... (10 Replies)
Discussion started by: jkl_jkl
10 Replies
2. Shell Programming and Scripting
i have a script that access the database and then returns some row. but in the command prompt it it not showing the column header. how to get that ?
below the script:
------------------------------------------------------------------------
#!/bin/ksh
.... (4 Replies)
Discussion started by: ali560045
4 Replies
3. 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
4. UNIX for Dummies Questions & Answers
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... (1 Reply)
Discussion started by: Vavad
1 Replies
5. 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
6. Shell Programming and Scripting
Hi,
I have some 10 tab delimited flat files, for some files the column header starts from 1st row whereas for some other files the column header starts from row or row 3 or row4 and so on....
Is there any way in UNIX so that we can read the column headers dynamically.'
I am new to UNIX, so... (12 Replies)
Discussion started by: kedar_laveti
12 Replies
7. Shell Programming and Scripting
Hi,
Below is the data in a tab limited file
Here ACCENT is just a heading and the line starting with Pcode has the column headers, and there is a 2 lines space between the file header and column header.
I want to print $2, that is Dealer Name
I used the below code
nawk... (1 Reply)
Discussion started by: kedar_laveti
1 Replies
8. Shell Programming and Scripting
hello,
can someone helpe me on below issue.
i have a list of names and IDs,
mick 3424
noah 134
samuel 787
jack 434
i want to add a head for both colum using awk or sed or any tool
output
NAME ID
mick 3424
noah 134
samuel 787 (10 Replies)
Discussion started by: Sara_84
10 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I have a txt file with multiple columns and i want to substitute the header of the first column.
Example:
Seq. Name Seq. Length #Hits min. eValue mean Similarity #GOs GOs Enzyme Codes InterProScan
comp1000201_c0_seq1 ---NA--- 337 0 0 -
comp1000297_c0_seq1 ---NA--- 612 0 0 -... (4 Replies)
Discussion started by: alisrpp
4 Replies
10. Shell Programming and Scripting
Hello,
I am trying to store sum of a column as a new column inside a file but have to find the column names dynamically
I/p
c1,c2,c3,c4,c5
10,20,30,40,50
20,30,40,50,60
If i want to find sum only column c1, c3 and output it as c6,c7
O/p
c1,c2,c3,c4,c5,c6,c7
10,20,30,40,50,30,70... (6 Replies)
Discussion started by: mkathi
6 Replies
LEARN ABOUT PHP
oci_result
OCI_RESULT(3) OCI_RESULT(3)
oci_result - Returns field's value from the fetched row
SYNOPSIS
mixed oci_result (resource $statement, mixed $field)
DESCRIPTION
Returns the data from $field in the current row, fetched by oci_fetch(3).
For details on the data type mapping performed by the OCI8 extension, see the datatypes supported by the driver
PARAMETERS
o $statement
-
o $field
- Can be either use the column number (1-based) or the column name. The case of the column name must be the case that Oracle meta
data describes the column as, which is uppercase for columns created case insensitively.
RETURN VALUES
Returns everything as strings except for abstract types (ROWIDs, LOBs and FILEs). Returns FALSE on error.
EXAMPLES
Example #1
oci_fetch(3) with oci_result(3)
<?php
$conn = oci_connect('hr', 'welcome', 'localhost/XE');
if (!$conn) {
$e = oci_error();
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}
$sql = 'SELECT location_id, city FROM locations WHERE location_id < 1200';
$stid = oci_parse($conn, $sql);
oci_execute($stid);
while (oci_fetch($stid)) {
echo oci_result($stid, 'LOCATION_ID') . " is ";
echo oci_result($stid, 'CITY') . "<br>
";
}
// Displays:
// 1000 is Roma
// 1100 is Venice
oci_free_statement($stid);
oci_close($conn);
?>
NOTES
Note
In PHP versions before 5.0.0 you must use ociresult(3) instead. This name still can be used, it was left as alias of oci_result(3)
for downwards compatability. This, however, is deprecated and not recommended.
SEE ALSO
oci_fetch_array(3), oci_fetch_assoc(3), oci_fetch_object(3), oci_fetch_row(3), oci_fetch_all(3).
PHP Documentation Group OCI_RESULT(3)