|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
unloading sql query to file
Post 16006 by Link_02 on Saturday 23rd of February 2002 12:18:11 PM
02-23-2002
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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... (1 Reply)
Discussion started by: dolphin123
1 Replies
2. UNIX for Dummies Questions & Answers
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... (4 Replies)
Discussion started by: whoknows
4 Replies
3. Shell Programming and Scripting
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... (1 Reply)
Discussion started by: sailaja_80
1 Replies
4. 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
5. UNIX for Advanced & Expert Users
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... (5 Replies)
Discussion started by: thepurple
5 Replies
6. Shell Programming and Scripting
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 Replies)
Discussion started by: Himanshu_soni
7 Replies
7. UNIX for Dummies Questions & Answers
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. (1 Reply)
Discussion started by: zozoo
1 Replies
8. Shell Programming and Scripting
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. (7 Replies)
Discussion started by: pamu
7 Replies
9. Shell Programming and Scripting
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 ... (7 Replies)
Discussion started by: znesotomayor
7 Replies
10. Shell Programming and Scripting
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 (6 Replies)
Discussion started by: ROCK_PLSQL
6 Replies
LEARN ABOUT CENTOS
osinfo-query
OSINFO-QUERY.C(1) Virtualization Support OSINFO-QUERY.C(1) NAME
osinfo-query - Query information in the database SYNOPSIS
osinfo-query [OPTIONS...] TYPE [CONDITION-1 [CONDITION-2 ...]] DESCRIPTION
The "osinfo-query" command allows extraction of information from the database. TYPE can be one of "os", "platform", "device", or "deployment". With no conditions specified, all entities of the given type will be listed. # List all operating systems $ osinfo-query os Short ID | Name ... ----------------------+----------- centos-6.0 | CentOS 6.0 ... centos-6.1 | CentOS 6.1 ... ... Conditions allow filtering based on specific properties of an entity. For example, to filter only distros from the Fedora Project, use # List all operating systems $ osinfo-query os vendor="Fedora Project" Short ID | Name ... ----------------------+-------------- fedora1 | Fedora Core 1 ... fedora2 | Fedora Core 2 ... ... The set of fields which are printed can be controlled using the "--fields" command line argument: # List all operating systems $ osinfo-query --fields=short-id,version os vendor="Fedora Project" Short ID | Version ----------------------+---------- fedora1 | 1 fedora2 | 2 ... OPTIONS
-s PROPERTY, --sort-key PROPERTY Set the data sorting key. Defaults sorting the first column -f PROPERTY1,PROPERTY2,..., --fields PROPERTY1,PROPERTY2,... Set the visibility of properties in output PROPERTY NAMES
OS Valid property names for the "os" type are: short-id The short OS identifier name The long OS name version The OS version string family The OS kernel family vendor The OS vendor release-date The OS release date eol-date The OS end-of-life date codename The OS code name id The OS identifier PLATFORM Valid property names for the "platform" type are: short-id The short platform identifier name The long platform name version The platform version string vendor The platform vendor release-date The platform release date eol-date The platform end-of-life date codename The platform code name id The platform identifier DEVICE Valid property names for the "device" type are: name The device name product The device product name product-id The device product ID string vendor The device vendor name vendor-id The device vendor ID string class The device type class bus The device bus type id The device identifier DEPLOYMENT Valid property names for the "deployment" type are: id The deployment identifier EXIT STATUS
The exit status will be 0 if matching entries were found, or 1 if not matches were found SEE ALSO
"osinfo-db-validate(1)", "osinfo-detect(1)" AUTHORS
Daniel P. Berrange <berrange@redhat.com> COPYRIGHT
Copyright (C) 2012 Red Hat, Inc. LICENSE
"osinfo-query" is distributed under the termsof the GNU LGPL v2+ license. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE libosinfo-0.2.7 2013-02-06 OSINFO-QUERY.C(1)