PL/SQL Developer - Non-PL/SQL Objects


During PL/SQL development you will often want to view, modify or create other objects. For tables, sequences, synonyms, libraries, directories, queues, jobs, users and roles you can do so without using any SQL. Simply right-click on an object in the Object Browser or in your source file, and select 'View' or 'Edit' from the popup menu.

After creating a new object, or after making changes to an existing object, the SQL statements to apply these changes to the databases can be viewed, edited, copied, saved or exported to a Command Window. You can of course also execute the SQL by pressing the 'Apply' button.

The screenshot above shows the columns page of table definition editor for table EMP.