SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of sql utilities. You can use it for dial-up connection and it will work as fast as SQLPlus. It is small and not required an installation so SQLTools will help you anywhere because it is small enough for floppy and available for downloading on the Web. SQLTools is free and probably going to be a public source project.
SQLTools is:
- Powerful editor (actually it'll be more powerful in the next release), which supports drag & drop, syntax highlighting, code template expansion, etc. It is possible to find a database object under cursor and get its description. Context sensitive help provides information about the current sql statement.
- SQL console, which is embedded in the editor. It supports DML & DDL statements and provides additional information about database statistics and timing.
- Object Browser is designed for getting any object DDL definition. One of useful features is support group operations, for example, you can select and disable a set of constraints in one operation.
- Extract Schema utility, which loads all objects definition and stores on local disk.
