Unshared SQL worksheet and SQL History – A multi-tasker with a good memory You can enter the table name, column name, data type, and all other parameters here.Īfter keying in the values, the DDL tab provides the corresponding SQL statement to prepare any deployment scripts. The below figure shows the whole range of operations available for table oe.customers.īy clicking the down arrow next to Tables, New Table can be created by just filling in the values without writing the DDL statement. By right-clicking on the object, it can be viewed, edited, recompiled, or executed. To do this, type the search string in the contains area.įrom here, based on the object type, all its related operations can be performed at ease. One other option is to search the objects by name in the selected type. The schema browser shows Tables, Views, Indexes, Packages, Procedures, Functions, Operators, Triggers, Types, Sequences, Materialized Views, Synonyms, and few other object types for the selected schema.
It also helps to browse through other schemas based on the permissions granted in the database. To open, right-click on the connection name and select Schema Browser. Schema Browser helps to review the existing objects in the schema. Any person who connects to a schema would like to check its contents and browse through it. The database connections can be easily set up using a TNS name file or keying in all the connection details. Compared to other tools for Oracle database, this comes in handy for database development and support tasks. Some of the key features are discussed here to help navigate the tool and better understand it. It has a wide variety of options and utilities to help in day to day development or support activities.
Oracle sql developer latest version free#
SQL Developer is a free tool provided by Oracle.
0 kommentar(er)
