1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

create relationship between two tables.

Discussion in 'General' started by priyappated, May 15, 2009.

  1. priyappated

    priyappated Guest

    Hi all,

    I am new to Oracle 10g, I managed to create tables in it but I am unable to create relationship between two tables..., can anyone tell me how to do that. I am using Oracle Enterprise Manager. As well if anyone can tell me how to generate SQL for created tables.

    Thanks in advance
    Priya
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
  3. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    This is done using Foreign keys


    For for the Create script , You can use DBMS_METADATA. It will extract the DDL for the object. Almost all Oracle GUI Tools like TOAD, PL/SQL DEVELPOPER etc provide the DDL script in more user friendly way.