The following data exists in the PRODUCTS table:
PROD_ID PROD_LIST_PRICE
——– ——————————
123456 152525.99
You issue the following query:
SQL> SELECT RPAD(( ROUND(prod_list_price)), 10,’*’)
FROM products
WHERE prod_id = 123456;
What would be the outcome?
A.
152526 ****
B.
**152525.99
C.
152525** **
D.
an error message
Explanation:
The LPAD(string, length after padding, padding string) and RPAD(string, length after padding,
padding string) functions add a padding string of characters to the left or right of a string until it
reaches the specified length after padding.