Oracle DML Exercise imp(03/03/24)
star
star
star
star
star
Last updated almost 2 years ago
5 questions
1
Attached are the employee table. Based on the data given construct SQL INSERT syntax to add all employee data in one command.
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
Based on employees table, apply SQL syntax to display/view all data from employee table
Based on employees table, apply SQL syntax to display/view all data from employee table
1
Apply SQL syntax to calculate sum of salary from employee table
Apply SQL syntax to calculate sum of salary from employee table
1
Write SQL statement to show all employee data from dept_id 500
Write SQL statement to show all employee data from dept_id 500
1
Apply SQL statement to calculate sum of salary employee table group by dept_id
Apply SQL statement to calculate sum of salary employee table group by dept_id