Insert "select * from "
SQL ReferenceOracle 9i
The first time, there are no connections, click "Add" to create one.
The connection settings are saved in %USERPROFILE%\dbedit.xml.
The correct driver will automatically be determined based on the entered URL.
The application can connect to basically any type of database that provides a JDBC driver. Just place the driver in the directory where the application is installed and set up a connection with the appropriate URL syntax. This directory is scanned for all jar and zip files prior to connecting.
If the changes have to become permanent, commit before disconnect.
Commits all changes to the database since the last commit/rollback/connect.
Note that auto commit is disabled, meaning that all changes made to the database have to be committed in order to become permanent.
Rolls back all changes from the database since the last commit/rollback/connect, which means all changes are discarded.
Various text editing features are provided by JSyntaxPane.
Right click the editor to use them.
Use the favorites function to save your frequently used statements.
Selecting a favorite will load the previously saved statement in the editor pane.
Adding a favorite will save the contents of the editor pane under a new or existing named favorite.
The favorites are saved in %USERPROFILE%\dbedit.xml.
Every time a statement is executed, regardless if it is successful, it saved in the history.
Use the history buttons/shortcuts to browse the previously executed statements.
The history is not persisted to disk, so the lifetime is as long as the execution of the application.
Formats basic SQL statements (DML and queries) to make them more readable.
Executes the SQL in the editor pane. The SQL can be a query, DML, DDL, DCL, PL/SQL, a transaction block, a call, basically anything.
If a piece of text is selected, only that selection will be executed. This is useful for executing a series of statements one by one.
The schema browser helps you select tables, views, columns, functions and procedures from the database schema.
Once opened use the arrow keys or the mouse to select an object, pressing enter or double clicking will result in showing the selected object in the editor pane.
To cancel press escape, press Alt+Enter or click the schema browser icon.
Note that every change is instantaneously sent to the database and is therefore validated immediately.
It's impossible to change a result set that is retrieved using the "order by" clause. Leave the "order by" away and sort afterwards by clicking the column headers on the grid.
Obviously, analytic results can't be changed either, as well as all complex results which prevent the record to be traced back to its source.
The record is based on the result set of the last executed query.
All initial values are based o the selected record in the grid.
Exports a lob to a file and optionally opens it with the associated application. If the lob is in plain text, the contents are shown and it's also possible to copy it to the clipboard. Multiple lobs can also be exported in one go. To do so, select multiple lob cells, while exporting, a destination directory will be asked for and a column of that table must be selected to name the files.
For quick editing a lob: double click the lob, save and open it, do all necessary adjustments, save the file, click Import, the previously edited file will be suggested, confirm.
This function is useful for database synchronization.
You're looking at it.
"select * from " is probably the most frequently used piece of syntax. Don't bother typing it over and over, just press Ctrl+S.