|
|
Sponsored Content
Top Forums
UNIX for Beginners Questions & Answers
Pass value from sqlplus to shell on AIX
Post 303037230 by tricampeon81 on Friday 26th of July 2019 11:38:53 AM
07-26-2019
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am trying to pass some of the variables in my shell scripts to the sqlplus call and use them as parameters.
For example, I would like to replace the 'SAS', and '20050612' with $var1 and $var2, respectively, how can I do that?
--------------------------------------------------------... (1 Reply)
Discussion started by: Jtrinh
1 Replies
2. Shell Programming and Scripting
Hi,
I am writing a ksh script which will use sqlplus to run a sql and pass 2 variables as the SQL request. In the ksh script, I have 2 variables which are $min_snap and $max_snap holding 2 different numbers.
Inside the same script, I am using SQLPLUS to run an Oracle SQL script,... (6 Replies)
Discussion started by: rwunwla
6 Replies
3. UNIX for Advanced & Expert Users
hi fellows,
can any body tell me how to pass unix variables to oracle
code is...
#! /bin/ksh
echo ENTER DATE VALUE's
read START_DATE END_DATE
sqlplus xyx/abc@oracle
select * from table1 where coloumn1 between $START_DATE and $END_DATE;
is this is correct way...........
Thanks in... (1 Reply)
Discussion started by: chiru
1 Replies
4. Shell Programming and Scripting
Hi,
Currently i have a .sql file 1.sql.
I need to pass that as a parameter through a shell script to the sqlplus inside the same shell script.
How I should I do.can anyone help me pls.
I have an req where I need to send the .sql file and the place where the script has to create a .csv... (9 Replies)
Discussion started by: Hemamalini
9 Replies
5. Shell Programming and Scripting
if
then
# mail -s "Import failed file does not exist" sanjay.jaiswal@xyz.com
echo "FILE does not exist"
exit 1
fi
echo "FILE EXIST"
size=-1
set $(du /export/home/oracle/nas/scott21.dmp.gz)
while
do
echo "Inside the loop"
size=$1
set $(du... (1 Reply)
Discussion started by: sanora600
1 Replies
6. Shell Programming and Scripting
I have a script that "runs" a script. For example:
./runscript.ksh pcnmc01.ksh
runscript puts pcnmc01.ksh into the background with log output going to the logfile.
After executing the command, I get this output:
Running script in the background: pcnmc01.ksh
Logfile:... (2 Replies)
Discussion started by: Eben Yong
2 Replies
7. Shell Programming and Scripting
Gurus,
The issue I'm having is that my Shell won't accept SQL parameters properly......
Here's they way I'm running it....
applmgr@ga006hds
=> sh CW_MigrationDeployScript.sh apps <appspwd> <SID> '01-JAN' '31-MAR'
The process just hangs not submitting the SQL job...
... (3 Replies)
Discussion started by: WhoDatWhoDer
3 Replies
8. Shell Programming and Scripting
echo "set echo off"; echo "set feedback off"; echo "set linesize 4000"; echo " set pagesize 0"; echo " set sqlprompt ''"; echo " set trimspool on";
Select statement is mentioned below
echo "select res.ti_book_no from disney_ticket_history res where res.ti_status =${STATUS} and... (7 Replies)
Discussion started by: aroragaurav.84
7 Replies
9. Programming
i have file in which i have employee id are there and every time number of employee id are different in file means number of count of employee id in file are every time different.
343535435
365765767
343534543
343543543
i want to pass this file to sqlplus
and sql command is
... (7 Replies)
Discussion started by: pallvi_mahajan
7 Replies
10. Shell Programming and Scripting
Hi Team,
I am trying to run a sqlplus script against several databases via a FOR/LOOP and also passing the loop variable to a sqlplus script I am calling, as follows:
#!/bin/bash
export ORACLE_SID=plgc1
export ORACLE_HOME=/opt/oracle/product/11.2.0.2/db_1
export... (1 Reply)
Discussion started by: jonnyd
1 Replies
LEARN ABOUT DEBIAN
ost_time
ost::Time(3) Library Functions Manual ost::Time(3) NAME
ost::Time - The Time class uses a integer representation of the current time. SYNOPSIS
#include <numbers.h> Inherited by ost::Datetime. Public Member Functions Time (time_t tm) Time (tm *dt) Time (char *str, size_t size=0) Time (int hour, int minute, int second) Time () virtual ~Time () long getValue (void) const int getHour (void) const int getMinute (void) const int getSecond (void) const char * getTime (char *buffer) const time_t getTime (void) const tm * getTime (tm *buf) const void setTime (char *str, size_t size=0) bool isValid (void) const operator long () String operator() () const Time & operator++ () Time & operator-- () Time & operator+= (const int val) Time & operator-= (const int val) int operator== (const Time &time) int operator!= (const Time &time) int operator< (const Time &time) int operator<= (const Time &time) int operator> (const Time &time) int operator>= (const Time &time) bool operator! () const Protected Member Functions void toSeconds (int hour, int minute, int second) void fromSeconds (char *buf) const virtual void update (void) Protected Attributes long seconds Friends Time operator+ (const Time &time1, const Time &time2) Time operator- (const Time &time1, const Time &time2) Time operator+ (const Time &time, const int val) Time operator- (const Time &time, const int val) Time operator+ (const int val, const Time &time) Time operator- (const int val, const Time &time) Detailed Description The Time class uses a integer representation of the current time. This is then manipulated in several forms and may be exported as needed. Author: Marcelo Dalmas mad@brasmap.com.br Integer based time class. Constructor &; Destructor Documentation ost::Time::Time (time_ttm) ost::Time::Time (tm *dt) ost::Time::Time (char *str, size_tsize = 0) ost::Time::Time (inthour, intminute, intsecond) ost::Time::Time () virtual ost::Time::~Time () [virtual] Member Function Documentation void ost::Time::fromSeconds (char *buf) const [protected] int ost::Time::getHour (void) const int ost::Time::getMinute (void) const int ost::Time::getSecond (void) const char* ost::Time::getTime (char *buffer) const time_t ost::Time::getTime (void) const tm* ost::Time::getTime (tm *buf) const long ost::Time::getValue (void) const bool ost::Time::isValid (void) const Reimplemented in ost::Datetime. ost::Time::operator long () [inline] bool ost::Time::operator! (void) const [inline] Reimplemented in ost::Datetime. int ost::Time::operator!= (const Time &time) String ost::Time::operator() () const Time& ost::Time::operator++ () Time& ost::Time::operator+= (const intval) Time& ost::Time::operator-- () Time& ost::Time::operator-= (const intval) int ost::Time::operator< (const Time &time) int ost::Time::operator<= (const Time &time) int ost::Time::operator== (const Time &time) int ost::Time::operator> (const Time &time) int ost::Time::operator>= (const Time &time) void ost::Time::setTime (char *str, size_tsize = 0) void ost::Time::toSeconds (inthour, intminute, intsecond) [protected] virtual void ost::Time::update (void) [protected], [virtual] Friends And Related Function Documentation Time operator+ (const Time &time1, const Time &time2) [friend] Time operator+ (const Time &time, const intval) [friend] Time operator+ (const intval, const Time &time) [friend] Time operator- (const Time &time1, const Time &time2) [friend] Time operator- (const Time &time, const intval) [friend] Time operator- (const intval, const Time &time) [friend] Member Data Documentation long ost::Time::seconds [protected] Author Generated automatically by Doxygen for GNU CommonC++ from the source code. GNU CommonC++ Sat Jun 23 2012 ost::Time(3)