Reference no: EM132111176
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.
In your submission include the SQL code and a screen shot of the result set.
|
Provide an overview of a defensive coding practice
: Provide an overview of a Defensive Coding Practice and/or Control for choosing a language with security in mind.
|
|
Write the matlab code lines that add 2 to the value
: Provide the matlab syntax that will ask a user at the command window to enter a name and assign the name to a variable called 'name'.
|
|
Write a sql query that shows the empno
: Write a SQL query that shows the empno, ename, job and total salary for all employees from the emp table and uses a sub-query to show employees.
|
|
Create a sql query that lists the id and policy id
: Create a SQL query that lists the ID, Policy ID, county, construction and line for residential properties between Clearwater in the south.
|
|
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.
|
|
Create a sql query that will use the count function
: Create a SQL query that will use the count function to return the number of employees in each department in the emp table.
|
|
A program to simulate signals of a pedestrian traffic light
: Specifically, the car lantern will light up for 10 seconds, then turn off and turn on the pedestrian traffic light for 7 seconds.
|
|
Create a sql query in the sql command window showing
: Create a SQL query in the SQL command window showing the empno, ename, job, sal, hiredate from the emp table.
|
|
Identify all of the structural constraints
: Identify all of the structural constraints. ER diagram required using CHEN'S notation with list of assumptions made.
|