Question: 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

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!