Third, we are opening the cursor in the execution section in line no 8.
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.
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.
We can also create a record with a cursor by replacing the table name with the cursor name.
Second, we are declaring a cursor ‘emp_cur’ from a select query in line no 3 - 6.There are three divisions within your company and each division has at least one worker bonus program and at least one worker.Bonus values do not exceed 500; not all employees receive bonuses. You have been given update privileges on the last_name column of the worker table.You must create the patient_id_seq sequence to be used with the patient table's primary key column.The sequence will begin with 1000, have a maximum value of 9999999, not reuse numbers, and increment in quantities of 1.· If you are fetching a cursor to a list of variables, the variables should be listed in the same order in the fetch statement as the columns are present in the cursor.