Oracle SQL Developer Data Modeler

Posted on 2014-08-24
Last Modified: 2014-08-25
I am learning how to use the Oracle SQL Developer Data Modeler. This is not an academic assignment. I know how to create an entity. But I don’t know how to create the entity’s attributes. I’m working with the following:

Entity: Email
Description: The e-mail that was sent.
Attributes: Date, time, Message body text

How do I add an attribute to the diagram?
BrowserEntityRight Click Menu
Question by:Mark01
    LVL 12

    Accepted Solution

    you have to go properties of the entity i.e Email then in the left hand side you will get Attributes which you need to select then in the right hand window you will see the add button (+) where you can add your attributes of that entity.

    Please go through the oracle doc which has given the step by step process.
    LVL 16

    Assisted Solution

    by:Swadhin Ray
    You can create the DDL of the table and then you can import that on data modeler.

    Attached is the file can show some steps that I have created based on your attributes you have share.
    Hope this will help you.


    Author Closing Comment

    Thank you, and praveencpk and slobaray.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now