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
4696 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

How do I reset a sequence in oracle?

1053

What is sharded cluster?

926

What is the difference between count (*), count (expression), count (distinct expression)?

966

How to download oracle database 10g xe?

960

Can you drop an index associated with a unique or primary key constraint?

970

WHAT IS ecc 6.0

2103

What is ADDM Advisor in Oracle?

1117

Explain integrity constraints?

1060

Does facebook use oracle?

982

How to define a variable to match a table column data type?

938

what's query optimization and without use of IN AND Exist can we get another way data from query

2090

How to delete an existing row from a table in oracle?

1019

What is transport network substrate (tns) in oracle?

994

How to define an oracle sub procedure?

1058

What happens to the current transaction if the session is ended?

1038