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

Which environment variables are absolutely critical in order to run the OUI?

2104

How to use like conditions in oracle?

1025

Describe varray?

1038

what is the use of system.effective.date variable in oracle?

1087

Does oracle partitioning improve performance?

968

Explain the truncate in oracle?

945

How to login to the server without an instance?

1145

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

1000

Is a rollback possible to any savepoint?

1077

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2305

What is partitioned table in Oracle?

1169

Why do we use coalesce function in oracle?

1097

How to export data to a csv file?

1274

How to execute a stored procedure in oracle?

1067

What is meant by recursive hints in oracle?

1070