OracleEditor.php is a standalone PHP script which allows you to browse your Oracle database tables and insert, update and delete rows in any table. It requires no installation and no configuration.

This is sort of a quick-hack tool when you have nothing else available. Even if the installatio is pretty simple, this could be a very serious security risk if not taken care of properly (like all powerful tools :-)... I even think of wireless security because these simple html-pages could even be accessed via a Palm or Smartphone like the P800. powerful and dangerous, but worth a look anyhow!

With Version 1.2 released yesterday you can switch from the classic SQL entry (where you choose the table from a popup) to a freely editable text field. This allows you to run any SQL statement, including INSERT, UPDATE and DELETE statements. (Note that row editor functionality is only available with "classic" SQL entry.)

Features:

• Connects to any Oracle database (local databases, aliases from tnsnames.ora, or complete connection strings
• Lists all tables and views in the database
• Simply select a table or view to display (SELECT) its records
• Modify the list of fields to select (optional)
• Add a WHERE clause (optional)
• Records are displayed in sets, allowing you to browse huge tables
• Foreign key values are linked to the master record: Simply click on the value to display the master record
• Fields which are used as foreign keys in other tables have links allowing you to browse all child records with one click
• Last 25 SELECT statements are in the History popup
• UPDATE, DELETE, and INSERT rows in any table
• When updating or inserting, field values can either be strings or

  function names (allowing you to insert sequencer values, function

  calls, or NULL)

• String values are sent to Oracle as bound variables, so that you don't have to escape single quotes
• When inserting, nullable fields are pre-set to NULL so that you know which fields can be left blank
• Optional free SQL statement entry
• Debug mode logs all SQL statements in the PHP error_log
• Oracle error messages are displayed so that you know what went wrong
• Works with register_globals=off