How To Insert,update,delete,join Data into a Table Using SQL Developer tool

How To Insert,update,delete,join Data into a Table Using SQL Developer tool

In this topic, you learn to add objects to the Query Builder interface and then create a query based on those objects.

In this section, you create a query based on the EMPLOYEES and DEPARTMENTS tables. You will generate output that shows per department name, the employees who work in that department.

Perform the following steps to add the EMPLOYEES table to the Query Builder.

1 .

Select the Query Builder tab to open Query Builder window.


2 .

Drag and drop the EMPLOYEES table from the Connections navigator to the Query Builder window.

3 .

Drag and drop the DEPARTMENTS table object over to the Query Builder window, so that the two table objects are displayed in the Query Builder window.

Because there are two relationships defined between the EMPLOYEES and DEPARTMENTS tables, you see two lines between the tables identifying the columns that are linked together through foreign key constraints.

The two relationships are defined as:

The MANAGER_ID in the DEPARTMENTS table must be a value of the EMPLOYEE_ID in the EMPLOYEES table (managers must exist as employees).
The DEPARTMENT_ID in the EMPLOYEES table must be a value of the DEPARTMENT_ID in the DEPARTMENTS table (an employee's department must exist in the DEPARTMENTS table, or be null).


4 .

Next, you select the columns that you want to see in the report.

In the EMPLOYEES table, check the FIRST_NAME, LAST_NAME, JOB_ID, SALARY, and DEPARTMENT_ID columns. As you select these columns, note that they are added in the order that you select them into the window below the table objects.

In the DEPARTMENTS table, check the DEPARTMENT_NAME column.

5 .

Click Run .