Write pl/sql anonymous block that will process records

Assignment Help Computer Engineering

Reference no: EM133258576

Question: Write PL/SQL anonymous block that will process records stored in the "emp" table (table that is created as part of the starter database which was created during the Oracle 12c database installation). The program must perform the following tasks. Declare the required types and variables to store both the employee name and salary information (i.e., a counter variable may be needed also as an index). Use a loop to retrieve the first 10 "ename" and "sal" values for records in the "emp" table , store in two variable array of 10 elements (i.e., one array will store the name; the other array will store the salary) Use another loop to display the "ename" and "sal" information in the reverse order (i.e., use the "REVERSE" option of the for-loop syntax)

Reference no: EM133258576

Questions Cloud

Develop your organization''s weather policy and procedures : Conduct research and develop your organization's weather policy and procedures to brief to the organization's president

Relationship between process and thread in multicore system : Describe the relationship between a process and a thread in a multicore system and Compare and contrast multiprocessing and concurrent processing

Read tambus thoughts about victimisation and femaleness : As you consider this question, read over Tambu's thoughts about "victimisation" and "femaleness" (Dangarembga 115-116).

Develop detailed guidelines for prevention and control : Develop detailed guidelines for prevention and control of computer abuse and guidelines for computer and network usage within the organization

Write pl/sql anonymous block that will process records : Write PL/SQL anonymous block that will process records stored in the "emp" table (table that is created as part of the starter database which was created during

How would you assess your specific abilities : Consider each of these areas of intelligence. How would you assess your specific abilities along each of these domains of intelligence

Show step by step putting each law : ENGR 207 Zewail University of Science and Technology Using the laws of logical equivalence, show step by step putting each law it must be same as the right hand

Problem based on rape in i know why the caged bird sings : Construct a synthesis-style, documented argumentative essay based on rape in I Know Why the Caged Bird Sings by Maya Angelou.

What changes need to be made to the workstation : Describe the current work area at home to show what it looks like Based on the OSHA checklist, what changes need to be made to the workstation?

User Account

All Pages