Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please solve in SQL database 1) You want Oracle to show how old are you. Show syntax for how old are you? 2) TO_CHAR command

Please solve in SQL database

1)

You want Oracle to show how old are you. Show syntax for how old are you?

2)

TO_CHAR command with LOW and HIGH columns

Create a query that will format the DJs on Demand d_packages columns,low-rangeand high-range package costs, in the format $2500.00.

3)

TO_CHAR command Ellen Abel is an employee who has received a $2,000 raise. Display her first name and last name, her current salary, and her new salary. Display both salaries with a $ and two decimal places. Label her new salary column AS New Salary. 4)

TO_CHAR command

Convert todays date to a format such as:Today is the Twentieth of March,TwoThousand Four

5) TO_CHAR command

List the last names and birthdays of Global Fast Food Employees. Convertthebirthdates to character data in the Month DD, YYYY format. Suppress any leading zeros. (from f_staffs table); 6) Use ROUND then(ADD_MONTH command ( Display the days between January1 and December31.

7) NEXT_DAY command Whats the date of the next Friday after your birthday this year? Name the output, First Friday.

8) Using DUAL, write a statement that will convert 86.678 to 86.68. 9) Using DUAL,convert 73.892 to 73.8 ?

10) NEXT_DAY command

What is the next Friday six months from now? Label the column Future.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Principles Programming And Performance

Authors: Patrick O'Neil

1st Edition

1558603921, 978-1558603929

More Books

Students also viewed these Databases questions

Question

14-18 Compare the two major types of planning and control tools.

Answered: 1 week ago