9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
we have requirement, i am created a shell script , inside i am connecting sqlplus and execute the query. below my code for your reference.
get_sqlid ()
{
sqlid=$(
sqlplus -s $PBDW_USERID/$PBDW_PW@$PBDW_SID <<EOF
DEFINE TBLNAME=$1
set feedback off
set serverout on size... (4 Replies)
Discussion started by: KK230689
4 Replies
2. Shell Programming and Scripting
cat << EOF | telnet alt1.aspmx.l.google.com 25
HELO verify-email.org
MAIL FROM: <check@verify-email.org>
RCPT TO: <test@gmail.com>
quit
EOF
Hello, I'm trying to get the result of that execution, and can not see the result or bring it to a txt ... the direct command in ssh running the result... (5 Replies)
Discussion started by: c0i0t3
5 Replies
3. Shell Programming and Scripting
i am using bash shell
Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127.
IFS=","
declare -a Arr=($Variable1);
SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE}
echo "set head off ; " > ${SQLCMD}
echo "set PAGESIZE 0 ;" >> ${SQLCMD}... (6 Replies)
Discussion started by: arghadeep adity
6 Replies
4. Shell Programming and Scripting
I am new in shell script i want to convert .txt file
in the format axsjdijdjjdk to
a
x
s
j
d
i
j
d
j
j
d
k (5 Replies)
Discussion started by: sreejithalokkan
5 Replies
5. Shell Programming and Scripting
hi all,
i need the shell script for he below requirement
i had the input file as
a_20121217_035120( frmat is a_date_hhmmss)
a_20121217_035128
a_20121217_035456
a_20121217_035767
a_20121217_035178
a_20121217_035189
a_20121217_035220
my output should be
a_20121217_035456... (0 Replies)
Discussion started by: hemanthsaikumar
0 Replies
6. Shell Programming and Scripting
Hello everyone,
I have a RHEL 5 system and have been trying to get a batch of 3-4 scripts each in a separate variables and they are not working as expected.
I tried using following syntax which I saw a lot of people on this site use and should really work, though for some reason it doesn't... (3 Replies)
Discussion started by: rockf1bull
3 Replies
7. Shell Programming and Scripting
Hello. I am a novince at writing shell scripts but here is the question. I have to write a shell script that does the following:
Once executed via crontab, the script should do the following:
a. get date/time stamp in for format 10-MAR-05 and
b. execute shell script my_script.sh (which... (2 Replies)
Discussion started by: jigarlakhani
2 Replies
8. UNIX for Advanced & Expert Users
Can I do something like this from a shellscript ?:
ftp 12.34.56.78 <<!
username
password
put a.c
bye
!
It does not go through as the login fails.
Is there any alternative to do the above requirement?
Thanks in advance.
Gowrish (3 Replies)
Discussion started by: ggowrish
3 Replies
9. Shell Programming and Scripting
I am new to UNIX.
I got the file from Oracle, with
two columns (Table Name and Column Name). I need to create the shell script where the result suppose to include
plain text, <table_name>, <Column_name> from the file.
Plain text will be the statements to create index in Oracle.
something like... (1 Reply)
Discussion started by: newuser100
1 Replies
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)