Question: PL/SQL will probably use (declare, begin, end) not sure Many screens and reports use dollar amounts. Create a function called DOLLAR _FMT that will format

 PL/SQL will probably use (declare, begin, end) not sure Many screens

PL/SQL will probably use (declare, begin, end) not sure

Many screens and reports use dollar amounts. Create a function called DOLLAR _FMT that will format the number provided as an argument with a dollar sign, commas and two decimal places such as: $99,999.99 Test the using the following statement: SELECT FIRSTNAME, LAST NAME, DOLLAR FMT(SALARY) AS SALARY FROM EMPLOYEES; - You should get the following results (partial listing) $24,000.00 $17,000.00 $17,000.00 $9,000.00 $6,000.00 $4,800.00 King Kechhar De Haan Steven Neena Lex Alexander Hunold Bruce David Valli Diana Nancy Daniel Ernst Austin Pataballa 4, 800.00 Lorentz Greenberg $12,000.00 Faviet $4,200.00 $9,000.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!