CODEWITHSUNDEEP
oracle-databaseoracle-adfjdeveloper
MCode007
MCode007

Reputation: 3

How to combine two tables/view objects into one in JDeveloper?

I have the following tables/view objects:

StudentRequest StudentApprovedRequests

I want to add a new StudentRequestHistory View object that simply combines both of these tables by displaying both of their content in one. This table is simply for visual/front end purposes, its does not exist in the database.

What I want is this:

StudentRequest View Object

StudentApprovedRequests View Object

StudentRequestHistory View Object

Really hope someone can help. Thank you!

Upvotes: 0

Views: 368

Answers (1)

Joe
Joe

Reputation: 3347

Define a VO based on a SQL query that uses the Union: https://docs.oracle.com/middleware/1213/adf/develop/adf-bc-vo-queries.htm

Upvotes: 1

Related Questions