This is error due to multiple java version installed at different location. so in my case this is output . so i removed the all files from 'C:\ProgramData\Oracle\Java\javapath also deleted java folder from this location c:\java\jdk1.8.0_131\bin and worked. How to make it work: Step 1: Open terminal and type where 'java' It return 'C:\ProgramData\Oracle\Java\javapath' folder which contain: java.exe javaw.exe javaws.exe Browse to this folder with Windows file explorer and remove everything (three files above). Step 2: now check C:\Users\Admin>java -version Should now return: java version "1.8.0_131" Java(TM) SE Runtime Environment (build 1.8.0_131-b11) Java HotSpot(TM) 64-Bit Server VM (build 25.131-b11, mixed mode) or something similar depending on which java release package you've downloaded... It works! There are other links can help 1. https://stackoverflow.com/questions/8644992/error-registry-key-software-javasoft-java-runtime-environment-currentversion 2. https://stackoverflow.com/questions/6362037/java-error-opening-registry-key I hope your issue will be resolved .

Command prompt should look like this: *-----------------------------------------------* * --New Customer Program-- * *-----------------------------------------------* Please enter the customer's SOCIAL SECURITY NUMBER: 837465538 (Input) Please enter the customer's LAST NAME: koch Please enter the customer's FIRST NAME: george Please enter the customer's MIDDLE NAME: will Please enter the customer's PHONE NUMBER: 5629851111 *---The following record has been updated: Social Security Number: 837-46553-5538 Name: Koch,George w. Phone: (562)985-1111 Screenshot: Solution: hw7.sql set feedback off set echo off set verify off set heading off spool c:/app/hw7.txt drop table customers; create table customers ( SSN varchar2(9), LASTNAME varchar2(30), FIRSTNAME varchar2(30), MIDDLE varchar2(30), PHONE varchar2(10)); prompt prompt *-----------------------------------------------* prompt * --New Customer Program-- * prompt *-----------------------------------------------* prompt accept vSSN prompt 'Please enter the customer''s SOCIAL SECURITY NUMBER:'; select SSN from customers where SSN = '&vSSN'; accept vLASTNAME prompt 'Please enter the customer''s LAST NAME:'; select LASTNAME from customers where LASTNAME = '&vLASTNAME'; accept vFIRSTNAME prompt 'Please enter the customer''s FIRST NAME:'; select FIRSTNAME from customers where FIRSTNAME = '&vFIRSTNAME'; accept vMIDDLE prompt 'Please enter the customer''s MIDDLE NAME:'; select MIDDLE from customers where MIDDLE = '&vMIDDLE'; accept vPHONE prompt 'Please enter the customer''s PHONE NUMBER:'; select PHONE from customers where PHONE = '&vPHONE'; insert into customers (SSN,LASTNAME,FIRSTNAME,MIDDLE,PHONE) values('&vSSN','&vLASTNAME','&vFIRSTNAME','&vMIDDLE','&vPHONE'); commit; prompt prompt prompt *---The following record has been updated: prompt select 'Social Security Number: '|| substr(SSN,1,3)||'-'||substr(SSN,4,5)||'-'||substr(SSN,6,8) from customers; prompt select 'Name: '|| initcap(LASTNAME)||','|| initcap(FIRSTNAME) ||' '|| substr(MIDDLE,1,1)||'.' from customers; prompt select 'Phone: ('||substr(PHONE,1,3)||')'||substr(PHONE,4,3)||'-'||substr(PHONE,7,10) from customers; spool off #oracelqueryhelp #oraclequeryassignmenthelp #oracleexperthelp #hireoracledatabaseexpert #topwebsitefororacleassignmenthelp

Load the createInsurance.txt script file to create and populate the tables necessary for this assignment. The insurance database includes the following tables: Employer, Member, Carrier, Plan and Agent. Employers have employees (that are called members). The members subscribe (or elect) to participate in a health plan. These health plans are offered by Insurance Carriers and sold to Employers by Agents. The table relationships are defined for you and are pictured below. Review the table structures before you attempt to solve the assignment problems. You will need to write the SQL to solve 14 query problems defined below. You will build a single script file named yourLastName_A8Script.txt that contains all your SQL and SQL/PL statement necessary to solve and format the 14 queries. Output must be directed to a single .txt file named yourLastName_A8Spool.txt. You will need to submit both files for grading. Assignment Steps: Step 1) Download and execute the createInsuranceScript.txt script file to build and populate the 5 tables of the database. The code is error free – and should execute without issue. Step 2) Verify that your tables were created. You can visually inspect the table data using SQL Developer's user interface – by clicking on the Tables under the connection – and drilling down to view the table list – and then selecting each table and viewing the Data tab in the worksheet area. **No output from this section needs to be included in your spooled file. Step 3) Write the SQL code for the queries needed to create the result sets needed to meet the assignment problem specification -- as defined in the accompanying document. Refer back to Assignment 6 – and use the same template to guide you in organizing your script file. Step 4) Formatted output is required! You will need to write PL statements to create titles that bookend and title your result sets. Define the page size and line size of your output. Also, format the display of the columns in your result sets – all numbers should be formatted: currency to display as currency, other number to display with fixed number of decimal places. Your result set output should fit each row to one line of output without it wrapping to multiple lines. Reduce the width of text columns by truncating the text output. Remember that COLUMN statements persist – and thus only need to be defined once for each column – not once for each query. Place all COLUMN statements together near the top of your script file make it easy to grade your SQL solutions. (Be sure to place a CLEAR COLUMNS statement at the top of your code). Test your queries individually and then test your script file to ensure that it executes error free. Add the Spool statements to generate and capture the spooled output and post both the script file and spool file Project Deliverables: 1. (3 points) Script file, properly delineated and neatly organized with solutions to queries 1 – 14. This file should only contain SQL code, comments and PL statements to format your output. 2. (24 points). Correct SQL statements for query problems 1 – 12. 3. (6 points). Correct SQL statements for query problems 13 and 14. 4. (3 points) Spool file with contents of echoed SQL and spooled query output. 5. (4 points) Formatted output in your spool file that displays string and numeric data meaningfully in the generated result sets. #sqlassignmenthelp #oracleassignmenthelp #oraclequeryhelp #sqlqueryhelp #oracle #sql #plsql