Interested to Buy Any Domain ? << Click Here >> for more details...
2. Display the item number and total cost for each order
line (total cost = no of items X item cost). Name the
calculated column TOTAL COST.
- 2 Answers
- 4800 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / ajit
select itemnum,totalcost
from <tab name>
group by cube(itemnum, totalcost);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How a database is related to tablespaces?
How to create lov dynamically at runtime & attach to text field?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What are the arithmetic operations?
Respected sir, Please send me technical questions related to oracle apps..
Why cursor variables are easier to use than cursors?
What are the different types of trigger and explain its various uses and functions?
Is it possible to insert comments into sql statements return in the data model editor ?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What do you understand by a database object?
How to create a new tablespace in oracle?
What is a system tablespace?
How to export your connection information to a file?
How to handle a single quote in oracle sql?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
