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.