Here for a particular job the table name and the corresponding instance name from one test run "X" is compared with the table name and the instance name from the second test run "Y" for output rows,affected rows,applied rows and rejected rows. The mismatching rows should be displayed in the format said above. If one table and a instance is present in either of the test runs then the format should be
Quote:
2,TAG,TYA,0,0,0,0,,,,,
Quote:
1,ABC,ABNC1,1085,1085,1085,0,1082,1082,1082,0
here 1 is the job name,ABC is the table name,ABNC1 is the instance name,"1085,1085,1085,0" are the values for output rows,affected rows,applied rows,rejected rows from X testrun and "1082,1082,1082,0" are the values for output rows,affected rows,applied rows,rejected rows from Y testrun.
Hi all,
Have the following code(1) producing the results(2 & 3).
Would like to know if there is a way to format the two reports created in a similar fashion.
IE - The first is formatted nicely as a result of the echo "$xmpbdate $xavgs" >> $xmpbrpt
However when I attempt to do the same on... (7 Replies)
Hi need some advice..
#grep -i hostname test.csv
(gives the below output)
HOSTNAME,name,host_test,,,,,,,,
Now I need to format the above output as below.
HOSTNAME:
name=host_test
Any easy way of doing this using awk or sed or printf? (4 Replies)
Hi
I tried running the below
awk 'BEGIN { printf ("%s %-51s %s %-7s %s",$var1,$var2,$var3,$var4,$var5)}'
from the command prompt and it is not working.
Getting the error
awk: Field $() is not correct.
The source line number is 1.
Actually my requirement is to form a string based on... (6 Replies)
Ok, for a fun project, my goal is to replicate the style of "catalog" on an old apple ]
*A 002 SOMEAPPLESOFTFILE
B 004 SOMEFILE
T 006 SOMETEXT
I 002 SOMEINTEGERFILE
The first character is either " " or "*" depending on if the file is locked or not.
Next is the filetype, so in... (1 Reply)
I am using find and ls to search for "warez" files on my server.
find /home/ -regex ".*\.\(avi\|mp3\|mpeg\|mpg\|iso\)" -print0 | xargs -0 ls -oh
This command produces this:
-rw-r--r-- 1 1000 3.2M Feb 18 2009 /home/user/public_html/lupus.mp3
I want to only get this
3.2M... (4 Replies)
Sorry for being a n00b, but I'm having a lot more trouble than I should with formatting the output to the program I finally completed. I'm basically looking for the linux equivalent to setw( ) from c++ so that I can print things in columns like this (but without the underlines lol):
MISSPELLED: ... (4 Replies)
Hi Experts,
I have to create a report for certain audit and my output looks as follows
I m trying to format my output to look like
Any inputs would be highly appreciated
Thanks
Syed (5 Replies)
Hi Guys
I need help removing some lines from output i am receiving from a shell script.
Here is the output:
http://i52.tinypic.com/10z0fut.png
I am trying to remove the output that i have circled.
. ${EDW}/extracts/bin/extracts_setup2.sh
. ${EDW}/extracts/extracts.conf
... (7 Replies)
Hi,
I have a file which contents entries in this form.
Only in /data4/temp abc.000001
Only in /data4/temp abc.000003
Only in /data4/temp abc.000012
Only in /data4/temp abc.000120
Only in /data4/temp abc.000133
Only in /data4/temp abc.001444
i want to read line by line and format... (2 Replies)
Hi,
I am trying to use printf command and format certain output in a specific format as under:
While the left side (upto |) of the above format is part of a fixed header function, the right side is where i am expecting data to be printed. However, as seen, Row1 value is reflecting on last... (5 Replies)
Discussion started by: EmbedUX
5 Replies
LEARN ABOUT PHP
oci_num_rows
OCI_NUM_ROWS(3)OCI_NUM_ROWS(3)oci_num_rows - Returns number of rows affected during statement executionSYNOPSIS
int oci_num_rows (resource $statement)
DESCRIPTION
Gets the number of rows affected during statement execution.
PARAMETERS
o $statement
- A valid OCI statement identifier.
RETURN VALUES
Returns the number of rows affected as an integer, or FALSE on errors.
EXAMPLES
Example #1
oci_num_rows(3) example
<?php
$conn = oci_connect("hr", "hrpwd", "localhost/XE");
if (!$conn) {
$m = oci_error();
trigger_error(htmlentities($m['message']), E_USER_ERROR);
}
$stid = oci_parse($conn, "create table emp2 as select * from employees");
oci_execute($stid);
echo oci_num_rows($stid) . " rows inserted.<br />
";
oci_free_statement($stid);
$stid = oci_parse($conn, "delete from emp2");
oci_execute($stid, OCI_DEFAULT);
echo oci_num_rows($stid) . " rows deleted.<br />
";
oci_commit($conn);
oci_free_statement($stid);
$stid = oci_parse($conn, "drop table emp2");
oci_execute($stid);
oci_free_statement($stid);
oci_close($conn);
?>
NOTES
Note
This function does not return number of rows selected! For SELECT statements this function will return the number of rows, that
were fetched to the buffer with oci_fetch*(3) functions.
Note
In PHP versions before 5.0.0 you must use ocirowcount(3) instead. This name still can be used, it was left as alias of
oci_num_rows(3) for downwards compatability. This, however, is deprecated and not recommended.
PHP Documentation Group OCI_NUM_ROWS(3)