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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started