|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX?
Post 302892654 by 24ajay on Friday 14th of March 2014 03:02:21 AM
03-14-2014
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
can nested SQl be run in Unix Script?
I tried some and found only simply sql(one select) can work well in unix script. (21 Replies)
Discussion started by: YoYo
21 Replies
2. Shell Programming and Scripting
Hi,
i would like to retrieve seql result and write it into unix text file like "result.txt"
In unix, normally, I type "sql" and get into sql,then type "select....." to run and get the result....then copy and paste into result.txt
any possible way to write a script to run it automatically?... (3 Replies)
Discussion started by: happyv
3 Replies
3. UNIX for Dummies Questions & Answers
Hi All,
I have written 4 sql queries . Now I want to write one SHELL SCRIPTING program for all these queries...
i.e
1.select * from head;
2. select * from detail;
3. delete from head;
4. delete from detail;
Please let me know how to write a shell script...
Thank you (1 Reply)
Discussion started by: user71408
1 Replies
4. Shell Programming and Scripting
Hi,
I have data in my text file something like this.
adams
robert
ahmed
gibbs
I want to use this data line by line as input to an sql query which i run by connecting to an oracle database from shell.
If you have code for similar scenario , please ehlp.
I want the output of the sql query... (7 Replies)
Discussion started by: rdhanek
7 Replies
5. Shell Programming and Scripting
Hi,
I have an input file which have many lines,from which i need to extract only the complete sql statements and write this alone to an output file.
please help us in this.
Regards
Meva (7 Replies)
Discussion started by: meva
7 Replies
6. Shell Programming and Scripting
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. Shell Programming and Scripting
Hi,
Would someone know if I can fire nested sql queries in a shell script? Basically what I am trying to do is as follows:
my_sql=$(sqlplus -s /nolog<<EOF|sed -e "s/Connected. *//g"
connect... (2 Replies)
Discussion started by: shrutihardas
2 Replies
8. Shell Programming and Scripting
Hi All,
I have the requirement in unix shell script.
I want to write the "ls -ltr" command out put to excel file as below.
Input :text file data :
drwxr-xr-x 5 root root 4096 Oct 2 12:26
drwxr-xr-x 2 apx aim 4096 Nov 29 18:40
drwxr-xr-x 5 root root 4096 Oct 2 12:26
drwxr-xr-x... (10 Replies)
Discussion started by: Balasankar
10 Replies
9. Shell Programming and Scripting
How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX? :confused: (1 Reply)
Discussion started by: 24ajay
1 Replies
10. Shell Programming and Scripting
I want to run sql query in shell script and output data save as delimited text (delimited text would be comma)
Code:
SPOOL_FILE=/pgedw/dan.txt
SQL=/pgedw/dan.sql
sqlplus -s username/password@myhost:port/servicename <<EOF
set head on
set COLSEP ,
set linesize 32767
SET TRIMSPOOL ON
SET... (8 Replies)
Discussion started by: Jaganjag
8 Replies
LEARN ABOUT DEBIAN
massxpert-data
MASSXPERT(7) Miscellaneous Information Manual MASSXPERT(7) NAME
massxpert-data - massXpert mass spectrometry software package (data files) DESCRIPTION
This manual page documents briefly the massxpert-data package. This package contains the architecture-independent data that are required for the proper functioning of the massxpert program (massxpert-bin package). The data contained in the package are about atom definition and for polymer chemistry definition (proteins, saccharides, DNA, RNA). BIBLIOGRAPHICAL REFERENCE TO BE CITED
F. Rusconi (2009) massXpert 2: a cross-platform software environment for polymer chemistry modelling and simulation/analysis of mass spec- trometric data. Bioinformatics, 25:2741-2742. doi:10.1093/bioinformatics/btp504. SEE ALSO
massxpert(1) massxpert-doc(7). The program is documented fully in the massXpert User Manual, that is packaged in massxpert-doc. That manual is available in the form of a PDF-formatted file (/usr/share/doc/massxpert-doc/pdf/massxpert.pdf). AUTHOR
This manual page was written by Filippo Rusconi <rusconi-debian@laposte.net>. Permission is granted to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 3, published by the Free Software Foundation. On a Debian system the complete text of the GNU General Public License version 3 can be found in the file `- /usr/share/common-licenses/GPL-3'. September 2009 MASSXPERT(7)