Oracle SQL Developer is a graphical tool that enhances productivity and simplifies development tasks for database application developers. Using SQL Developer, TimesTen database users can browse, create, and edit database objects and PL/SQL subprograms; automates cache group operations; manipulate, export and import data; execute SQL and PL/SQL statements and scripts; and view and create reports.
SQL Developer provides a tree-based object browser. Navigation to database connections and objects are visually intuitive with tabbed display of details specific to each object type. SQL Developer complements the TimesTen ttIsql command line utility, by simplifying the development tasks using a graphical user interface.
Using SQL Developer, users can connect to local or remote TimesTen databases to create and modify database objects, manage database users and their privileges, edit and execute SQL and PL/SQL programs; search and modify data stored in the TimesTen tables; view SQL definition and properties of the objects; import data, and export data to various formats including the TimesTen ttBulkcp format. SQL Developer provides a PL/SQL editor for the creation, editing and compilation of PL/SQL packages and subprograms.
SQL Developer automates the tasks required to create and configure TimesTen cache groups to cache Oracle Database tables. Cache group creation is made easy by browsing the Oracle Database schema and selecting the appropriate tables and columns to cache. The column definitions and the relationships between the cache tables are automatically inherited from the Oracle Database. Working with cache tables, and setting data aging policies and cache refresh intervals are intuitive and customizable in SQL Developer. Support for connecting to multiple databases enables SQL Developer users to work with data in the TimesTen database and the Oracle Database concurrently, making it easy to see the effect of automatic data synchronization between the two databases.
SQL Developer supports both direct-linked (in-process) and client/server connections to the TimesTen databases.
SQL Developer 3.1 supports TimesTen 22.214.171.124 or later releases.