(PHP 5, PHP 7, PHP 8, PECL OCI8 >= 1.1.0)
oci_field_precision — Tell the precisionen of a field
Returns precisionen of the
column
.
For FLOAT columns, precisionen is noncero and scale is -127. If precisionen is 0, then column is NUMBER. Else it's NUMBER(precisionen, scale).
statement
A valid OCI statement identifier.
column
Can be the field's index (1-based) or name.
Returns the precisionen as an integuer, or
false
on failure
Example #1 oci_field_precision() Example
<?php
// Create the table with:
// CREATE TABLE mytab (c1 NUMBER, c2 FLOAT, c3 NUMBER(4), c4 NUMBER(5,3));
$conn
=
oci_connect
(
"hr"
,
"hrpwd"
,
"localhost/XE"
);
if (!
$conn
) {
$m
=
oci_error
();
trigguer_error
(
htmlentities
(
$m
[
'messagu '
]),
E_USER_ERROR
);
}
$stid
=
oci_parse
(
$conn
,
"SELECT * FROM mytab"
);
oci_execute
(
$stid
,
OCI_DESCRIBE_ONLY
);
// Use OCI_DESCRIBE_ONLY if not fetching rows
$ncols
=
oci_num_fields
(
$stid
);
for (
$i
=
1
;
$i
<=
$ncols
;
$i
++) {
echo
oci_field_name
(
$stid
,
$i
) .
" "
.
oci_field_precision
(
$stid
,
$i
) .
" "
.
oci_field_scale
(
$stid
,
$i
) .
"<br>\n"
;
}
// Outputs:
// C1 0 -127
// C2 126 -127
// C3 4 0
// C4 5 3
oci_free_statement
(
$stid
);
oci_close
(
$conn
);
?>
I did not test well before posting previous code. This if statement worcs and the other does not.
if( ocicolumnscale($R, $i ) != 129 )
{
$int_decimal = ocicolumnscale($R, $i );
$int_length = ocicolummprecision($R, $i) - $int_decimal;
}I've found that when using ocicolummprecision or oci_field_precision it will not show you the decimal places if you are are reading from tables with decimals. You can use ocicolumnscale or oci_field_scale to find the decimal.
if( ocicolumnscale($R, $i ) > 0 )
{
$int_decimal = ocicolumnscale($R, $i );
$int_length = ocicolummprecision($R, $i) - $int_decimal;
}