Twa kɔ nsɛm atitiriw so

Sign up for FREE

Oracle DML Exercise imp(03/03/24)

Last updated over 2 years ago

5 Nsɛmmisa

1

Asemmisa {{asɛmmisaAhyɛnsode}}

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

Asemmisa {{asɛmmisaAhyɛnsode}}

2.

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

1

1

1

Asemmisa {{asɛmmisaAhyɛnsode}}

3.

Apply SQL syntax to calculate sum of salary from employee table

Asemmisa {{asɛmmisaAhyɛnsode}}

4.

Write SQL statement to show all employee data from dept_id 500

Asemmisa {{asɛmmisaAhyɛnsode}}

5.

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