Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: bash script & sql query
Top Forums UNIX for Dummies Questions & Answers bash script & sql query Post 302451649 by ixibits on Tuesday 7th of September 2010 03:29:20 PM
Old 09-07-2010
ok, that is it.

many thanks, scottn

---------- Post updated at 09:29 PM ---------- Previous update was at 09:23 PM ----------

echo "SET HEADING OFF;\n SET FEED OFF;\n exit\n"|Sqlplus -s /
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

& in SQL query

I have a script that looks for all jobs that contain a particular calendar. Some of the calendars have '&' in them and sql freaks out when it encounters that.. is there a way around this? I have tried: select job_name from job where run_calendar='1&15dom' select job_name from job... (3 Replies)
Discussion started by: Lindarella
3 Replies

2. Shell Programming and Scripting

script variable within a sql query

I created a script to read a csv file with four columns. The script also saved values of each col in a arry. In the script, i connected to db try to run a query to pull out data baisc on the values from the csv file. select Num from tableName where Sec_Num in ('${isin}') /*isin is an arry... (1 Reply)
Discussion started by: Sherry_Run
1 Replies

3. Shell Programming and Scripting

Script executing sql query

Hello, I have a sh script excuting a sql query through sqlplus. I am having trouble making my date equal to the date of the server time in the sql script. How can i call the server date from my query? Thanks (2 Replies)
Discussion started by: kingluke
2 Replies

4. Shell Programming and Scripting

query sql using shell script

query sql using shell script, is it possible? my friend told me to do a file.sql and link to my shell script, but can i query sql using shell script? thanks in advance! (2 Replies)
Discussion started by: kingpeejay
2 Replies

5. Shell Programming and Scripting

Oracle SQL Query & connect?

Hi I'm looking to query a table on a database and then iterate over the results in a loop. I believe this is the last part of my script that I need (after finding out threads for passing variables to other scripts and calling functions in other scripts). I've searched the forums but the best... (8 Replies)
Discussion started by: Dird
8 Replies

6. Shell Programming and Scripting

Run SQL thru shell script: how to get a new line when run sql query?

Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database. I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :( What should I do? I'm not sure that... (2 Replies)
Discussion started by: Kapom
2 Replies

7. Red Hat

Sql query through shell script

hey , i am using this code to store value of a sql query and and then use it in other query but after some time , but it is not working. please help #!/bin/bash val_1=$( sqlplus -s rte/rted2@rel76d2 << EOF setting heading off select max(stat_id) from cvt_stats; exit EOF ) nohup... (5 Replies)
Discussion started by: ramsavi
5 Replies

8. Shell Programming and Scripting

SQL query within an awk script !!

Hello Experts, This sounds crazy, but one of my requirements is that if ID in 5th column in my input file (: separated) is not present in the oracle database table (say t_id) then this record should be skipped. I am using awk for all other requirements. So I was thinking if this requirement... (4 Replies)
Discussion started by: juzz4fun
4 Replies

9. UNIX for Dummies Questions & Answers

Script to run sql query.

Please read How To Ask Questions The Smart Way (1 Reply)
Discussion started by: balu_279013
1 Replies

10. Shell Programming and Scripting

SQL query output convert to HTML & send as email body

Hi , I have a sql query in the unix script ,whose output is shown below.I want to convert this output to HTML table format & send email from unix with this table as email body. p_id src_system amount 1 A 100 2 B 200 3 C ... (3 Replies)
Discussion started by: jagadeeshn04
3 Replies

LEARN ABOUT DEBIAN

hbpldecode

hbpldecode(1)						      General Commands Manual						     hbpldecode(1)

NAME

       hbpldecode - Decode a HBPL stream into human readable form.

SYNOPSIS

       hbpldecode [options] <hbpl-file

DESCRIPTION

       hbpldecode decodes a HBPL stream into human readable form.

       A HBPL stream is the printer langauge used by the Fuji-Xerox cp105b and the Dell 1250c printers.

COMMAND LINE OPTIONS

       These are the options that can appear on the command line.

       -d basename
	      Basename of .pbm file for saving decompressed planes.

       -h     Print hex file offsets.

       -o     Print file offsets.

       -D level
	      Set Debug level [0].

EXAMPLES

       Decode an HBPL stream file.

       $ hbpldecode -h 1250c-mono.prn
	    0:	  33%-12345X@PJL JOB MODE=PRINTER
	   1f:	  @PJL SET STRINGCODESET=UTF8
	   3b:	  @PJL COMMENT DATE=06/01/2011
	   58:	  @PJL COMMENT TIME=13:28:30
	   73:	  @PJL COMMENT DNAME=empty - Notepad
	   96:	  @PJL SET JOBATTR="@LUNA=rick"
	   b4:	  @PJL SET COPIES=1
	   c6:	  @PJL SET QTY=1
	   d5:	  @PJL SET JOBATTR="@TRCH=OFF"
	   f2:	  @PJL SET DUPLEX=OFF
	  106:	  @PJL SET BINDING=LONGEDGE
	  120:	  @PJL SET RENDERMODE=GRAYSCALE
	  13e:	  @PJL SET ECONOMODE=OFF
	  155:	  @PJL SET RET=ON
	  165:	  @PJL SET JOBATTR="@IREC=OFF"
	  182:	  @PJL SET JOBATTR="@HOAD=I0A00020F"
	  1a5:	  @PJL SET JOBATTR="@JOAU=rick"
	  1c3:	  @PJL SET JOBATTR="@CNAM=RICK-VB"
	  1e4:	  @PJL SET IWAMANUALDUP=OFF
	  1fe:	  @PJL SET IWAJAMRECOVERY=AUTO
	  21b:	  @PJL SET JOBATTR="@MSIP=NORMAL"
	  23b:	  @PJL SET PAPERDIRECTION=SEF
	  257:	  @PJL SET RESOLUTION=600
	  26f:	  @PJL SET BITSPERPIXEL=8
	  287:	  @PJL SET JOBATTR="@DRDM=RASTER"
	  2a7:	  @PJL SET JOBATTR="@TCPR=33"
	  2c3:	  @PJL SET JOBATTR="@TUCR=33"
	  2df:	  @PJL SET JOBATTR="@TTRC=33"
	  2fb:	  @PJL SET JOBATTR="@TSCR=33"
	  317:	  @PJL SET JOBATTR="@GCPR=33"
	  333:	  @PJL SET JOBATTR="@GUCR=33"
	  34f:	  @PJL SET JOBATTR="@GTRC=33"
	  36b:	  @PJL SET JOBATTR="@GSCR=33"
	  387:	  @PJL SET JOBATTR="@ICPR=34"
	  3a3:	  @PJL SET JOBATTR="@IUCR=34"
	  3bf:	  @PJL SET JOBATTR="@ITRC=34"
	  3db:	  @PJL SET JOBATTR="@ISCR=34"
	  3f7:	  @PJL SET JOBATTR="@TDFT=0"
	  412:	  @PJL SET JOBATTR="@GDFT=0"
	  42d:	  @PJL SET JOBATTR="@IDFT=0"
	  448:	  @PJL ENTER LANGUAGE=HBPL
	  461:	  RECTYPE 'A' [0x41]:
	  462:	       81 a1: 0x0
	  465:	       82 a2: 0x7
	  469:	       83 a2: 0x1
	  46d:	  RECTYPE 'C' [0x43]:
	  46e:	       91 a1: 0x0
	  471:	       92 a1: 0x1
	  474:	       93 a1: 0x1
	  477:	       94 a1: 0x0
	  47a:	       95 c2: 0x0
	  480:	       96 a1: 0x0
	  483:	       97 c3: 0x0
	  489:	       98 a1: 0x0
	  48c:	       99 a4: 1 [PAGECNT]
	  492:	       9a c4: 5104x6600 [WxH]
	  49c:	       9b a1: 0x0
	  49f:	       9c a1: 0x1
	  4a2:	       9d a1: 0x9
	  4a5:	       9e a1: 0x2
	  4a8:	       9f a1: 0x5
	  4ab:	       a0 a1: 0x8
	  4ae:	       a1 a1: 0x0
	  4b1:	       a2 c4: 5104x6600 [WxH]
	  4bb:	  RECTYPE 'Q' [0x51]:
	  4bc:	  RECTYPE 'R' [0x52]:
	  4bd:	       a3 a1: 0x0
	  4c0:	       a4 a2: 6457 (0x1939) bytes of data...
	 1dfe:	  RECTYPE 'S' [0x53]:
	 1dff:	  RECTYPE 'D' [0x44]:
	 1e00:	  RECTYPE 'B' [0x42]:
	 1dff:	  33%-12345X@PJL EOJ

FILES

       /usr/bin/hbpldecode

AUTHOR

       Rick Richardson <rick.richardson@comcast.net>
All times are GMT -4. The time now is 11:32 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy