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 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
Get step-by-step solutions from verified subject matter experts
