You can create a JOIN in the Edit View dialog; once the JOIN node is selected, the Edit button is available.
When you click
, the default JOIN is USING in the Edit Join dialog because the key column in both tables is
Another way to populate a view and create a JOIN is to use the diagram. You can drag tables onto the view to add the table usages to the FROM clause of the view and all the columns to the SELECT clause. You can delete columns from the view using in-place editing. Alternatively you can select and drag individual columns from tables onto the view. You can have multiple table usages on the same view. You then need to create JOIN objects between the table usages in the view.
To do this, you would select Join Object in the Component Palette and click on the two table usages to be joined. This opens the Edit Join dialog, which would look similar to this:
You then select the Join properties. Use JDeveloper's code completion functionality to select the columns.
In the editor:
p' and select PERSONS
.p' and select PERSON_ID
Then do the same to get
Copyright © 1997, 2009, Oracle. All rights reserved.