Write a query to update the departmentId as "A10" for the details "InformationTechnology" and "E10" for the details "ElectricalElectronicsEngineering" print only the departmentId and details from the department tab

Write a query to modify the datatype of the column departmentId from VARCHAR(30) to INT in the table 'department'.Refer to the existing table DLL given below:

Problem StatementWrite a query to display the details of employees who are not in the 'Developer' department. Table: EmployeeInput format :The input table is already created, and records are already prepopulated, as mentioned in the problem statement.Output format :The output displays a list of employees who work in departments other than 'Developer' as shown below.id name Department102 Stark HR104 Jack Finance106 Scott AdminRefer to the sample output for the column headers.Note :The program will be evaluated only after the “Submit Code” is clicked.Extra spaces and new line characters in the program output will result in the failure of the test case.

eid ename esalary email dob1 XYZ 3000.89 [email protected] 1990-08-302 ABC 2300.90 [email protected] 1980-03-211] Write Query to insert 2 Records  in above table using single query.2]Write Query to update esalary to 4000.68 and dob to 1993-08-30  of employee whose eid is 1 in a single query.3] Write Query to delete all records from the table in single query.

Create a package named "dept_package".Declare and define the following 4 Procedures in this package.1) Procedure to insert a new record in the department table.    Name : addDepartment    Parameters and their types :        dept_id   department.department_id%type        dept_name  department.department_name%type        dept_block_number  department.department_block_number%type 2) Procedure to delete a department when department id is passed as the input parameter.    Name : deleteDepartment    Parameters and their types :        dept_id   department.department_id%type        3) Procedure to list the details of all departments (id, name and block number) in ascending order based on id.     Name : listDepartment     Parameters and their types :        It uses cursors        dept_details OUT SYS_REFCURSOR        4) Procedure to update a department name (Given the old dept name and new dept name)      Name : updateDepartment      Parameters and their types :        dept_name  department.department_name%type        new_dept_name  department.department_name%type  Note:Do not change the package or procedure nameDo not change the argument count and orderDo not change the output text.Instructions:1. Create the package successfully2. Once the package is created, check the functionality of the procedure using different anonymous block call.3. DO NOT submit the anonymous block. Submit only the CREATE PACKAGE query. SubmitSaveExecutePrevious Submission

Problem statementSend feedbackSuppose you have a list of employees in a company, and each employee is represented as an object with the following properties:"id" - a unique identifier for the employee"name" - the employee's name"department" - the department the employee works in"salary" - the employee's current salaryObjectives:You want to make a modification to the list of employees to reflect a recent company-wide salary increase. You have been provided with the following information:Salaries for employees in the "sales" department should be increased by 10%.Salaries for employees in the "engineering" department should be increased by 15%.Salaries for employees in all other departments should be increased by 5%.You need to write a function "increaseSalaries" that takes an array of employee objects and returns a new array of employee objects where each employee's salary has been updated based on their department. The original array of employees should be left unchanged.