Home > PHP > Extension > OCI8

OCI8

database
  • DRCP Connection Pooling () - Sets the database edition
  • OCI-Collection->append (value) - Appends element to the collection
  • OCI-Collection->assign (from) - Assigns a value to the collection from another existing collection
  • OCI-Collection->assignElem (index, value) - Assigns a value to the element of the collection
  • OCI-Collection->free (index, value) - Frees the resources associated with the collection object
  • OCI-Collection->getElem (index) - Returns value of the element
  • OCI-Collection->max (index) - Returns the maximum number of elements in the collection
  • OCI-Collection->size (index) - Returns size of the collection
  • OCI-Collection->trim (num) - Trims elements from the end of the collection
  • OCI-Lob->append (lob_from) - Appends data from the large object to another large object
  • OCI-Lob->close (lob_from) - Closes LOB descriptor
  • OCI-Lob->eof (lob_from) - Tests for end-of-file on a large object's descriptor
  • OCI-Lob->erase (offset, length) - Erases a specified portion of the internal LOB data
  • OCI-Lob->export (filename, start, length) - Exports LOB's contents to a file
  • OCI-Lob->flush (flag) - Flushes/writes buffer of the LOB to the server
  • OCI-Lob->free (flag) - Frees resources associated with the LOB descriptor
  • OCI-Lob->getBuffering (flag) - Returns current state of buffering for the large object
  • OCI-Lob->import (filename) - Imports file data to the LOB
  • OCI-Lob->load (filename) - Returns large object's contents
  • OCI-Lob->read (length) - Reads part of the large object
  • OCI-Lob->rewind (length) - Moves the internal pointer to the beginning of the large object
  • OCI-Lob->save (data, offset) - Saves data to the large object
  • OCI-Lob->saveFile (data, offset) - Alias of oci_lob_import()
  • OCI-Lob->seek (offset, whence) - Sets the internal pointer of the large object
  • OCI-Lob->setBuffering (on_off) - Changes current state of buffering for the large object
  • OCI-Lob->size (on_off) - Returns size of large object
  • OCI-Lob->tell (on_off) - Returns current position of internal pointer of large object
  • OCI-Lob->truncate (length) - Truncates large object
  • OCI-Lob->write (data, length) - Writes data to the large object
  • OCI-Lob->writeTemporary (data, lob_type) - Writes temporary large object
  • OCI-Lob->writeToFile (data, lob_type) - Alias of oci_lob_export()
  • oci_bind_array_by_name (statement, name, var_array, max_table_length, max_item_length, type) - Binds PHP array to Oracle PL/SQL array by name
  • oci_bind_by_name (statement, bv_name, variable, maxlength, type) - Binds a PHP variable to an Oracle placeholder
  • oci_cancel (statement) - Cancels reading from cursor
  • oci_close (connection) - Closes an Oracle connection
  • oci_commit (connection) - Commits the outstanding database transaction
  • oci_connect (username, password, connection_string, character_set, session_mode) - Connect to an Oracle database
  • oci_define_by_name (statement, column_name, variable, type) - Associates a PHP variable with a column for query fetches
  • oci_error (resource) - Returns the last error found
  • oci_execute (statement, mode) - Executes a statement
  • oci_fetch (statement) - Fetches the next row from a query into internal buffers
  • oci_fetch_all (statement, output, skip, maxrows, flags) - Fetches multiple rows from a query into a two-dimensional array
  • oci_fetch_array (statement, mode) - Returns the next row from a query as an associative or numeric array
  • oci_fetch_assoc (statement) - Returns the next row from a query as an associative array
  • oci_fetch_object (statement) - Returns the next row from a query as an object
  • oci_fetch_row (statement) - Returns the next row from a query as a numeric array
  • oci_field_is_null (statement, field) - Checks if the field is NULL
  • oci_field_name (statement, field) - Returns the name of a field from the statement
  • oci_field_precision (statement, field) - Tell the precision of a field
  • oci_field_scale (statement, field) - Tell the scale of the field
  • oci_field_size (statement, field) - Returns field's size
  • oci_field_type (statement, field) - Returns field's data type
  • oci_field_type_raw (statement, field) - Tell the raw Oracle data type of the field
  • oci_free_statement (statement) - Frees all resources associated with statement or cursor
  • oci_internal_debug (onoff) - Enables or disables internal debug output
  • oci_lob_copy (lob_to, lob_from, length) - Copies large object
  • oci_lob_is_equal (lob1, lob2) - Compares two LOB/FILE locators for equality
  • oci_new_collection (connection, tdo, schema) - Allocates new collection object
  • oci_new_connect (username, password, connection_string, character_set, session_mode) - Connect to the Oracle server using a unique connection
  • oci_new_cursor (connection) - Allocates and returns a new cursor (statement handle)
  • oci_new_descriptor (connection, type) - Initializes a new empty LOB or FILE descriptor
  • oci_num_fields (statement) - Returns the number of result columns in a statement
  • oci_num_rows (statement) - Returns number of rows affected during statement execution
  • oci_parse (statement) - Prepares an Oracle statement for execution
  • oci_password_change (connection, username, old_password, new_password, dbname, username, old_password, new_password, connection, username, old_password, new_password, dbname, username, old_password, new_password) - Changes password of Oracle's user
  • oci_pconnect (username, password, connection_string, character_set, session_mode) - Connect to an Oracle database using a persistent connection
  • oci_result (statement, field) - Returns field's value from the fetched row
  • oci_rollback (connection) - Rolls back the outstanding database transaction
  • oci_server_version (connection) - Returns server version
  • oci_set_prefetch (statement, rows) - Sets number of rows to be prefetched by queries
  • oci_statement_type (statement) - Returns the type of a statement
  • Roundtrip Gotcha (connection, module_name) - Sets the action name