July 14th, 2013, 09:49 AM
-
Display a list of all book titles along with their percentage of markup
I've gotten it to display the percentage of markup correctly(as in, multiplied by 100 with no decimal places), but I cannot for the life of me get the percentage sign to display on the right of the values(i.e. 40, but not 40%).
Here's my code so far:
Code:
SELECT title, to_char(round((retail-cost)/retail*100), '99')
AS "MARKUP %" FROM BOOKS;
I've tried concatenating with both the + sign and the ampersand (&) sign, to no avail.
Nvm, managed to get it to work. Will post my solution soon.
July 16th, 2013, 10:07 AM
-
Originally Posted by darthvader45
I've gotten it . . . E t c . . .
I've tried concatenating with both the + sign and the ampersand (&) sign, to no avail.
Perhaps you could try using the "Oracle" concatenating symbol (function)?