Preskoči na glavni sadržaj

Sign up for FREE

Oracle DML Exercise imp(03/03/24)

Posljednje ažuriranje over 2 years ago

5

1

Pitanje 1

1.

figure 1 : employee table
Attached are the employee table. Based on the data given construct SQL INSERT syntax to add all employee data in one command.

1

Pitanje 2

2.

Based on employees table, apply SQL syntax to display/view all data from employee table

1

Pitanje 3

3.

Apply SQL syntax to calculate sum of salary from employee table

1

1

Pitanje 4

4.

Write SQL statement to show all employee data from dept_id 500

Pitanje 5

5.

Apply SQL statement to calculate sum of salary employee table group by dept_id