| Oracle 9i HELP! [message #6718] |
Fri, 02 May 2003 10:13  |
Nazma Bepat
Messages: 34
Registered: May 2003
|
Member |
|
|
Thanks to everyone for all you help. I need to know the following:
Write a query that produces the following output concatenated. <course number>, has a cost of, <cost>, but will be increased this year by <10% of the cost >. Provide a column alias.
|
|
|
|
| Re: Oracle 9i HELP! [message #6749 is a reply to message #6718] |
Sun, 04 May 2003 23:58  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
SELECT tab.course_number
||', has a cost of, '
||tab.cost
||', but will be increased this year by '
||to_char(tab.cost/10) alias_name_comes_here
FROM _your_table_ tab
MHE
Here's a link for you: Oracle Online Documentation. Keep the URL in your mind. It might come in handy.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
