Hi,
I was trying to write a shell script which reads csv file and sends mail in html format along with tables. Hope i have completed 1st part , but while sending mail i was trying to highlight some rows in the table based on the egrep outcome. If the string exists in line/INPUT, i am trying to highlight it(row) with a different color. Tried if else condition with wc -l . but it didn't work. Below is my script . Please correct the script where i am doing wrong. Thanks in advance
i have got a file where the env command is appended 5 times. i have to now look for the username and display it in the form of
1) PWD=/home/lee.ballancore
2) USER=lee.ballancore
3) MAIL=/var/spool/mail/lee.ballancore
4) LOGNAME=lee.ballancore
5) HOME=/home/lee.ballancore
6)... (1 Reply)
How do I test the return condition in the script if no files are found:
for file in `Find ${LANDING_FILE_DIR}${BTIME_FILENAME_PATTERN}`
do
...
..
done
I want to capture the return code so I can echo the error or condition. Using if ] always returns zero no matter where it's placed.
... (4 Replies)
i have the equation like below
07:35:07 ( AB : 2319f.ab * 22) + ( AB : 2320f.ab * 22.03 ) + ( AB :2321f.ab * 22.07 ) ...... N
i want put ":" as a delimiter and break the equation like below
2319f.ab * 22
2320f.ab *22.03
2321f.ab * 22.07
.
.
N
i know the number of... (1 Reply)
Hi,
I am facing issues with test condition. I had a compound condition to write for both if and while,
In one of the texts i referred, with a korn shell we can write compound statements like: ], however this doesn't worked for me. For example:
if ] doesn't works, but
if || worked.
... (1 Reply)
Gurus,
I need to read a line from a file and strip the characters from it and compare the stripped value with the value I pass to the script while executing it. Below is the code for the same. But when i execute the code, it is throwing an error.
#!/bin/ksh
. /home/.i_env
... (14 Replies)
hi all,
i have a problem...no dream :-)
i want to scan a file i use the loop famous
while read line
do
do < myfile
but this scan must finish when find the another string .
How can i do it?
best regards for all.
Francesco
Please use descriptive subjects. "script." doesn't tell... (5 Replies)
hello,
I would like to do exit at the end ie list all errors before exiting
How to put the token exit in a variable with a loop ?
Thanks
function g1 () {
case "$1" in
(-0-0 | -0-1 | -0-2 | -0-3 | -1-0 | -1-1 | -1-2 | -1-3)
# nothing, OK !
;;
(*)
echo 'Fatal, $1 = '"'$1'"', Date... (9 Replies)
Hi,
I Have to check two condition in while loop every 2 minutes. while loop is accompanied with number of times it will check.Please help in putting the two condition in while loop as appropriate.
z= input value,
A=1
while
do
1.check the file output,if the file output is N then keep on... (2 Replies)
hi.,
As we know that using for-loop or while condition, we can only process one by one sequentially, but , lets say this example :
1. under the folder "logs" there are 1000 files
2. each file has one record or line
3. have to perform atleast 7 queries per 3 seconds ,for instance
... (3 Replies)
Discussion started by: alnhk
3 Replies
LEARN ABOUT PHP
oci_field_size
OCI_FIELD_SIZE(3)OCI_FIELD_SIZE(3)oci_field_size - Returns field's sizeSYNOPSIS
int oci_field_size (resource $statement, mixed $field)
DESCRIPTION
Returns the size of a $field.
PARAMETERS
o $statement
- A valid OCI statement identifier.
o $field
- Can be the field's index (1-based) or name.
RETURN VALUES
Returns the size of a $field in bytes, or FALSE on errors.
EXAMPLES
Example #1
oci_field_size(3) example
<?php
// Create the table with:
// CREATE TABLE mytab (number_col NUMBER, varchar2_col varchar2(1),
// clob_col CLOB, date_col DATE);
$conn = oci_connect("hr", "hrpwd", "localhost/XE");
if (!$conn) {
$m = oci_error();
trigger_error(htmlentities($m['message']), E_USER_ERROR);
}
$stid = oci_parse($conn, "SELECT * FROM mytab");
oci_execute($stid, OCI_DESCRIBE_ONLY); // Use OCI_DESCRIBE_ONLY if not fetching rows
echo "<table border="1">
";
echo "<tr>";
echo "<th>Name</th>";
echo "<th>Type</th>";
echo "<th>Length</th>";
echo "</tr>
";
$ncols = oci_num_fields($stid);
for ($i = 1; $i <= $ncols; $i++) {
$column_name = oci_field_name($stid, $i);
$column_type = oci_field_type($stid, $i);
$column_size = oci_field_size($stid, $i);
echo "<tr>";
echo "<td>$column_name</td>";
echo "<td>$column_type</td>";
echo "<td>$column_size</td>";
echo "</tr>
";
}
echo "</table>
";
// Outputs:
// Name Type Length
// NUMBER_COL NUMBER 22
// VARCHAR2_COL VARCHAR2 1
// CLOB_COL CLOB 4000
// DATE_COL DATE 7
oci_free_statement($stid);
oci_close($conn);
?>
NOTES
Note
In PHP versions before 5.0.0 you must use ocicolumnsize(3) instead. This name still can be used, it was left as alias of
oci_field_size(3) for downwards compatability. This, however, is deprecated and not recommended.
SEE ALSO oci_num_fields(3), oci_field_name(3).
PHP Documentation Group OCI_FIELD_SIZE(3)