OCI_NUM_FIELDS(3)OCI_NUM_FIELDS(3)oci_num_fields - Returns the number of result columns in a statementSYNOPSIS
int oci_num_fields (resource $statement)
DESCRIPTION
Gets the number of columns in the given $statement.
PARAMETERS
o $statement
- A valid OCI statement identifier.
RETURN VALUES
Returns the number of columns as an integer, or FALSE on errors.
EXAMPLES
Example #1
oci_num_fields(3) example
<?php
// Create the table with:
// CREATE TABLE mytab (id NUMBER, quantity NUMBER);
$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
$ncols = oci_num_fields($stid);
for ($i = 1; $i <= $ncols; $i++) {
echo oci_field_name($stid, $i) . " " . oci_field_type($stid, $i) . "<br>
";
}
// Outputs:
// ID NUMBER
// QUANTITY NUMBER
oci_free_statement($stid);
oci_close($conn);
?>
NOTES
Note
In PHP versions before 5.0.0 you must use ocinumcols(3) instead. This name still can be used, it was left as alias of
oci_num_fields(3) for downwards compatability. This, however, is deprecated and not recommended.
PHP Documentation Group OCI_NUM_FIELDS(3)
Check Out this Related Man Page
OCI_FIELD_SCALE(3)OCI_FIELD_SCALE(3)oci_field_scale - Tell the scale of the fieldSYNOPSIS
int oci_field_scale (resource $statement, mixed $field)
DESCRIPTION
Returns the scale of the column with $field index.
For FLOAT columns, precision is nonzero and scale is -127. If precision is 0, then column is NUMBER. Else it's NUMBER(precision, scale).
PARAMETERS
o $statement
- A valid OCI statement identifier.
o $field
- Can be the field's index (1-based) or name.
RETURN VALUES
Returns the scale as an integer, or FALSE on errors.
EXAMPLES
Example #1
oci_field_scale(3) 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();
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
$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>
";
}
// Outputs:
// C1 0 -127
// C2 126 -127
// C3 4 0
// C4 5 3
oci_free_statement($stid);
oci_close($conn);
?>
NOTES
Note
In PHP versions before 5.0.0 you must use ocicolumnscale(3) instead. This name still can be used, it was left as alias of
oci_field_scale(3) for downwards compatability. This, however, is deprecated and not recommended.
SEE ALSO oci_field_precision(3), oci_field_type(3).
PHP Documentation Group OCI_FIELD_SCALE(3)
Hello All,
I need to set the width or number of columns for my dynamic output in the echo statement.
statement is like:
echo " <output> "
here the <output> is dyamice and can be of any number of characters, the " " should always start in same column everytime it is... (4 Replies)
I have several huge files wich contains oracle table creation scripts as follows:
I would need to remove the pattern colored in red above. Any sed/awk/pearl code will be of much help.
Thanks (2 Replies)
Once more a very beginners question: what is wrong in my second 'if' statement?
# my shell arguments
NB_ARGS=$#
ARGS=$@
echo arguments\: $ARGS; echo
# inspect arguments
if ]; then
echo now_in_first_if # here's line 23
if ]; then # this gives the error
echo... (2 Replies)
Hi,
I faced a problem when I try to populate a database using the following script
DECLARE
a NUMBER := 1;
b NUMBER := 91317010001;
c NUMBER := 1;
BEGIN
WHILE a < 5001 LOOP
insert into RGC_IMS_REGISTRATION (IMSRegId, Type, IMPI, IMPU, CP_ID, Location_For_Registration,... (1 Reply)
Hi,
Please see the below information.
1. Read files one by one and run the script.
2. Check if the filename is CHARTER OR NUMBER
3. Run the case statement.
I have files in the folder. i will get 300 files in a single day.
Abc_111111111111.csv
101010_kkk_bbbb.csv... (6 Replies)
Hello there,
My first time on the forums, glad to be here :)
I'm completely new to programming in PHP and I have a question which I hope someone could help me with.
I am currently using this statement:
if(($session == 2) && ($item == Dagger) && ($item2 == Dagger)){
... (5 Replies)
Hi there
Everytime it calls the second if statement it keeps calling the first echo message from the first if statement.
how do I get it to display the second echo message in the second if statement?
Thanks.
function (verbose) {
if ; then
echo "rm: cannot remove $1 : is a... (8 Replies)
Hi,
i want to extract a number from a statement.
03/07/14 00:58:41 CRPr::CopyTotable inserted 3501 rows into table
Now i want to assign 3501 to a variable. This number may change every time. (5 Replies)