Write an SQL script that performs the following.

• Prompts the user for Employee Number (use the SQL Plus PROMPT (Links to an external site.) command)
• Accepts a value of 7900 (use the SQL Plus ACCEPT (Links to an external site.) command; the value will be stored in a substitution variable)
• Generates a query to display , Employee Number (Emp ), Department Number (Emp ), Department Name (Dept ), Salary (Emp), and HireDate (Emp)

Answer rating: 100% (QA)

Solution Here is a possible SQL script that performs the tasks we nedd... View the full answer