title: What are the create view conditions in Oracle?
body: <p>I'm writing a program which is creating view with joining two tables. I have lack of information about how to join them.<br>
  When user choose two tables and their columns to be in one view, I need to join them together automatically for the user if it is possible. For this purpose I already found the code to find primary key and foreign key of tables.<br>
  With this knowledge how can I say which column of first table should join with which table of second table.<br>
  As I found information about this, Primary key of one table should join with Foreign key of another table. Is this right? Can be any other situation. I want to suggest to user that this join may work and they can modify it.</p>