Using the "Starter Database" configured during the installation of "Oracle 11g Enterprise Edition", write an SQL script that performs the following,

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