How to use the SQL Worksheet in SQL Developer to Insert, Update and Delete Data
Updated: Nov 2009 for SQL Developer 2.1
After completing this How-To, you should be able to understand:
How to use the SQL Worksheet to write a few SQL commands to update data.
Table of Contents
Oracle SQL Developer provides a SQL Worksheet that you can use to update data, by writing simple or complex SQL statements. In this How-To, we look at the most basic of these, inserting a record, updating single and multiple records and deleting single or multiple records.
SQL Developer has a variety of methods to insert data into your table. We'll start with the most straight forward.
As in the above example, you can update data using the SQL Worksheet, using SQL commands, or you can use the data tab in the table definition and update individual rows. You'll do both in this next exercise.
As with the previous two examples, you can use the SQL Worksheet to delete single or multiple rows, or you can use the Data tab.