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
4803 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 to define a procedure inside another procedure?

1026

Explain about achiever in sql?

1043

What are a collation and state the different types of collation sensitivity?

1176

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1117

How to connect to a remote server?

1131

What are operators in oracle?

1060

What is Java Pool in Oracle?

1176

What is oracle host variable?

1069

How to experiment a data lock in oracle?

1060

How to rollback the current transaction in oracle?

1057

how to make an oracle object

2363

Explain oracle’s system global area (sga).

1145

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2502

How to create a testing table in oracle?

995

Explain parameter file in oracle.

1035