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:
I've tried concatenating with both the + sign and the ampersand (&) sign, to no avail.
SELECT title, to_char(round((retail-cost)/retail*100), '99')
AS "MARKUP %" FROM BOOKS;
Nvm, managed to get it to work. Will post my solution soon.
July 16th, 2013, 10:07 AM
Perhaps you could try using the "Oracle" concatenating symbol (function)?
Originally Posted by darthvader45