How should Connection String looks like during establishing a connection to the external Oracle DB server
Two useful procedures.
When should be used VIEW and when MATERIALIZED VIEW? What the difference between them.
Some simple examples of using of EXECUTE IMMEDIATE tool.
Simple example of using the row_number()
Checking of TEMP file and free space within all DB shemas. Monitoring of free space of each datafile separately.
This code allows you to call for a stored functions/procedures from the packages in Oracle. Package in Oracle must has “grant execute on PACKAGE_NAME to WEBUSERNAME” privilege to the user data, which had been written in Database Connection configuration file “database.php”.
How to apply/revoke a Role or a Privilege. How to create a Synonym.
Simple examples without all off.doc. features. How to create a new Schema.