Hello,
I have a situation where I have filenames with timestamps like
abc20060509452313.txt
i need the most recent file, and i am using this command in the script:
recent_file=`ls ${Location}/$file*| head -1`
where $Location is the directory and $file is the base filename like abc.
When i... (2 Replies)
Hi All,
I am new to unix,please help me on the following its urgent
I have 2 question
1 question
I need a script for following senario
I have get some files in directory by using grep
i need to sort all files to new files for example (abc.dat --> abc.dat.sort)
ex:grep *050508* ... (3 Replies)
I have a directory called test, which contains multiple sub directories namely TF80A, TF80B, TF80C.
I need to sort these directories by name, so in the above case TF80A Is the oldest and TF80C is the latest.
Is there a ksh script that would loop through the directories and sort these... (1 Reply)
Hi,
I have a datahash with 'n' number of values in perl script. I am writing a xml file from the datahash. I am getting output with sorting(Field sorting). My question is that i don't want any default sorting.whatever i am inserting into datahash it should give same xml file.
Any help?
... (0 Replies)
Hi I am trying to get a bourne shell script to sort a file for me. Here is what i currently have:
#/bin/sh
echo "Name Exam1 Exam2 Exam3 Total Grade" > final.txt
awk -f 9.awk grades.txt | sort +4 -5 >> final.txt
#BEGIN {printf "Name\tExam1\tExam2\tExam3\tTotal\tGrade";}
{
... (12 Replies)
I want to sort like below
Suppose few lines in a file is like this
systemid:ABC messagedestination:batchxpr replytoqname: myca
systemid:BCD messagedestination:realtime replytoqname: myca
systemid:ABC messagedestination:realtime replytoqname: eac
systemid: BCD messagedestination:mqonline... (1 Reply)
the thing which i require is very very complex.. i tried hard to find the solution but couldnt..
the thing i need to achieve is say i have a file
cat delta.sql
CREATE VIEW Austin
Etc etc
.
.
.
CREATE VIEW Barabara
AS
SELECT blah blah blah
FROM Austin z, Cluster s, Instance i
WHERE... (4 Replies)
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
You will write a script that will read a tab-separated file that contains the names of all 50 states &... (7 Replies)
Hi,
I have the following list:
42A
42AA
42B
42BB
42AAA
42BBB
49A
49AA
49B
49AAA
49BB
I need it to be sorted as following:
42A
42B (2 Replies)
Discussion started by: sairamtejaswi
2 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)