Create a query based on the EMP table that satisfies the criteria below Use the TO_CHAR function to return the "commission" column with 2 digits to the right of the decimal point Use the TO_CHAR function to return the "commission" column with no digits to the right of the decimal point and no decimal point Use the CAST function to return the "commission" column as an integer with 7 digits Create a query based on the EMP table that satisfies the criteria below Use the TO_CHAR function to return the "hire date" column with its full date & time including a four-digit year on a 24-hour clock Use the TO_CHAR function to return the "hire date" column with its full date and time including a four-digit year on a 12-hour clock with an am/pm indicator Use the CAST function to return "hire date" as a VARCHAR2(10) A column called "End of Probation" calculated as "hire date" plus 90 days I have the basics of the queries. Just have an issue comnbining the statements.
Create a query based on the EMP table that satisfies the criteria below
Use the TO_CHAR function to return the "commission" column with 2 digits to the right of the decimal point
Use the TO_CHAR function to return the "commission" column with no digits to the right of the decimal point and no decimal point
Use the CAST function to return the "commission" column as an integer with 7 digits
Create a query based on the EMP table that satisfies the criteria below
Use the TO_CHAR function to return the "hire date" column with its full date & time including a four-digit year on a 24-hour clock
Use the TO_CHAR function to return the "hire date" column with its full date and time including a four-digit year on a 12-hour clock with an am/pm indicator
Use the CAST function to return "hire date" as a VARCHAR2(10)
A column called "End of Probation" calculated as "hire date" plus 90 days
I have the basics of the queries. Just have an issue comnbining the statements.
Solution:
When you install Oracle 11g Enterprise Edition there are couple databases you can chose from as Starter database. Below are the queries given from scott schema as your given table name EMP has match with that schema.
1.
select TO_CHAR(comm, '999.99') from scott.emp;
Step by step
Solved in 3 steps with 7 images
