Print a single formatted record - Set echo on - Set up a spool file to receive your output for submission. I would suggest c:\cs4210\WA4spool.txt . - SET SERVEROUTPUT ON - DECLARE a record variable (Emp_rec) using %ROWTYPE - In the BEGIN block use INTO to load a record into the declared variables for HR.EMPLOYEES for Employee_ID = 114 - Use a CASE statement to print the associated Department Name for Department_ID - Add DBMS_OUTPUT lines to print each variable for the selected record - Use TO_CHAR to format Salary as 999,999.00 - Add an EXCEPTION block to report when no data is found - Compile and run the procedure - Close the spool file

Print a single formatted record - Set echo on - Set up a spool file to receive your output for submission. I would suggest c:\cs4210\WA4spool.txt . - SET SERVEROUTPUT ON - DECLARE a record variable (Emp_rec) using %ROWTYPE - In the BEGIN block use INTO to load a record into the declared variables for HR.EMPLOYEES for Employee_ID = 114 - Use a CASE statement to print the associated Department Name for Department_ID - Add DBMS_OUTPUT lines to print each variable for the selected record - Use TO_CHAR to format Salary as 999,999.00 - Add an EXCEPTION block to report when no data is found - Compile and run the procedure - Close the spool file

Programming Logic & Design Comprehensive

9th Edition

ISBN:9781337669405

Author:FARRELL

Publisher:FARRELL

Chapter7: File Handling And Applications

Section: Chapter Questions

Problem 15RQ

See similar textbooks

Similar questions

Print multiple formatted records Set echo on SET SERVEROUTPUT ON Set up a spool file to receive your output for submission. I would suggest c:\cs4210\WA5spool.txt. DECLARE a record variable (Emp_rec) using %ROWTYPE In the BEGIN block use INTO to load a record into the declared variables for HR.EMPLOYEES for all employees WHERE DEPARTMENT_ID = 30 Add a LOOP to print all the records Use a CASE statement to print the associated Department Name for Department_ID Add DBMS_OUTPUT lines to print EMPLOYEE_ID, FIRST_NAME, LAST_NAME, and SALARY for the selected record Use TO_CHAR to format the salary as 999,999 Add an EXCEPTION block to report when no data is found Compile and run the procedure. Close the spool file
Parson’s Problem Rearrange the code blocks below into the proper order by dragging drop them in the yellow box below. Tip: The program using struct will accept input for the records such as id, name and rate. Note: NOT all of the code blocks will be used. Drag from here
We’ve been updating and extending the inventory project to use files and to use arrays. Now it’s time to put it all together. I will give you a file inventory.txt File Contents: Red delicious apples 1.00 25 6 8 10 Assorted bouquets 4.00 50 10 10 0 Camembert cheese 2.00 25 10 12 4 END The file will have the following specifications: Each record consists of two lines. The first line contains the name of the product, which may be more than one word long. The second line contains the wholesale price as a decimal, the markup as a percentage, and three quantities, for counter, shelf, and warehouse. If the first line of a record contains the word END all by itself, that is the end of the file. Your task is to read each record into the program, as a string for the name, and numbers for the price and markup, and as an array of numbers for the quantities. Then calculate the total profit for each item: (wholesale price) * (markup, converted into a decimal) * (total quantity). Print out a report…
LEVEL 16 are STAT lines which are written to the trace file for each execution(equivalent to plan_stat=ALL_EXECUTIONS) a) True b) False
You are asked to develop an application that does the following: 1. The application should read the records from the user (String Name and String ID) and write them into a text file named (Employees.txt). The text file should be structured as follow: Sara Ahmad 123123 121122 John 123 Mohammed 12345 2. The user is asked to enter the values for records untih the user enters the value zero (0) for the name then the loop should be terminated. 3. Then, the application should read and check each record in the text file and print out all the records that have an ID less than 6 digits. Note: • The file should be opened only once for writing otherwise the previous content will be truncated. • Make sure you handle all expected exceptions that might be caused by the provided code. Sample outputt: Enter eployee nae and 10 Sara Becord we aed stully Entar pleye na and to Ahead Beeed ves ted sueesstully.. tese pieyee nane and 1D Juh Red was added estully.. Inser elayee ae ad ID Hhama ad was dded…
I will give you a file inventory.txt The file will have the following specifications: Each record consists of two lines. The first line contains the name of the product, which may be more than one word long. The second line contains the wholesale price as a decimal, the markup as a percentage, and three quantities, for counter, shelf, and warehouse. If the first line of a record contains the word END all by itself, that is the end of the file. Your task, in c++, is to read each record into the program, as a string for the name, and numbers for the price and markup, and as an array of numbers for the quantities. Then calculate the total profit for each item: (wholesale price) * (markup, converted into a decimal) * (total quantity). Print out a report on one line for each item: Name, total profit. Format the output nicely: names should fit in 30 characters and the prices should line up and should have two decimal places. Hints: You’ll want to use getline to read multi-word product…
Write a function that takes three input parameters: ‘mintCalorie’, ‘maxCalorie’, and ‘range’. Assuming that range is a vector of numerical ids, the function will iterate the records print the row if the calorie of the cereal falls in the range ‘minCalorie’ to ‘maxCalorie’. You need to use a ‘for loop’ and ’if statements Test the above function by making at least 10 different function calls.
The "-t" flag to "ls" sorts the listing by modification time. Write a BASH line which will write the name of file with the oldest modification time into a file called "lastfile".
A temperature file consists of five records, each containing a temperature in degrees Fahrenheit. A program is to be written that will read the input temperature, convert it from degrees Fahrenheit to degrees Celsius and print both temperatures in two columns on a report. Column headings, which read ‘Degrees F’ and ‘Degrees C’, are to be printed at the top of the page. What ist he best solution algorithm to successfully implement the above question?
program by using "C language" my student number is :1910206534 The information of all students taking the programming course is kept in a random access file with the struct given below. Your code should swap the information of two records in the file. Write the code that performs this operation. Note: The position of the 2 records that you need to swap like this:The position of the first record is the sum of the first 5 digits of your student number.The position of the second record is the sum of the last 5 digits of your student number.
2. load_friendsdb This function does the reverse of save_friendsdb -- it takes a single argument, filename, and opens that specified file for reading. Then it reads the file one line at a time and creates a new friends database to return. Like in the previous function, each line will contain a friend's name followed by a tab, then the friend's height, and then a newline. Sample calls should look like this: >>> load friendsdb("friendsdb.tsv") [{'name': ' bimmy', 'height': 600}, {'name': 'Ian Donald Calvin Euclid Zappa', height': 175}]
2. load_friendsdb This function does the reverse of save_friendsdb -- it takes a single argument, filename, and opens that specified file for reading. Then it reads the file one line at a time and creates a new friends database to return. Like in the previous function, each line will contain a friend's name followed by a tab, then the friend's height, and then a newline. Sample calls should look like this: >>> load_friendsdb("friendsdb.tsv") [{'name': ' bimmy', 'height': 600}, {'name': Ian Donald Calvin Euclid Zappa', height': 175}]