Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: sql through unix.
Top Forums Shell Programming and Scripting sql through unix. Post 302234216 by jim mcnamara on Tuesday 9th of September 2008 10:24:18 AM
Old 09-09-2008
If you mean how to get sqlplus to display headers:
Code:
q1="slect * from XXXXXX;";

echo "
set pagesize 55
set head on
spool XXXX.txt
$q1
spool off
" | sqlplus i-s XXX/XXXX@XXXXX > file.txt

If you mean search the output for headers:
Code:
q1="slect * from XXXXXX;";

echo "
set pagesize 55
set head on
spool XXXX.txt
$q1
spool off
" | sqlplus i-s XXX/XXXX@XXXXX | \ 
awk 'BEGIN {old=""} { if( $0 ~ "^ --" ) {print old; print $0} old=$0}'


[/code]
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

SQL Commands in Unix

Hi gurus, Being a newbie not sure whether iam asking the right question? can we use oracle commands in unix for ex: to read a count on a table. if so, what needs to be configured and etc.. any kind of help is appreciated. Thanks sish (6 Replies)
Discussion started by: sish78
6 Replies

2. Shell Programming and Scripting

Using SQL in Unix

Please tell me how i can use SQL in my unix scripts. Please give examples. I just want to start writing some scripts for my use. Looking for ur cooperation. thanks (2 Replies)
Discussion started by: Mohit623
2 Replies

3. UNIX for Dummies Questions & Answers

SQL in Unix

Hi, I would like to access SQL plus from my unix, and learn to run some SQL scripts in Unix. How do i begin. Is there any known website that offers a quick tutorial or tips? Thanks, unxhopeful (4 Replies)
Discussion started by: unxhopeful
4 Replies

4. Shell Programming and Scripting

unix variables from sql / pl/sql

How do I dynamically assign the below output to unix shell variables so I can build a menu in a shell script? Example: var1 = 1 var2= SYSTEM var3 = 2 var4= UNDOTBS1 and so on, then in the shell script I can use the variables to build a menu. set serveroutput on declare... (2 Replies)
Discussion started by: djehres
2 Replies

5. UNIX for Dummies Questions & Answers

Execute PL/SQL function from Unix script (.sql file)

Hi guys, I am new on here, I have a function in oracle that returns a specific value: create or replace PACKAGE BODY "CTC_ASDGET_SCHED" AS FUNCTION FN_ASDSCHEDULE_GET RETURN VARCHAR2 AS BEGIN DECLARE ASDSchedule varchar2(6); ASDComplete... (1 Reply)
Discussion started by: reptile
1 Replies

6. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

Hi , I used the below script to get the sql data into csv file using unix scripting. I m getting the output into an output file but the output file is not displayed in a separe columns . #!/bin/ksh export FILE_PATH=/maav/home/xyz/abc/ rm $FILE_PATH/sample.csv sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies

7. Programming

Doing a SQL rollup in unix

If anyone is familiar with Oracle, there is a way to trace a file. Then there is is a script called tkprof that will generate a report that includes a rollup of some values. The problem with this script is that it only does the rollup properly if the query is finished. So I need something quick and... (2 Replies)
Discussion started by: guessingo
2 Replies

8. Shell Programming and Scripting

Unix and SQL server

Hi All, I am accessing Unix through putty (i.e. unix is installed on other server and i am accessing it remotely through putty). I am having SQL Server 2008 installed on my computer. Now i want to access sql server via. unix. Could some one please help me in this!!! Thanks (2 Replies)
Discussion started by: preetpalkapoor
2 Replies

9. Shell Programming and Scripting

Formatting sql in UNIX

hi folks am running the shell script below #!/bin/bash sqlplus 'scott@orcl/tiger'<<ENDSQL >> outputlogfile.csv SET PAGES 0 SET HEAD ON SET ECHO OFF SET FEEDBACK OFF SET LINESIZE 100 SET PAGESIZE 100 SET SERVEROUTPUT ON --# Fire the query on database select * from employee; ... (2 Replies)
Discussion started by: coolboy98699
2 Replies

