Oracle is the world's most popular relational database. It is a powerful engine of industrialization promoted by large companies. Let’s take a look at its related functions first:
(1) integer ora_logon (string user, string password)
Start a connection to an Oracle database server.
(2)integer ora_open(integer connection)
Open the cursor of the given connection.
(3)integer ora_do(integer connection, string query)
Execute the query on the given connection. PHP generates an indicator, parses the query, and executes it.
(4)integer ora_parse(integer cursor, string query)
Parse a query and prepare it for execution.
(5) boolean ora_exec(integer cursor)
Execute a query previously parsed by the ora_parse function.
(6) boolean ora_fetch(integer cursor)
This function will cause the rows in an executed query to be fetched into the indicator. This allows you to call the ora_getcolumn function.
(7) string ora_getcolumn(integer cursor, integer column)
Return the current value. Column zero-based numeric index.
(8) boolean ora_logoff(integer connection)
Disconnect the link to the database server.
The following is a sample program to insert data into the ORACLE database: