4 Replies Latest reply: May 22, 2013 4:26 AM by David Last-Oracle RSS

    Sql Developer. How to

    1009848
      Нужна помощь.Как стрелочки(связи )которые устанавливаются между сущьностями, подписать можно ? Как им дать название?
      Как создается и где удаленный ключ, и для чего он нужен.
      И как ссылки создаются на объекты или между ними?
      За ранее огромное спасибо.

      The help is necessary. How strelochka (communication) which are established between sushchnost, it is possible to sign? How to give them the name?
      As it is created and where a remote key and for what it is necessary.
      And how references are created on objects or between them?
      For earlier many thanks.

      Edited by: 1006845 on 20.05.2013 2:33
        • 1. Re: Sql Developer. How to
          riedelme
          1006845 wrote:
          The help is necessary. How strelochka (communication) which are established between sushchnost, it is possible to sign? How to give them the name?
          Welcome to OTN!

          SQL*Developer communications are established by creating connections to the desired database.

          Start SQL*Developer. right click on the connecitons icon, and choose Create Connection. Fill in the information to the database server including username and password and test the connection.
          As it is created and where a remote key and for what it is necessary.
          After you can connect to the database you can use the object browser to find the objects available to the schema you logged in as. You can create database objects if the schema has those priveleges.
          And how references are created on objects or between them?
          What do you mean by "references"?
          • 2. Re: Sql Developer. How to
            K_Serge
            Don't have answer, just will try to help translate question.

            It looks like question mostly related to Data Modeler facilities within SQL Developer.
            and following world should be:
            strelochka (communication) means Relation
            sushchnost means Entity
            remote key means ForeiginKey
            • 3. Re: Sql Developer. How to
              1009848
              Yes thats it!The problem is that I do not know how links are established, such as many-to-many, and how references are made from one entity to another
              • 4. Re: Sql Developer. How to
                David Last-Oracle
                When Logical Model diagram is displayed in Data Modeler or SQL Developer, a set of icon buttons are displayed above the diagram.
                These include a "New Entity" button and also "New M:N Relation" and "New 1:N Relation" buttons.

                To add a many-to-many Relationship, use the "New M:N Relation" button, click over one of the Entities on the diagram, then click over the other Entity on the diagram.
                The Relation Properties dialog is then displayed, allowing you to provide a Name for the Relationship and any other details.

                There is actually a forum specifically for Data Modeler: SQL Developer Data Modeler

                David