Create views whose columns are the result of a query Oracle

Asked Jan 05 '19 at 11:17

Active Jan 05 '19 at 11:17

Viewed 27 times

I've limited knowledge of Oracle and its PSQL language. I am trying to create two views which gave me simpler access to the data I need for an application I am working on.

Given a table:

I would like to create the sold and bought views. Any suggestions?

asked Jan 05 '19 at 11:17

Giuseppe Pes

7,772
3
52
90

1

how many company names can the table have? – Vamsi Prabhala Jan 05 '19 at 11:18
roughly 2 thousands – Giuseppe Pes Jan 05 '19 at 11:26
1

Then you should PIVOT, but do you understand that it would mean 2000 columns? – Thomas G Jan 05 '19 at 11:27
@VamsiPrabhala this is not a duplication as I am not able to use an aggregation operator in the table – Giuseppe Pes Jan 05 '19 at 11:53

Create views whose columns are the result of a query Oracle

0 Answers0