|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
How to pass variable to a query?
Post 302947468 by cero on Thursday 18th of June 2015 07:39:28 AM
06-18-2015
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Can any one help me how to pass the value of result of one query to another query.
I to pass the value of result of 'select max(id) from a' into another query
like
update table
set col =<value from last query>
where ....;
updatestaging()
{
xx=`$ORACLE_HOME/bin/sqlplus -s... (1 Reply)
Discussion started by: u263066
1 Replies
2. Shell Programming and Scripting
I would like to use the result of a query in another query. How do I redirect/add the output to another variable?
$result = odbc_exec($connect, $query);
while ($row = odbc_fetch_array($result)) {
echo $row,"\n";
}
odbc_close($connect);
?>
This will output hostnames:
host1... (0 Replies)
Discussion started by: hazno
0 Replies
3. Programming
Below i have the sample code. i need to pass the entire query from file or as parameter and read the results and write into a output file.
here the number of columns are unknown. some times it may be 2,3 or entire columns from the table.
read all the column results and write into a comma... (0 Replies)
Discussion started by: laknar
0 Replies
4. Shell Programming and Scripting
Hello again :)
Am currently trying to write a function which will delete a record from a file.
The code currently looks as such:
function deleteRecord() {
clear
read -p "Please enter the ID of the record you wish to remove: " strID
... (2 Replies)
Discussion started by: U_C_Dispatj
2 Replies
5. Red Hat
Hi all,
Hereby wish to have your advise for below:
Main concept is
I intend to get current directory of my script file.
This script file will be copied to /etc/init.d.
A string in this copy will be replaced with current directory value.
Below is original script file:
... (6 Replies)
Discussion started by: cielle
6 Replies
6. 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
7. 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
8. Shell Programming and Scripting
Hi Gurus,
I have a request which needs to pass string into sql.
dummy code as below:
sqlplus -s user/password@instance << EOF >>output.txt
set echo off head off feed off pagesize 0 trimspool on linesize 1000 colsep ,
select emp_no, emp_name from emp
where emp_no in ('a', 'b', 'c');
exit;... (4 Replies)
Discussion started by: ken6503
4 Replies
9. 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
10. UNIX for Beginners Questions & Answers
Hello All,
Hope you're doing well !
I am trying below command to be passed in a shell script, header_date_14 is a variable and $1 is the name of a file I intend to pass as a command line argument, however command line argument is not being accepted.
header_date_14=$(m_dump... (8 Replies)
Discussion started by: ektubbe
8 Replies
LEARN ABOUT DEBIAN
ost_date
ost::Date(3) Library Functions Manual ost::Date(3) NAME
ost::Date - The Date class uses a julian date representation of the current year, month, and day. SYNOPSIS
#include <numbers.h> Inherited by ost::DateNumber, and ost::Datetime. Public Member Functions Date (time_t tm) Date (tm *dt) Date (char *str, size_t size=0) Date (int year, unsigned month, unsigned day) Date () virtual ~Date () int getYear (void) const unsigned getMonth (void) const unsigned getDay (void) const unsigned getDayOfWeek (void) const char * getDate (char *buffer) const time_t getDate (void) const time_t getDate (tm *buf) const long getValue (void) const void setDate (const char *str, size_t size=0) bool isValid (void) const operator long () const String operator() () const Date & operator++ () Date & operator-- () Date & operator+= (const long val) Date & operator-= (const long val) int operator== (const Date &date) int operator!= (const Date &date) int operator< (const Date &date) int operator<= (const Date &date) int operator> (const Date &date) int operator>= (const Date &date) bool operator! () const Protected Member Functions void toJulian (long year, long month, long day) void fromJulian (char *buf) const virtual void update (void) A method to use to 'post' any changed values when shadowing a mixed object class. Protected Attributes long julian Friends Date operator+ (const Date &date, const long val) Date operator- (const Date &date, const long val) Date operator+ (const long val, const Date &date) Date operator- (const long val, const Date &date) Detailed Description The Date class uses a julian date representation of the current year, month, and day. This is then manipulated in several forms and may be exported as needed. Author: David Sugar dyfet@ostel.com julian number based date class. Constructor &; Destructor Documentation ost::Date::Date (time_ttm) ost::Date::Date (tm *dt) ost::Date::Date (char *str, size_tsize = 0) ost::Date::Date (intyear, unsignedmonth, unsignedday) ost::Date::Date () virtual ost::Date::~Date () [virtual] Member Function Documentation void ost::Date::fromJulian (char *buf) const [protected] char* ost::Date::getDate (char *buffer) const time_t ost::Date::getDate (void) const time_t ost::Date::getDate (tm *buf) const unsigned ost::Date::getDay (void) const unsigned ost::Date::getDayOfWeek (void) const unsigned ost::Date::getMonth (void) const long ost::Date::getValue (void) const int ost::Date::getYear (void) const bool ost::Date::isValid (void) const Reimplemented in ost::Datetime. ost::Date::operator long () const [inline] bool ost::Date::operator! (void) const [inline] Reimplemented in ost::Datetime. int ost::Date::operator!= (const Date &date) String ost::Date::operator() () const Date& ost::Date::operator++ () Date& ost::Date::operator+= (const longval) Date& ost::Date::operator-- () Date& ost::Date::operator-= (const longval) int ost::Date::operator< (const Date &date) int ost::Date::operator<= (const Date &date) int ost::Date::operator== (const Date &date) int ost::Date::operator> (const Date &date) int ost::Date::operator>= (const Date &date) void ost::Date::setDate (const char *str, size_tsize = 0) void ost::Date::toJulian (longyear, longmonth, longday) [protected] virtual void ost::Date::update (void) [protected], [virtual] A method to use to 'post' any changed values when shadowing a mixed object class. This is used by DateNumber. Reimplemented in ost::DateNumber. Friends And Related Function Documentation Date operator+ (const Date &date, const longval) [friend] Date operator+ (const longval, const Date &date) [friend] Date operator- (const Date &date, const longval) [friend] Date operator- (const longval, const Date &date) [friend] Member Data Documentation long ost::Date::julian [protected] Author Generated automatically by Doxygen for GNU CommonC++ from the source code. GNU CommonC++ Sat Jun 23 2012 ost::Date(3)