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.
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
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How a database is related to tablespaces?
How to assign a table row to a record variable?
What are group functions in oracle?
Explain the characteristics of oracle dba?
In the oracle version 9.3.0.5.0, what does each number shows?
Can a formula column be obtained through a select statement ?
How to use group functions in the select clause using oracle?
How do you bind variables in oracle?
How to create a table interactively?
What is a proxy class?
What is the difference between primary key and unique key and foreign key in oracle?
What is rich query?
Is postgres faster than oracle?
what is difference between sql plus and sql*plus? (not sql and sql plus).