#!/bin/bash
suc_num=`$PATH/sqlplus -s xx/yyy@service_name << !
set echo off
set feedback off
set heading off
set pagesize 0
set newpage 0
set wrap on
@success.sql
commit;
exit;
!`
echo $suc_num
=====================================================
Result: (Should have 3 columns: DateTime[yyyy-mm-dd hh]|The Number|ElementName)
=====================================================
How do I create a K Shell which would silently (without user input) logon to Oracle and
run an SQL script?
Any help will be greatly appreciated.
Steve (1 Reply)
hi Friends,
Please help me in writing shell script to run list of sql files.
database is Oracle 9i,
unix os is solaris
Requirement is
1. sql file must take two inputs a)feed id and b)business date
2.shell script must out put .xls or .csvfile as out put without trimming any column name and... (1 Reply)
Hello,
If I run this command on the server it works.
# dbc "update config set radio_enabled = 0;"
how can I execute the same command in perl. I have defined the dbc path. Can any one please correct the last line.
#!/usr/bin/perl
#database path
$dbc='/opt/bin/psql -Userver... (0 Replies)
Hello,
I want to connect to ssh, run a query, and store that into a variable in the shell script. Also I need to pass the variable back to php to display the query results.
I have created a public/private key pair for ssh connection and that is working fine. Also I am able to run query in the... (8 Replies)
I need to run sql script from shell script which takes the input from a file and contents of file will be like :
12345
34567
78657
and query will be like :
select seq_nbr from bus_event where event_nbr='12345';
select seq_nbr from bus_event where event_nbr='34567';
select seq_nbr... (1 Reply)
I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this?
Is there a way to have a persistent connection to oracle database... (9 Replies)
Hi,
I have a query regarding execution of a sql query having long listing of parameters ..I need to execute this query inside a shell script.
The scenario is like....
Suppose I have a file abc.txt that has the card numbers..it could be in thousands..
then I need to fire a query like
... (12 Replies)
I am running this test.ksh on server1. It successfully logins to server2 but runs the queries of query.sql on server1. query.sql is present in both server1 and server2
Can anybody please help.
I need to run queries on server2 itself.:confused:
Below is the test script... (10 Replies)
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
latd.conf
LATD.CONF(5) File Formats Manual LATD.CONF(5)NAME
latd.conf - LAT configuration file
SYNOPSIS
/etc/latd.conf
DESCRIPTION
/etc/latd.conf is a shell script (run by /bin/sh) that is run when latd is started up using the latcp -s command.
It contains commands used to customise lat for your site and usually consists of a list of latcp commands.
latd.conf is run with a minimal PATH and a minimal environment. The variable $LATCP points to the latcp binary used to invoke the script.
EXAMPLE
# /etc/latd.conf
# This is a sample configuration file for latd
# it is run as s shell script from latcp -s with a minimal
# environment and PATH. latcp should be invoked using the
# environment variable $LATCP.
#
# You can fiddle with all the latd parameters you like in here,
# the first service announcement will not be made until this
# script completes.
#
# Set the multicast timeout to 30 seconds
$LATCP -m 30
# Add another login service
$LATCP -A -a ZAPHOD -r 100
# Add a queued reverse LAT service to a printer on a DECserver
$LATCP -A -p /dev/lat/printer -Hdecserver -Vdecserver -Q
# Only advertise our service in groups 1-10 and 200
$LATCP -G 1-10,200
exit
SEE ALSO
latcp(8), latd(8)LAT Server June 2 2000 LATD.CONF(5)
06-18-2012
