Write a sql query that will give the employee number

Assignment Help Computer Engineering

Reference no: EM131985137

Problem

Log on to ApEx and go to the Object Browser under the SQL Workshop menu. Look for the DEMO_PRODUCT_INFO table. Write down all of the column names for the table.

1. Navigate to the SQL command window and create a SQL query that will give the product ID, product description and product list price from the DEMO_PRODUCT_INFO table. Use the TO_CHAR function with the dollar/currency format to display the price in American dollars and cents.

In your submission include the SQL code and a screen shot of the result set.

2. Modify the previous SQL query so that it displays the date three months from now. To make this query as flexible as possible use SYSDATE with the LAST_DAY() function to get the last day of this month ('7-FEB-2017' in this particular case), along with the ADD_MONTHS() function to display the date three months from now. The purpose of this SELECT statement is to show how long the given price of the product will be in effect, so add a column alias to the date column saying "Price good until."

In your submission include the SQL code and a screen shot of the result set.

3. Write a SQL query that will give the employee number, employee name and hired date from the EMP table. Use the TO_CHAR function along with the format mask ‘DDMMYYY' to display the hired date.

In your submission include the SQL code and a screen shot of the result set.

4. Write a query that will select the ORDER_ID, CUSTOMER_ID and ORDER_TIMESTAMP columns from the demo_orders table. Use the to_char() function to display the date data from the ORDER_TIMESTAMP column in a format that has the day as two numbers, the month as the first three characters of the name of the month, the full year as numbers, the hour and the minute.

Reference no: EM131985137

Questions Cloud

Address this issue without divulging confidential : How will you, as a teacher, address this issue without divulging confidential information?

Why the value of the currencies in which carry trading : Explain why one can compare carry trade with picking up pennies in front of a steamroller. Use in your explanation the concept of interest-parity condition.

Unwanted behavior and increase desired behaviors : How can you provide positive behavior supports to prevent unwanted behavior and increase desired behaviors in school settings?

Describe limitations of activity-based costing and factors : BB210 Introductory Management Accounting Assignment. Describe the limitations of activity-based costing and factors that may impede the introduction of ABC

Write a sql query that will give the employee number : Write a SQL query that will give the employee number, employee name and hired date from the EMP table.

Planning advocacy for community social change : Why is it important to understand census data when planning advocacy for community social change? Please explain.

What single amount is equivalent to a series of equal : What single amount (to the closest dollar) on July 1, 2008 is equivalent to a series of equal, semi-annual cash flows of $1,200, starting with a cash flow.

Factors influencing impression formation and attraction : Kindly assist in reviewing the factors influencing impression formation and attraction with a dual list of behaviors

What is the flow process in the customer every hour : What is the flow process in the customer every hour? Assuming unlimited demand, what is the new flow rate if the center adds the server to bottleneck resource?

User Account

All Pages