|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
How to use select into command in shell script?
Post 302584142 by methyl on Thursday 22nd of December 2011 09:29:14 AM
12-22-2011
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
I have a shell script in which a string variable is saving following query.
SqlQuery="select a||'|'||b||'|'||c from dual"
I am trying to pass above query as a parameter to some script but its giving me error for "single quote". I tried suppressing it using \' instead of just ' but it... (1 Reply)
Discussion started by: mahabunta
1 Replies
2. Shell Programming and Scripting
Hi there
I have a database on a remote box and i have been using shell script to insert data into it for example, i could have a script that did this
SN=123456
n=server1
m=x4140
sql="UPDATE main SET hostname='$n',model='$m' WHERE serial='$SN';"
echo $sql |/usr/sfw/bin/mysql -h... (4 Replies)
Discussion started by: hcclnoodles
4 Replies
3. Shell Programming and Scripting
Hi,
I need to connect to the database and retrieve two variables from the database and store them in a variable,out of these two variables I need to get lastdigit appended to the variable 1 retrieved and variable 2 with out any modification
in short
select var,data from usage;
o/p=... (1 Reply)
Discussion started by: rkrish
1 Replies
4. Shell Programming and Scripting
Hi All,
bash-3.00$ gzgrep -i '\ ExecuteThread:' /******/******/******/******/stdout.log.txt.gz
<Jan 7, 2012 5:54:55 PM UTC> <Error> <WebLogicServer> <BEA-000337> < ExecuteThread: '414' for queue: 'weblogic.kernel.Default (self-tuning)' has been busy for "696" seconds working on the request... (4 Replies)
Discussion started by: osmanux
4 Replies
5. Shell Programming and Scripting
HI,
I want to connect to database and fetch the count from a table.
The sql query is as below :
select count(*) from table_test where test_column='read';
How can I print the output of this statement using shell script.
Thanks in advance. (4 Replies)
Discussion started by: confused_info
4 Replies
6. 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
7. Linux
Hi team,
I have two select statements and need to run them using SYSDBA user
select * from temp_temp_seg_usage;
select segment_name, tablespace_name, bytes/ (1024*1024) UsedMb from
dba_segments where segment_name='TEMP_TEMP_SEG_USAGE';
Need to run this using a shell script say named... (1 Reply)
Discussion started by: pamsy78
1 Replies
8. Shell Programming and Scripting
cd /opt/et/WAS/apps/8.0
find . -name "HostIntegration.properties" -o -name "HostSocket.properties" -o -name "environment.properties" 2> /dev/null | awk -F '' '{print $4}'|awk '!x++' | cat>/home/cbadmin/file1.txt
cd /home/cbadmin/
PS3='Please enter a number from list of applications==>:'
select... (3 Replies)
Discussion started by: bhas85
3 Replies
9. Shell Programming and Scripting
I have a text file in this format
Some lines....
Question no: 1
The question?
A. Answer 1
B. Answer 2
C. Answer 3
D. Answer 4
Answer:B
Some lines....
Question no: 2
The question? (choose 2) (10 Replies)
Discussion started by: zorrox
10 Replies
10. Shell Programming and Scripting
Hello,
I have script which work 70% of the desired task , the output from script.sh is following , however the desired output I require is following .
Any piece of suggestion would be great..
thanks in advance,
emily
#!/bin/bash ... (8 Replies)
Discussion started by: emily
8 Replies
LEARN ABOUT DEBIAN
roar_vs_iterate
roar_vs_iterate(3) RoarAudio Programmer's Manual roar_vs_iterate(3) NAME
roar_vs_iterate, roar_vs_run - Iterate streams SYNOPSIS
#include <roaraudio.h> int roar_vs_iterate (roar_vs_t * vss, int wait, int * error); int roar_vs_run (roar_vs_t * vss, int * error); DESCRIPTION
roar_vs_iterate() sends a block of data from the local buffer to the server or reads data from the server into the local buffer in blocking mode, or pushes or pulls data to or from server in file mode. roar_vs_run() does the same as roar_vs_iterate() but loops until EOF or error. PARAMETERS
vss The VS object to be used. wait If ROAR_VS_WAIT roar_vs_iterate() will block until data has been synced with the server. If ROAR_VS_NOWAIT roar_vs_iterate() will not block if no data can be send to or read from the server. error This is a pointer to a integer used to store the error value in case of error. This can be NULL if not used but it is very recom- mended to use this error value to report good error messages to the user. RETURN VALUE
On EOF these calls return 0. roar_vs_iterate() returns a positive value on non-EOF success. On error, -1 is returned. EXAMPLES
FIXME SEE ALSO
roarvs(7), libroar(7), RoarAudio(7). RoarAudio June 2011 roar_vs_iterate(3)