ANS: SELECT ITEM_NO , NO_OF_ITEMS*INDIVIDUAL_ITEM

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.

Question Posted / girija.112

2 Answers
4908 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / girija.112

ANS:
SELECT ITEM_NO , NO_OF_ITEMS*INDIVIDUAL_ITEM_COST AS "TOTAL COST"
FROM ITEM_TABLE

ITEM_NO TOTAL COST
1001 30000
1002 40000
1003 72000
1004 100000
1006 40000
1007 60000
1008 80000
1009 -
1010 56000

I have assumed that ITEM_NO, NO_OF_ITEMS &
INDIVIDUAL_ITEM_COST columns are in a single table ITEM_TABLE

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1789

Will you be able to store pictures in the database?

1174

Differentiate between function and procedure in oracle.

1154

How to assign query results to variables?

1096

State any two functions of oracle?

1097

How to pass parameters to procedures?

1089

How to return top 5 rows in oracle?

1112

What are the four Oracle system processes that must always be up and running for the database to be useable?

1051

How to use null as conditions in oracle?

1125

What are the original export and import utilities?

1258

What are the extensions used by oracle reports?

1089

1) Does oracle have any table which contain all the exceptions and it's code internally?

1803

Query to retrieve record for a many to many relationship ?

2576

What exactly do quotation marks around the table name do?

1025

Explain the use of file option in exp command.

1177