Really i should thanks for all your help to get fixed my isssues.
Once after this function_out() executed the next steps are not processed. I need to check the function return value. any idea whether writing a return value to text file is good or not.
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)
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)
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)
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)
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)
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)
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)
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)
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)
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
oci_fetch
OCI_FETCH(3)OCI_FETCH(3)oci_fetch - Fetches the next row from a query into internal buffersSYNOPSIS
bool oci_fetch (resource $statement)
DESCRIPTION
Fetches the next row from a query into internal buffers accessible either with oci_result(3), or by using variables previously defined
with oci_define_by_name(3).
See oci_fetch_array(3) for general information about fetching data.
PARAMETERS
o $statement
-A valid OCI8 statement identifier created by oci_parse(3) and executed by oci_execute(3), or a REF CURSOR statement identifier.
RETURN VALUES
Returns TRUE on success or FALSE if there are no more rows in the $statement.
EXAMPLES
Example #1
oci_fetch(3) with defined variables
<?php
$conn = oci_connect('hr', 'welcome', 'localhost/XE');
if (!$conn) {
$e = oci_error();
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}
$sql = 'SELECT location_id, city FROM locations WHERE location_id < 1200';
$stid = oci_parse($conn, $sql);
// The defines MUST be done before executing
oci_define_by_name($stid, 'LOCATION_ID', $locid);
oci_define_by_name($stid, 'CITY', $city);
oci_execute($stid);
// Each fetch populates the previously defined variables with the next row's data
while (oci_fetch($stid)) {
echo "Location id $locid is $city<br>
";
}
// Displays:
// Location id 1000 is Roma
// Location id 1100 is Venice
oci_free_statement($stid);
oci_close($conn);
?>
Example #2
oci_fetch(3) with oci_result(3)
<?php
$conn = oci_connect('hr', 'welcome', 'localhost/XE');
if (!$conn) {
$e = oci_error();
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}
$sql = 'SELECT location_id, city FROM locations WHERE location_id < 1200';
$stid = oci_parse($conn, $sql);
oci_execute($stid);
while (oci_fetch($stid)) {
echo oci_result($stid, 'LOCATION_ID') . " is ";
echo oci_result($stid, 'CITY') . "<br>
";
}
// Displays:
// 1000 is Roma
// 1100 is Venice
oci_free_statement($stid);
oci_close($conn);
?>
NOTES
Note
Will not return rows from Oracle Database 12 c Implicit Result Sets. Use oci_fetch_array(3) instead.
SEE ALSO oci_define_by_name(3), oci_fetch_all(3), oci_fetch_array(3), oci_fetch_assoc(3), oci_fetch_object(3), oci_fetch_row(3), oci_result(3).
PHP Documentation Group OCI_FETCH(3)