10. Shell Programming and Scripting

How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX?

Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
1 Replies

LEARN ABOUT MOJAVE

datetime::locale::pa_arab5.18

DateTime::Locale::pa_Arab(3)				User Contributed Perl Documentation			      DateTime::Locale::pa_Arab(3)

NAME

       DateTime::Locale::pa_Arab

SYNOPSIS

	 use DateTime;

	 my $dt = DateTime->now( locale => 'pa_Arab' );
	 print $dt->month_name();

DESCRIPTION

       This is the DateTime locale package for Punjabi Arabic.

DATA

       This locale inherits from the DateTime::Locale::pa locale.

       It contains the following data.

   Days
       Wide (format)

	 XXX
	 XXXX
	 XXXX
	 XXXXXX
	 XXXX
	 XXXX
	 XXXXX

       Abbreviated (format)

	 XXX
	 XXXX
	 XXXX
	 XXXXXX
	 XXXX
	 XXXX
	 XXXXX

       Narrow (format)

	 XX
	 XX
	 XXX
	 XX
	 XXXX
	 XX
	 X

       Wide (stand-alone)

	 XXX
	 XXXX
	 XXXX
	 XXXXXX
	 XXXX
	 XXXX
	 XXXXX

       Abbreviated (stand-alone)

	 XXX
	 XXXX
	 XXXX
	 XXXXXX
	 XXXX
	 XXXX
	 XXXXX

       Narrow (stand-alone)

	 XX
	 XX
	 XXX
	 XX
	 XXXX
	 XX
	 X

   Months
       Wide (format)

	 XXXXX
	 XXXXX
	 XXXX
	 XXXXX
	 XX
	 XXX
	 XXXXXX
	 XXXX
	 XXXXX
	 XXXXXX
	 XXXXX
	 XXXXX

       Abbreviated (format)

	 XXXXX
	 XXXXX
	 XXXX
	 XXXXX
	 XX
	 XXX
	 XXXXXX
	 XXXX
	 XXXXX
	 XXXXXX
	 XXXXX
	 XXXXX

       Narrow (format)

	 X
	 X
	 XX
	 X
	 X
	 XX
	 XX
	 X
	 X
	 X
	 X
	 X

       Wide (stand-alone)

	 XXXXX
	 XXXXX
	 XXXX
	 XXXXX
	 XX
	 XXX
	 XXXXXX
	 XXXX
	 XXXXX
	 XXXXXX
	 XXXXX
	 XXXXX

       Abbreviated (stand-alone)

	 1
	 2
	 3
	 4
	 5
	 6
	 7
	 8
	 9
	 10
	 11
	 12

       Narrow (stand-alone)

	 X
	 X
	 XX
	 X
	 X
	 XX
	 XX
	 X
	 X
	 X
	 X
	 X

   Quarters
       Wide (format)

	 XXXXXX XXXXX
	 XXXXXX XXXX
	 XXXXXX XXXX
	 XXXXXX XXXXX

       Abbreviated (format)

	 XXXXXX XXXXX
	 XXXXXX XXXX
	 XXXXXX XXXX
	 XXXXXX XXXXX

       Narrow (format)

	 1
	 2
	 3
	 4

       Wide (stand-alone)

	 XXXXXX XXXXX
	 XXXXXX XXXX
	 XXXXXX XXXX
	 XXXXXX XXXXX

       Abbreviated (stand-alone)

	 XXXXXX XXXXX
	 XXXXXX XXXX
	 XXXXXX XXXX
	 XXXXXX XXXXX

       Narrow (stand-alone)

	 1
	 2
	 3
	 4

   Eras
       Wide

	 XXXXXXXX
	 XX

       Abbreviated

	 XXXXXXXX
	 XX

       Narrow

	 XXXXXXXX
	 XX

   Date Formats
       Full

	  2008-02-05T18:30:30 = XXXX, 05 XXXXX 2008
	  1995-12-22T09:05:02 = XXXX, 22 XXXXX 1995
	 -0010-09-15T04:44:23 = XXXX, 15 XXXXX -10

       Long

	  2008-02-05T18:30:30 = 5 XXXXX 2008
	  1995-12-22T09:05:02 = 22 XXXXX 1995
	 -0010-09-15T04:44:23 = 15 XXXXX -10

       Medium

	  2008-02-05T18:30:30 = 5 XXXXX 2008
	  1995-12-22T09:05:02 = 22 XXXXX 1995
	 -0010-09-15T04:44:23 = 15 XXXXX -10

       Short

	  2008-02-05T18:30:30 = 05/02/2008
	  1995-12-22T09:05:02 = 22/12/1995
	 -0010-09-15T04:44:23 = 15/09/-010

       Default

	  2008-02-05T18:30:30 = 5 XXXXX 2008
	  1995-12-22T09:05:02 = 22 XXXXX 1995
	 -0010-09-15T04:44:23 = 15 XXXXX -10

   Time Formats
       Full

	  2008-02-05T18:30:30 = 6:30:30 XXXX UTC
	  1995-12-22T09:05:02 = 9:05:02 XXXXX UTC
	 -0010-09-15T04:44:23 = 4:44:23 XXXXX UTC

       Long

	  2008-02-05T18:30:30 = 6:30:30 XXXX UTC
	  1995-12-22T09:05:02 = 9:05:02 XXXXX UTC
	 -0010-09-15T04:44:23 = 4:44:23 XXXXX UTC

       Medium

	  2008-02-05T18:30:30 = 6:30:30 XXXX
	  1995-12-22T09:05:02 = 9:05:02 XXXXX
	 -0010-09-15T04:44:23 = 4:44:23 XXXXX

       Short

	  2008-02-05T18:30:30 = 6:30 XXXX
	  1995-12-22T09:05:02 = 9:05 XXXXX
	 -0010-09-15T04:44:23 = 4:44 XXXXX

       Default

	  2008-02-05T18:30:30 = 6:30:30 XXXX
	  1995-12-22T09:05:02 = 9:05:02 XXXXX
	 -0010-09-15T04:44:23 = 4:44:23 XXXXX

   Datetime Formats
       Full

	  2008-02-05T18:30:30 = XXXX, 05 XXXXX 2008 6:30:30 XXXX UTC
	  1995-12-22T09:05:02 = XXXX, 22 XXXXX 1995 9:05:02 XXXXX UTC
	 -0010-09-15T04:44:23 = XXXX, 15 XXXXX -10 4:44:23 XXXXX UTC

       Long

	  2008-02-05T18:30:30 = 5 XXXXX 2008 6:30:30 XXXX UTC
	  1995-12-22T09:05:02 = 22 XXXXX 1995 9:05:02 XXXXX UTC
	 -0010-09-15T04:44:23 = 15 XXXXX -10 4:44:23 XXXXX UTC

       Medium

	  2008-02-05T18:30:30 = 5 XXXXX 2008 6:30:30 XXXX
	  1995-12-22T09:05:02 = 22 XXXXX 1995 9:05:02 XXXXX
	 -0010-09-15T04:44:23 = 15 XXXXX -10 4:44:23 XXXXX

       Short

	  2008-02-05T18:30:30 = 05/02/2008 6:30 XXXX
	  1995-12-22T09:05:02 = 22/12/1995 9:05 XXXXX
	 -0010-09-15T04:44:23 = 15/09/-010 4:44 XXXXX

       Default

	  2008-02-05T18:30:30 = 5 XXXXX 2008 6:30:30 XXXX
	  1995-12-22T09:05:02 = 22 XXXXX 1995 9:05:02 XXXXX
	 -0010-09-15T04:44:23 = 15 XXXXX -10 4:44:23 XXXXX

   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 XXXX
	  1995-12-22T09:05:02 = 22 XXXX
	 -0010-09-15T04:44:23 = 15 XXXX

       HHmmss (HH:mm:ss)

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 09:05:02
	 -0010-09-15T04:44:23 = 04:44:23

       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 XXXX
	  1995-12-22T09:05:02 = 9:05 XXXXX
	 -0010-09-15T04:44:23 = 4:44 XXXXX

       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 XXXX
	  1995-12-22T09:05:02 = 9:05:02 XXXXX
	 -0010-09-15T04:44:23 = 4:44:23 XXXXX

       M (L)

	  2008-02-05T18:30:30 = 2
	  1995-12-22T09:05:02 = 12
	 -0010-09-15T04:44:23 = 9

       Md (d/M)

	  2008-02-05T18:30:30 = 5/2
	  1995-12-22T09:05:02 = 22/12
	 -0010-09-15T04:44:23 = 15/9

       MEd (E, M-d)

	  2008-02-05T18:30:30 = XXXX, 2-5
	  1995-12-22T09:05:02 = XXXX, 12-22
	 -0010-09-15T04:44:23 = XXXX, 9-15

       MMM (LLL)

	  2008-02-05T18:30:30 = 2
	  1995-12-22T09:05:02 = 12
	 -0010-09-15T04:44:23 = 9

       MMMd (MMM d)

	  2008-02-05T18:30:30 = XXXXX 5
	  1995-12-22T09:05:02 = XXXXX 22
	 -0010-09-15T04:44:23 = XXXXX 15

       MMMEd (E MMM d)

	  2008-02-05T18:30:30 = XXXX XXXXX 5
	  1995-12-22T09:05:02 = XXXX XXXXX 22
	 -0010-09-15T04:44:23 = XXXX XXXXX 15

       MMMMd (MMMM d)

	  2008-02-05T18:30:30 = XXXXX 5
	  1995-12-22T09:05:02 = XXXXX 22
	 -0010-09-15T04:44:23 = XXXXX 15

       MMMMEd (E MMMM d)

	  2008-02-05T18:30:30 = XXXX XXXXX 5
	  1995-12-22T09:05:02 = XXXX XXXXX 22
	 -0010-09-15T04:44:23 = XXXX XXXXX 15

       mmss (mm:ss)

	  2008-02-05T18:30:30 = 30:30
	  1995-12-22T09:05:02 = 05:02
	 -0010-09-15T04:44:23 = 44:23

       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 = XXXX, 2008-2-5
	  1995-12-22T09:05:02 = XXXX, 1995-12-22
	 -0010-09-15T04:44:23 = XXXX, -10-9-15

       yMMM (y MMM)

	  2008-02-05T18:30:30 = 2008 XXXXX
	  1995-12-22T09:05:02 = 1995 XXXXX
	 -0010-09-15T04:44:23 = -10 XXXXX

       yMMMEd (EEE, y MMM d)

	  2008-02-05T18:30:30 = XXXX, 2008 XXXXX 5
	  1995-12-22T09:05:02 = XXXX, 1995 XXXXX 22
	 -0010-09-15T04:44:23 = XXXX, -10 XXXXX 15

       yMMMM (y MMMM)

	  2008-02-05T18:30:30 = 2008 XXXXX
	  1995-12-22T09:05:02 = 1995 XXXXX
	 -0010-09-15T04:44:23 = -10 XXXXX

       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 XXXXXX XXXXX
	  1995-12-22T09:05:02 = 1995 XXXXXX XXXXX
	 -0010-09-15T04:44:23 = -10 XXXXXX XXXX

       yyMMM (MMM yy)

	  2008-02-05T18:30:30 = XXXXX 08
	  1995-12-22T09:05:02 = XXXXX 95
	 -0010-09-15T04:44:23 = XXXXX -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

   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::pa_Arab(3)
All times are GMT -4. The time now is 04:55 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy