oci_field_name
I did not test well before posting previous code. This if statement works and the other does not.
if( ocicolumnscale($R, $i ) != 129 )
{
$int_decimal = ocicolumnscale($R, $i );
$int_length = ocicolumnprecision($R, $i) - $int_decimal;
}
oci_field_precision
(PHP 5, PECL oci8 >= 1.1.0)
oci_field_precision — Tell the precision of a field
Descrição
int oci_field_precision
( resource $statement
, int $field
)
Returns precision of the field .
For FLOAT columns, precision is nonzero and scale is -127. If precision is 0, then column is NUMBER. Else it's NUMBER(precision, scale).
Parâmetros
- statement
-
A valid OCI statement identifier.
- field
-
Can be the field's index (1-based) or name.
Valor Retornado
Returns the precision as an integer, or FALSE on errors.
Notas
Nota: In PHP versions before 5.0.0 you must use ocicolumnprecision() instead. This name still can be used, it was left as alias of oci_field_precision() for downwards compatability. This, however, is deprecated and not recommended.
Veja Também
- oci_field_scale() - Tell the scale of the field
- oci_field_type() - Returns field's data type
add a note
User Contributed Notesoci_field_precision
webmaster at smwebdesigns dot com
15-Oct-2007 12:58
15-Oct-2007 12:58
webmaster at smwebdesigns dot com
11-Oct-2007 07:39
11-Oct-2007 07:39
I've found that when using ocicolumnprecision 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 = ocicolumnprecision($R, $i) - $int_decimal;
}