Question: In SQL (Oracle), write a script that includes an anonymous block that performs the following: -Prompts the user for a date in the future (SQL

In SQL (Oracle), write a script that includes an anonymous block that performs the following:

-Prompts the user for a date in the future (SQL Plus commands)

-Calculates the difference between that date and the current date (storing in an (appropriate INTERVAL data type)

-Converts the INTERVAL results into a CHAR data type

-Stores the number of years in a variable

-Stores the number of months in a variable

-Displays a message similar to the following: "There is a difference of 5 years and 3 months"

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

ORACLE SQL Write a script that includes an anonymous block that performs the following. prompts the user for a date in the future (SQL Plus commands) Calculates the difference between that date and...

Q:

Write a script that includes an anonymous block that performs the following. prompts the user for a date in the future (SQL Plus commands) Calculates the difference between that date and the current...

Q:

Use SQL Developer to complete this and future course assignments. Make sure your access as the user CIS_436 is permitted. If possible, please save a connection to enable the use of the SQL Developer...

Q:

CHA P TER 9 Understanding Software: A Primer for Managers 1. INTRODUCTION L E A R N I N G O B J E C T I V E S 1. Recognize the importance of software and its implications for the rm and strategic...

Q:

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Q:

Read: Strategic Management Cases Case Study #12 Pixar Case Study #20 Nintendo: Could the Switch Turn on Gamers? Prepare a written SWOT analysis for each company using the information provided in the...

Q:

If could, I would like to send you the word and pdf files to make it easier for you to solve the problem. You are working with the following relational schema for a university's course management...

Q:

Here is the schema for it Please use Oracle SQL to write SQL statements. I need it as soon as possible. Thank you. ASSIGNMENT 1 (SQL) Use the attached schema for this assignment . Write a select...

Q:

execute the scripts within your Oracle environment by executing them in this order: midterm.sql, midterm-data.sql, insert-words.sql, insert-counts.sql. These scripts create and populate four tables...

Q:

Can someone Help me to solve this: SQL > DESC employees Name Null? Type-------------------------EMPLOYEE_ID not NULL Number SQL > DESC departments Name Null?...

Q:

Please help with the question below, thank you Common teamwork barriers that can lead to a sentinel event include these problems: Inconsistency in team leaders Lack of time to meet and interact as a...

Q:

A flow field in the x-y plane is described by u = Uo = constant, v = Vo = constant. Convert these velocities into plane polar coordinate velocities, vr and vθ. V. U.

Q:

CA4.3 (LO 2) (Identifying Statement of Financial Position Deficiencies) The assets of Fonzarelli SpA are presented as follows (amounts in thousands). Fonzarelli SpA Statement of Financial Position...

Q:

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Q:

h. How has your family status changed through the generations? Compare your family experience with those of your classmates. Did most immigrants come for the same reasons? What are the differences in...

Q:

b. Where did they come from?

Q:

g. What were their occupations before they came, and what jobs did they take on their arrival?