unloading sql query to file Post: 16016

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Redirecting sql select query result to txt file

Hi , I just found you while surfing for the string 'Redirecting sql select query output from within a shell script to txt file/excel file' Could you find time sending me the code for the above question? It'll be great help for me. I have a perl file that calls the sql file...

2. UNIX for Dummies Questions & Answers

How do I use SQL to query based off file data?

This is basically what I want to do: I have a file that contains single lines of IDs. I want to query the oracle database using these IDs to get a count of which ones match a certain condition. the basic idea is: cat myfile | while read id do $id in select count(PC.ptcpnt_id) from...

3. Shell Programming and Scripting

redirecting sql query output to a file

Hi, I am executing sql files in my unix shell script. Now i want to find whether its a success or a failure record and redirect the success or failure to the respective files. meaning. success records to success.log file failure record to failure.log file. As of now i am doing like...

4. 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...

5. UNIX for Advanced & Expert Users

Output the SQL Query result to a File

Hello Guys, This message is somewhat relates with last thread. But I need to re-write thing. I start over a little. I am stuck now and need your help. Here is my script- #! /bin/ksh export ORACLE_HOME=/opt/oracle/app/oracle/product/9.2 /opt/oracle/app/oracle/product/9.2/bin/sqlplus -s...

6. Shell Programming and Scripting

How to store the sql query output into txt file?

Hi I want ot save SQL query result in one txt file. for that i have written one code line sqlplus -s $dbstring @/usr/local/bin/sched/nightly_Cronjob/exec_123.sql >> /usr/local/bin/sched/nightly_Cronjob/result.txt but it is not working . database : Oracle so please advice me how can i...

7. UNIX for Dummies Questions & Answers

To pass multiple arguments from file in to an sql query

Hi all , I want to pass contents from a file say f1 as arguments to a sql query which has In statement using a script example select * from table_1 where login in ( `cat f1`) ; will this work or is there any other way to do it.

8. Shell Programming and Scripting

Get SQL query result to file in putty

How to Get SQL query result to file in putty? I have one SQL query and I want that query output to be redirected to the file. uname -a SunOS XXX 5.8 Generic_117350-58 sun4u sparc SUNW,Sun-Fire-480R Please suggest.

9. Shell Programming and Scripting

Read input file and used it to SQL query

Hi All, Seeking for your assistance to read each line $1 and $2 of input file and used it to query. Ex. file1.txt(number range) 9064500000 9064599999 9064600000 9064699999 9064700000 9064799999 Database name: ranges_log a_no message 9064500001 test 9064700000 ...

10. Shell Programming and Scripting

Need script to pass all sql file names in a directory to DB query

Hi All, In this path /home/all_files we have follwing files and direcotries proc_edf_sot.sql proc_ssc_sot.sql func_dfg_sot.sql sot unic cmr sdc under sot directory we have other directories sql pas ref under sql directory we have sql_sot sql_mat

LEARN ABOUT DEBIAN

elza

ELZA(1) 						      General Commands Manual							   ELZA(1)

NAME

       elza -- script language for automating HTTP requests

SYNOPSIS

       elza [scriptfile]

DESCRIPTION

       The elza is a scripting language aimed at automating requests on web pages.

       Scripts	written  in  elza  are capable of mimicking browser behavior almost perfectly, making it extremely difficult for remote servers to
       distinguish their activity from the activity generated by ordinary users and browsers. This gives those scripts the opportunity to act upon
       servers that will not respond to requests generated using netcat, gammaprog, rebol, or similar tool.

       This manual page was written for the Debian GNU/Linux distribution because the original program does not have a manual page.

OPTIONS

       scriptfile
		 The name and location of your script to be executed by elza.

       Variables are specified either in the .elz script, or in elza.def

AUTHOR

       This manual page was written by Stijn de Bekker stijn@debian.org for the Debian GNU/Linux system (but may be used by others).

       Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.1 or
       any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts and no Back-Cover	Texts.	 A
       copy of the license can be found under /usr/share/common-licenses/FDL.

FILES

       /etc/elza.def
		 Default values for various elza variables.

																	   ELZA(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Redirecting sql select query result to txt file

Discussion started by: dolphin123

2. UNIX for Dummies Questions & Answers

How do I use SQL to query based off file data?

Discussion started by: whoknows

3. Shell Programming and Scripting

redirecting sql query output to a file

Discussion started by: sailaja_80

4. Shell Programming and Scripting

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

Discussion started by: Nareshp