07-29-2015
Yes, agree with RudiC.
Hello Arun,
Please take sqlplus's output into a file. Then you can get value from there into a variable then you can easily use if condition to check it's value and execute the next appropriate query. This all can be done within a single script. Kindly try the same and let us know what issue you face or successful outputs.
Thanks,
R. Singh
Last edited by RavinderSingh13; 07-29-2015 at 07:11 AM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Here is my test.in file
Case Modify 10001 20002 30003 40004|Report Create 3417176211|Case Modify 10002 20002 30003 40004|
Script:
Remove.ksh
This script to remove $1 which I type in:
$ cat test.in
Case Modify 10001 20002 30003 40004|Report Create 3417176211|Case Modify 10002 20002 30003... (0 Replies)
Discussion started by: sabercats
0 Replies
2. Shell Programming and Scripting
Hi
I am trying to create a modify a txt file via a sh script and I'm not sure how to do it.
I have this:
data1a#data2a#data3aµ data1b#data2b#data3bµ data1c#data2c#data3cµ
and I want to have this (more or less)
data1a data2a data3a
data1b data2b data3b
data1c data2c data3c
I know... (5 Replies)
Discussion started by: Morgwen
5 Replies
3. Shell Programming and Scripting
Hi all, I have a basic doubt. Is there any way to use external
functions (i.e. functions not defined in AWK), in AWK.
I have a shell script in which I'm using a AWK snippet. In this
snippet I'm calling a function defined in the shell script. But the AWK
snippet is not working. I figured that... (5 Replies)
Discussion started by: kamel.seg
5 Replies
4. Shell Programming and Scripting
Hello,
Can someone pls help me with some statistical calculation in awk
In excel there is a statistical function called "Mode".
How Mode works:
MODE returns the most frequently occurring, or repetitive, value in array or range.
Eg if we have 5 numbers in 5 different columns... (12 Replies)
Discussion started by: Needhelp2
12 Replies
5. Shell Programming and Scripting
Actually I got a list of file end with *.txt
I want to use the same command apply to all the *.txt
Thus I try to find out the fastest way to write those same command in a script and then want to let them run automatics.
For example:
I got the file below:
file1.txt
file2.txt
file3.txt... (4 Replies)
Discussion started by: patrick87
4 Replies
6. Shell Programming and Scripting
Hi, I would like to know what is the correct syntax to perform a function in awk. Although I have seen several examples, not get it to work, this is what I'm trying:
#!/bin/bash
awk
function multi (number) {
return number * 3
}
print multi (4)Thanks (2 Replies)
Discussion started by: Godie
2 Replies
7. Shell Programming and Scripting
Hi,
I have file with below format and sample data - File is pipe delimited
Col1|col2|Account|Bal1|Bal2
1|2|1|10|5
1|2|2|10|2
1|3|3|10|3
I want output as
SUM|1|2|2|20|7
SUM|1|3|1|10|3
Can anyone give me awk command (4 Replies)
Discussion started by: sanranad
4 Replies
8. Shell Programming and Scripting
Hi all,
I need to have informations in a URL :
https://www.autolib.eu/stations/
Valors I need are in bold:
{"charging_status": "nonexistent", "rental_status": "future", "subscription_status": "nonexistent", "station_id": 791, "address": "10 rue de Rome, 93110 Rosny-sous-Bois", "lat":... (3 Replies)
Discussion started by: roulitto
3 Replies
9. Shell Programming and Scripting
Hello Friends,
I have written a script like below,
I aimed to move some CDR files (call data record) whose the last field is "1" (NF=1 ) from a spesific directory to a new directory
Field Seperator is pipe.
If the directory does not exitst i should create it.
I will give the script two... (5 Replies)
Discussion started by: EAGL€
5 Replies
10. Shell Programming and Scripting
Hi,
I am having script which contains many functions. Need to print each function name at the starting of the function. Like below,
functionname()
{
echo "functionname"
commands....
}
I've tried like below,
func=`grep "()" scriptname | cut -d "(" -f1`
for i in $func
do
nawk -v... (4 Replies)
Discussion started by: Sumanthsv
4 Replies
LEARN ABOUT PHP
pdo.query
PDO.QUERY(3) 1 PDO.QUERY(3)
PDO
::query - Executes an SQL statement, returning a result set as a PDOStatement object
SYNOPSIS
public PDOStatement PDO::query (string $statement)
DESCRIPTION
PDOStatement PDO::query (string $statement, int $PDO::FETCH_COLUMN, int $colno) PDOStatement PDO::query (string $statement, int
$PDO::FETCH_CLASS, string $classname, array $ctorargs) PDOStatement PDO::query (string $statement, int $PDO::FETCH_INTO, object
$object)
PDO.query(3) executes an SQL statement in a single function call, returning the result set (if any) returned by the statement as a
PDOStatement object.
For a query that you need to issue multiple times, you will realize better performance if you prepare a PDOStatement object using PDO.pre-
pare(3) and issue the statement with multiple calls to PDOStatement.execute(3).
If you do not fetch all of the data in a result set before issuing your next call to PDO.query(3), your call may fail. Call PDOState-
ment.closeCursor(3) to release the database resources associated with the PDOStatement object before issuing your next call to
PDO.query(3).
Note
Although this function is only documented as having a single parameter, you may pass additional arguments to this function. They
will be treated as though you called PDOStatement.setFetchMode(3) on the resultant statement object.
PARAMETERS
o $statement
- The SQL statement to prepare and execute. Data inside the query should be properly escaped.
RETURN VALUES
PDO.query(3) returns a PDOStatement object, or FALSE on failure.
EXAMPLES
Example #1
Demonstrate PDO::query
A nice feature of PDO.query(3) is that it enables you to iterate over the rowset returned by a successfully executed SELECT state-
ment.
<?php
function getFruit($conn) {
$sql = 'SELECT name, color, calories FROM fruit ORDER BY name';
foreach ($conn->query($sql) as $row) {
print $row['name'] . " ";
print $row['color'] . " ";
print $row['calories'] . "
";
}
}
?>
The above example will output:
apple red 150
banana yellow 250
kiwi brown 75
lemon yellow 25
orange orange 300
pear green 150
watermelon pink 90
SEE ALSO
PDO.exec(3), PDO.prepare(3), PDOStatement.execute(3).
PHP Documentation Group PDO.QUERY(3)