headers of the query


 
Thread Tools Search this Thread
Top Forums Programming headers of the query
# 1  
Old 09-09-2008
headers of the query

when we are spooling query o/p to certain txt file,in that file how we can get headers in the query.(through unix shell scripting).

for exmple

q1="slect * from XXXXXX;";

sqlplus XXX/XXXX@XXXXX

spool XXXX.txt
$q1
spool off

in the text file i want the headers of the query.....

plese suggest...

Last edited by bhagya.puccha; 09-09-2008 at 04:10 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Email Headers

I'm trying to pick up some Unix SysAdmin skills on my own outside of work through the use of the "Unix and Linux System Administrators Handbook." I've found the exercises to be very beneficial, until I came to this.... "What path did the email take? To Whom was it addressed, and to whom was it... (0 Replies)
Discussion started by: ksmarine1980
0 Replies

2. UNIX for Dummies Questions & Answers

Netezza query in UNIX script without headers

Hi I'm trying run a netezza select query from a korn shell script, i'm getting the data in the below format, is there any way to get only the data in a vairable, Column_name -------------------- 2014:08:01 12:51:00 i just want the last line which is "2014:08:01 12:51:00" the command... (2 Replies)
Discussion started by: maximus_jack
2 Replies

3. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ... (2 Replies)
Discussion started by: DevendraG
2 Replies

4. UNIX for Dummies Questions & Answers

Modifying headers

I have a FASTA file with thousands of sequences that looks something like this: I need to modfy the header in such way that everything after the dot is remove. Thus, I will end up with something like this: Thanks (1 Reply)
Discussion started by: Xterra
1 Replies

5. Shell Programming and Scripting

Editing headers

Hi, I have a folder that contains many (multiple) files 1.fasta 2.fasta 3.fasta 4.fasta 5.fasta . . 100's of files Each such file have data in the following format for example: vi 1.fasta >AB_1 200bp MLKKPIIIGVTGGSGGGKTSVSRAILDSFPNARIAMIQHDSYYKDQSHMSFEERVKTNYDHPLAFDTDFM... (4 Replies)
Discussion started by: Lucky Ali
4 Replies

6. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Hi, I have a requirement as below which needs to be done viz UNIX shell script (1) I have to connect to an Oracle database (2) Exexute "SELECT field_status from table 1" query on one of the tables. (3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies

7. Shell Programming and Scripting

Merging of files with different headers to make combined headers file

Hi , I have a typical situation. I have 4 files and with different headers (number of headers is varible ). I need to make such a merged file which will have headers combined from all files (comman coluns should appear once only). For example - File 1 H1|H2|H3|H4 11|12|13|14 21|22|23|23... (1 Reply)
Discussion started by: marut_ashu
1 Replies

8. Shell Programming and Scripting

add the output of a query to a variable to be used in another query

I would like to use the result of a query in another query. How do I redirect/add the output to another variable? $result = odbc_exec($connect, $query); while ($row = odbc_fetch_array($result)) { echo $row,"\n"; } odbc_close($connect); ?> This will output hostnames: host1... (0 Replies)
Discussion started by: hazno
0 Replies

9. Shell Programming and Scripting

Remove text between headers while leaving headers intact

Hi, I'm trying to strip all lines between two headers in a file: ### BEGIN ### Text to remove, contains all kinds of characters ... Antispyware-Downloadserver.com (Germany)=http://www.antispyware-downloadserver.c om/updates/ Antispyware-Downloadserver.com #2... (3 Replies)
Discussion started by: Trones
3 Replies

10. Programming

C Headers

Where can i get C/C++ headers for OS MINIX 2.0.3? (0 Replies)
Discussion started by: biosdos
0 Replies
Login or Register to Ask a Question
DateTime::Locale::ti_ET(3)				User Contributed Perl Documentation				DateTime::Locale::ti_ET(3)

NAME
DateTime::Locale::ti_ET SYNOPSIS
use DateTime; my $dt = DateTime->now( locale => 'ti_ET' ); print $dt->month_name(); DESCRIPTION
This is the DateTime locale package for Tigrinya Ethiopia. DATA
This locale inherits from the DateTime::Locale::ti locale. It contains the following data. Days Wide (format) XXX XXX XXX XXX XXX XXX XXXX Abbreviated (format) XXX XXX XXX XXX XXX XXX XXX Narrow (format) X X X X X X X Wide (stand-alone) XXX XXX XXX XXX XXX XXX XXXX Abbreviated (stand-alone) XXX XXX XXX XXX XXX XXX XXX Narrow (stand-alone) X X X X X X X Months Wide (format) XXXXX XXXXX XXX XXXX XX XX XXX XXXX XXXXXX XXXXXX XXXXX XXXXX Abbreviated (format) XXX XXX XXX XXX XX XX XXX XXX XXX XXX XXX XXX Narrow (format) X X X X X X X X X X X X Wide (stand-alone) XXXXX XXXXX XXX XXXX XX XX XXX XXXX XXXXXX XXXXXX XXXXX XXXXX Abbreviated (stand-alone) XXX XXX XXX XXX XX XX XXX XXX XXX XXX XXX XXX Narrow (stand-alone) X X X X X X X X X X X X Quarters Wide (format) Q1 Q2 Q3 Q4 Abbreviated (format) Q1 Q2 Q3 Q4 Narrow (format) 1 2 3 4 Wide (stand-alone) Q1 Q2 Q3 Q4 Abbreviated (stand-alone) Q1 Q2 Q3 Q4 Narrow (stand-alone) 1 2 3 4 Eras Wide BCE CE Abbreviated X/X X/X Narrow X/X X/X Date Formats Full 2008-02-05T18:30:30 = XXXX 05 XXXXX XXXX 2008 X/X 1995-12-22T09:05:02 = XXXX 22 XXXXX XXXX 1995 X/X -0010-09-15T04:44:23 = XXXX 15 XXXXXX XXXX -10 X/X Long 2008-02-05T18:30:30 = 05 XXXXX 2008 1995-12-22T09:05:02 = 22 XXXXX 1995 -0010-09-15T04:44:23 = 15 XXXXXX -10 Medium 2008-02-05T18:30:30 = 05-XXX-2008 1995-12-22T09:05:02 = 22-XXX-1995 -0010-09-15T04:44:23 = 15-XXX--10 Short 2008-02-05T18:30:30 = 05/02/08 1995-12-22T09:05:02 = 22/12/95 -0010-09-15T04:44:23 = 15/09/-10 Default 2008-02-05T18:30:30 = 05-XXX-2008 1995-12-22T09:05:02 = 22-XXX-1995 -0010-09-15T04:44:23 = 15-XXX--10 Time Formats Full 2008-02-05T18:30:30 = 6:30:30 XXX XXX UTC 1995-12-22T09:05:02 = 9:05:02 XXX XXX UTC -0010-09-15T04:44:23 = 4:44:23 XXX XXX UTC Long 2008-02-05T18:30:30 = 6:30:30 XXX XXX UTC 1995-12-22T09:05:02 = 9:05:02 XXX XXX UTC -0010-09-15T04:44:23 = 4:44:23 XXX XXX UTC Medium 2008-02-05T18:30:30 = 6:30:30 XXX XXX 1995-12-22T09:05:02 = 9:05:02 XXX XXX -0010-09-15T04:44:23 = 4:44:23 XXX XXX Short 2008-02-05T18:30:30 = 6:30 XXX XXX 1995-12-22T09:05:02 = 9:05 XXX XXX -0010-09-15T04:44:23 = 4:44 XXX XXX Default 2008-02-05T18:30:30 = 6:30:30 XXX XXX 1995-12-22T09:05:02 = 9:05:02 XXX XXX -0010-09-15T04:44:23 = 4:44:23 XXX XXX Datetime Formats Full 2008-02-05T18:30:30 = XXXX 05 XXXXX XXXX 2008 X/X 6:30:30 XXX XXX UTC 1995-12-22T09:05:02 = XXXX 22 XXXXX XXXX 1995 X/X 9:05:02 XXX XXX UTC -0010-09-15T04:44:23 = XXXX 15 XXXXXX XXXX -10 X/X 4:44:23 XXX XXX UTC Long 2008-02-05T18:30:30 = 05 XXXXX 2008 6:30:30 XXX XXX UTC 1995-12-22T09:05:02 = 22 XXXXX 1995 9:05:02 XXX XXX UTC -0010-09-15T04:44:23 = 15 XXXXXX -10 4:44:23 XXX XXX UTC Medium 2008-02-05T18:30:30 = 05-XXX-2008 6:30:30 XXX XXX 1995-12-22T09:05:02 = 22-XXX-1995 9:05:02 XXX XXX -0010-09-15T04:44:23 = 15-XXX--10 4:44:23 XXX XXX Short 2008-02-05T18:30:30 = 05/02/08 6:30 XXX XXX 1995-12-22T09:05:02 = 22/12/95 9:05 XXX XXX -0010-09-15T04:44:23 = 15/09/-10 4:44 XXX XXX Default 2008-02-05T18:30:30 = 05-XXX-2008 6:30:30 XXX XXX 1995-12-22T09:05:02 = 22-XXX-1995 9:05:02 XXX XXX -0010-09-15T04:44:23 = 15-XXX--10 4:44:23 XXX XXX Available Formats d (d) 2008-02-05T18:30:30 = 5 1995-12-22T09:05:02 = 22 -0010-09-15T04:44:23 = 15 EEEd (d EEE) 2008-02-05T18:30:30 = 5 XXX 1995-12-22T09:05:02 = 22 XXX -0010-09-15T04:44:23 = 15 XXX Hm (H:mm) 2008-02-05T18:30:30 = 18:30 1995-12-22T09:05:02 = 9:05 -0010-09-15T04:44:23 = 4:44 hm (h:mm a) 2008-02-05T18:30:30 = 6:30 XXX XXX 1995-12-22T09:05:02 = 9:05 XXX XXX -0010-09-15T04:44:23 = 4:44 XXX XXX Hms (H:mm:ss) 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 9:05:02 -0010-09-15T04:44:23 = 4:44:23 hms (h:mm:ss a) 2008-02-05T18:30:30 = 6:30:30 XXX XXX 1995-12-22T09:05:02 = 9:05:02 XXX XXX -0010-09-15T04:44:23 = 4:44:23 XXX XXX M (L) 2008-02-05T18:30:30 = 2 1995-12-22T09:05:02 = 12 -0010-09-15T04:44:23 = 9 Md (M-d) 2008-02-05T18:30:30 = 2-5 1995-12-22T09:05:02 = 12-22 -0010-09-15T04:44:23 = 9-15 MEd (E, M-d) 2008-02-05T18:30:30 = XXX, 2-5 1995-12-22T09:05:02 = XXX, 12-22 -0010-09-15T04:44:23 = XXX, 9-15 MMdd (dd/MM) 2008-02-05T18:30:30 = 05/02 1995-12-22T09:05:02 = 22/12 -0010-09-15T04:44:23 = 15/09 MMM (LLL) 2008-02-05T18:30:30 = XXX 1995-12-22T09:05:02 = XXX -0010-09-15T04:44:23 = XXX MMMd (MMM d) 2008-02-05T18:30:30 = XXX 5 1995-12-22T09:05:02 = XXX 22 -0010-09-15T04:44:23 = XXX 15 MMMEd (E MMM d) 2008-02-05T18:30:30 = XXX XXX 5 1995-12-22T09:05:02 = XXX XXX 22 -0010-09-15T04:44:23 = XXX XXX 15 MMMMd (MMMM d) 2008-02-05T18:30:30 = XXXXX 5 1995-12-22T09:05:02 = XXXXX 22 -0010-09-15T04:44:23 = XXXXXX 15 MMMMdd (dd MMMM) 2008-02-05T18:30:30 = 05 XXXXX 1995-12-22T09:05:02 = 22 XXXXX -0010-09-15T04:44:23 = 15 XXXXXX MMMMEd (E MMMM d) 2008-02-05T18:30:30 = XXX XXXXX 5 1995-12-22T09:05:02 = XXX XXXXX 22 -0010-09-15T04:44:23 = XXX XXXXXX 15 ms (mm:ss) 2008-02-05T18:30:30 = 30:30 1995-12-22T09:05:02 = 05:02 -0010-09-15T04:44:23 = 44:23 y (y) 2008-02-05T18:30:30 = 2008 1995-12-22T09:05:02 = 1995 -0010-09-15T04:44:23 = -10 yM (y-M) 2008-02-05T18:30:30 = 2008-2 1995-12-22T09:05:02 = 1995-12 -0010-09-15T04:44:23 = -10-9 yMEd (EEE, y-M-d) 2008-02-05T18:30:30 = XXX, 2008-2-5 1995-12-22T09:05:02 = XXX, 1995-12-22 -0010-09-15T04:44:23 = XXX, -10-9-15 yMMM (y MMM) 2008-02-05T18:30:30 = 2008 XXX 1995-12-22T09:05:02 = 1995 XXX -0010-09-15T04:44:23 = -10 XXX yMMMEd (EEE, y MMM d) 2008-02-05T18:30:30 = XXX, 2008 XXX 5 1995-12-22T09:05:02 = XXX, 1995 XXX 22 -0010-09-15T04:44:23 = XXX, -10 XXX 15 yMMMM (y MMMM) 2008-02-05T18:30:30 = 2008 XXXXX 1995-12-22T09:05:02 = 1995 XXXXX -0010-09-15T04:44:23 = -10 XXXXXX yQ (y Q) 2008-02-05T18:30:30 = 2008 1 1995-12-22T09:05:02 = 1995 4 -0010-09-15T04:44:23 = -10 3 yQQQ (y QQQ) 2008-02-05T18:30:30 = 2008 Q1 1995-12-22T09:05:02 = 1995 Q4 -0010-09-15T04:44:23 = -10 Q3 yyMM (MM/yy) 2008-02-05T18:30:30 = 02/08 1995-12-22T09:05:02 = 12/95 -0010-09-15T04:44:23 = 09/-10 yyQ (Q yy) 2008-02-05T18:30:30 = 1 08 1995-12-22T09:05:02 = 4 95 -0010-09-15T04:44:23 = 3 -10 yyyyMMMM (MMMM y) 2008-02-05T18:30:30 = XXXXX 2008 1995-12-22T09:05:02 = XXXXX 1995 -0010-09-15T04:44:23 = XXXXXX -10 Miscellaneous Prefers 24 hour time? No Local first day of the week XXX SUPPORT
See DateTime::Locale. AUTHOR
Dave Rolsky <autarch@urth.org> COPYRIGHT
Copyright (c) 2008 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. This module was generated from data provided by the CLDR project, see the LICENSE.cldr in this distribution for details on the CLDR data's license. perl v5.18.2 2017-10-06 DateTime::Locale::ti_ET(3)