03-04-2009
Quote:
field is varchar2, length is 5, can be from '00001' to '99999'.
Sounds very oracle to me...
I though I knew a little unix, reading this post makes me doubt...
What do you call expression?
Is it a simple test condition you are looking for?
10 More Discussions You Might Find Interesting
1. Programming
How do I use the regular expressions in c++? (2 Replies)
Discussion started by: szzz
2 Replies
2. Shell Programming and Scripting
How can i create a regular expression which can detect a new line charcter followed by a special character say * and replace these both by a string of zero length?
Eg:
Input File san.txt
hello
hi ... (6 Replies)
Discussion started by: sandeep_hi
6 Replies
3. Shell Programming and Scripting
Hi gurus,
Can any of you suggest any good link for going through tagged regular expressions for unix.I am finding it quite critical and need some help from all gurus to know this better.
Any good link containing detailed examples with descriptions would do i guess.
thanks in advance. (0 Replies)
Discussion started by: navojit dutta
0 Replies
4. UNIX for Dummies Questions & Answers
how to find for a file whose name has all characters in uppercase after 'project'?
I tried this:
find . -name 'project**.pdf'
./projectABC.pdf
./projectABC123.pdf
I want only ./projectABC.pdf
What is the regular expression that correponds to "all characters are capital"?
thanks (8 Replies)
Discussion started by: melanie_pfefer
8 Replies
5. Shell Programming and Scripting
Hi,
In ksh, I am trying to compare folder names having -141- in it's name.
e.g.: 4567-141-8098 should match this expression '*-141-*'
but, -141-2354 should fail when compared with '*-141-*'
simlarly, abc should fail when compared with '*-141-*'
I tried multiple things but nevertheless,... (5 Replies)
Discussion started by: jidsh
5 Replies
6. UNIX for Dummies Questions & Answers
In regular expressions with grep(or egrep), ^ works if we want something in starting of line..but what if we write ^^^ or ^ for pattern matching??..Hope u all r familiar with regular expressions for pattern matching.. (1 Reply)
Discussion started by: aadi_uni
1 Replies
7. Shell Programming and Scripting
#!/usr/bin/perl
$word = "one last challenge";
if ( $word =~ /^(\w+).*\s(\w+)$/ )
{
print "$1";
print "\n";
print "$2";
}
The output shows that "$1" is with result one and "$2" is with result challenge. I am confused about how this pattern match expression works step by step. I... (8 Replies)
Discussion started by: DavidHe
8 Replies
8. Shell Programming and Scripting
I have a file that I'm trying to find all the cases of phone number extensions and deleting them. So input file looks like:
abc
x93825
def
13234
x52673
hello
output looks like:
abc
def
13234
hello
Basically delete lines that have 5 numbers following "x". I tried: x\(4) but it... (7 Replies)
Discussion started by: pxalpine
7 Replies
9. Shell Programming and Scripting
when I use
Input command | awk '$2~/::/'
300 12:3:0 FC 15 normal 559104 525312 6:6:1* 7:6:1 600
301 12:3:1 FC 15 normal 559104 525312 6:6:1 7:6:1* 600
302 12:3:2 FC 15 normal 559104 524288 6:6:1* 7:6:1 600
303 12:3:3 FC 15... (12 Replies)
Discussion started by: vishalgoyal
12 Replies
10. UNIX for Beginners Questions & Answers
Hello all- New to this forum, and relatively new to using grep at the Terminal command line to work with regular expressions. I've got a background in mathematics and some programming experience, so it's not been too difficult to learn the basics of searching through word lists for particular types... (6 Replies)
Discussion started by: dtalvacchio
6 Replies
LEARN ABOUT PHP
oci_field_type_raw
OCI_FIELD_TYPE_RAW(3) OCI_FIELD_TYPE_RAW(3)
oci_field_type_raw - Tell the raw Oracle data type of the field
SYNOPSIS
int oci_field_type_raw (resource $statement, mixed $field)
DESCRIPTION
Returns Oracle's raw "SQLT" data type of the $field.
If you want a field's type name, then use oci_field_type(3) instead.
PARAMETERS
o $statement
- A valid OCI statement identifier.
o $field
- Can be the field's index (1-based) or name.
RETURN VALUES
Returns Oracle's raw data type as a number, or FALSE on errors.
EXAMPLES
Example #1
oci_field_type_raw(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
$n = oci_num_fields($stid);
for ($i = 1; $i <= $n; ++$i) {
echo oci_field_name($stid, $i) . " is raw type: " . oci_field_type_raw($stid, $i) . "<br>
";
}
// Output is:
// NUMBER_COL is raw type: 2
// VARCHAR2_COL is raw type: 1
// CLOB_COL is raw type: 112
// DATE_COL is raw type: 12
oci_free_statement($stid);
oci_close($conn);
?>
NOTES
Note
In PHP versions before 5.0.0 you must use ocicolumntyperaw(3) instead. This name still can be used, it was left as alias of
oci_field_type_raw(3) for downwards compatability. This, however, is deprecated and not recommended.
PHP Documentation Group OCI_FIELD_TYPE_RAW(3)