OracleEditor.php 1.20

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. Features: - Connects to any Oracle database (local databases, aliases from tnsnames.ora, or complete connection strings) - Lists all tables and views owned by the user, and those owned by other users where access has been granted - 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 - Exports your result set as an HTML, XML or CSV file - 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, and with both magic_quotes_gpc=on or Requirements: - OracleEditor.php works fine with the php.ini setting register_globals=off.

Requirements:	No special requirements
Platforms:	Windows, Mac, *nix, Mac OSX, Linux, PHP , BSD Solaris
Keyword:	Database,  Database Browser,  Database Interface,  Editor,  Oracle,  Oracle Editor
Users rating:	0/10