|
|
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 OPENSOLARIS
libgstreamer-0.10
libgstreamer-0.10(3) User Commands libgstreamer-0.10(3) NAME
libgstreamer-0.10, libgstbase-0.10 - GStreamer core library DESCRIPTION
libgstreamer-0.10 provides an API for all core GStreamer services, including initialization, plugin management and types, as well as the object hierarchy that defines elements and bins, along with some more specialized elements. To access the API documentation, you must install the developer version of the package. libgstbase-0.10 provides an API for GStreamer base plugins. These base plugins are typically extended when writing a plugin for a specific purpose. FILES
The following files are used by this library: /usr/lib/libgstreamer-0.10.so GStreamer shared library /usr/lib/libgstbase-0.10.so GStreamer base plugins library /usr/share/gtk-doc/html/gstreamer-0.10 GStreamer developer documentation /usr/share/gtk-doc/html/gstreamer-libs-0.10 GStreamer library developer documentation /usr/share/gtk-doc/html/gstreamer-plugins-0.10 GStreamer plugins developer documentation /usr/share/gtk-doc/html/gst-plugins-base-libs-0.10 GSTreamer base library developer documentation /usr/share/gtk-doc/html/gst-plugins-base-plugins-0.10 GStreamer base plugins developer documentation /usr/share/gtk-doc/html/gst-plugins-good-plugins-0.10 GStreamer good plugins developer documentation ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWgnome-media | +-----------------------------+-----------------------------+ |Interface stability |Volatile | +-----------------------------+-----------------------------+ SEE ALSO
gst-feedback(1), gst-inspect(1), gst-launch(1), gst-typefind(1), gst-xmlinspect(1), gst-xmllaunch(1), gstreamer-properties(1), attributes(5), gnome-interfaces(5), gst-std-options(5) NOTES
Written by Brian Cameron, Sun Microsystems Inc., 2004, 2006. SunOS 5.11 14 Oct 2004 libgstreamer-0.10(3)