Plsql procedure for updating salary which is greater than 10000
Let's look at some Oracle AVG function examples and explore how to use the AVG function in Oracle/PLSQL.For example, you might wish to know how the average salary of all employees whose salary is above ,000 / year.Which of the following statements will accomplish the task? SELECT a.divisionno "division", (a.num_work/COUNT(*))* 100 "%workers", (a.sal_sum/COUNT(*))*100 "%salary" FROM (SELECT divisionno, COUNT(*)num_work, SUM(SAL)sal_sum FROM GROUP BY divisionno)a; ANSd.SELECT "division", a.divisionno ROUND(a.num_work/b.total_count * 100,2)"%workers" ROUND(a.sal_sum/b.total_sal * 100,2) "%salary% FROM (SELECT divisionno, COUNT(*) num_work, SUM(SAL) sal_sum FROM GROUP BY divisionno)b;111.The sequence begins at 1000 and has a maximum value of 99999999 and increments by 1.You must write a script to insert a row into the patient table and use the sequence you created. You must create a report that displays employee details along with the tax category of each employee.To verify X Server configuration you can use xclock command [email protected]$ xclock If a clock pop ups server configuration is fine.
Which of the following statements should be used to create the report? Your manager requests that you analyze the time taken between when orders are taken and when they are shipped. You must retrieve worker names and salaries from the work table. If two names match for a salary, then the two names will be displayed in alphabetical order.
(find for inet addr looks like x.x format ) Say, ip address is 188.8.131.52 4.
run below command [email protected]$ xhost 184.108.40.206 5.
Davis must create tables and packages in his own schema.
What command must be executed next to grant him these privileges? The WORK table has columns designated for the birth date and hire date of all workers. You want to insert a row with the details of employee Wallace, who was born in 1952 and hired in 2001.