Stack Overflow
Stack Overflow

Questions tagged [oracle-sql-data-modeler]

Oracle SQL Developer Data Modeler is a free graphical tool that enhances productivity and simplifies data modeling tasks.

Oracle SQL Developer Data Modeler

Oracle SQL Developer Data Modeler is a free graphical tool that enhances productivity and simplifies data modeling tasks. Using Oracle SQL Developer Data Modeler users can create, browse and edit, logical, relational, physical, multi-dimensional, and data type models. It provides an environment for capturing, modeling, managing, and exploiting metadata.

References

98 questions
20
votes
3 answers

How to export image of relational model in Oracle SQL Data Modeler?

I have a relational model in Oracle SQL Developer Data Modeler with tables and relationships. Is it possible to export that relational model to a image file?
Rubens Mariuzzo
  • 28,358
  • 27
  • 121
  • 148
4
votes
3 answers

Installing Oracle Datamodeler on Ubuntu 16.04

I'm in the process of setting up an oracle development environment on my Ubuntu 16.04 workstation. Installing Oracle 12c was a challenge, but there were several very useful tutorials that put me on the right track. Following Dizwell's instructions…
user3672527
  • 55
  • 1
  • 5
3
votes
1 answer

Oracle Data Modeler generated column name from datamodel too long

I'm trying to create a datamodel in the Oracle Data Modeler module that is available in Oracle SQL Developer. I would like to maintain my data dictionary from this model. To do this (I think) I need a generated DDL file for which the attributes are…
pSi
  • 31
  • 2
3
votes
1 answer

How to hide foreign key elements from tables in SQL Developer Data Modeler?

For example, I have two tables UNIT_OF_MEASUREMENT and PHYSICAL_QUANTITY. PHYSICAL_QUANTITY has a field what represents foreign key of UNIT_OF_MEASUREMENT table. When i add this relationship, PHYSICAL_QUANTITY_UNIT_OF_MEASUREMENT_FK at…
Ilya Rochev
  • 157
  • 1
  • 3
  • 13
2
votes
1 answer

Cached values of sequence in oracle

When I am generating sequence values from the below-created sequence trial_seq, it gave 1, 2, 21, 41, 4,...... CREATE SEQUENCE trial_seq MINVALUE 1 MAXVALUE 999999999999999999999999999 START WITH 1 INCREMENT BY 1 CACHE 20; I am confused with the…
saint_sharan
  • 119
  • 1
  • 12
2
votes
3 answers

Birthday with where clause

Can any one help me with this Script This is what i want to achive table id name tag_id status dob == ======= ======== ======== ======== 1 a 1 Married 02/23/1977 2 b 1 Single 02/23/1978 3 c 2…
Michael Codes
  • 135
  • 1
  • 10
2
votes
2 answers

How to buy more pieces of one product - best practices

We have tables pizza and orders SQL data modeler generates relational model like this: We forgot, that the customer can buy 2 or more of the same pizza. We found that we can add column pieces to table pizza_orders or we can create special primary…
Pivoman
  • 4,435
  • 5
  • 18
  • 30
2
votes
3 answers

Oracle SQL Data Modeler missing a PRIMARY KEY on DDL script export

The diagram has over 40 tables, most of them have a primary key defined. For some reason there is this one table, which has a primary key defined, but that's being ignored when I export the model to a DDL script. This is the "offending" key (even…
NotGaeL
  • 8,344
  • 5
  • 40
  • 70
2
votes
1 answer

Arc relationship (XOR) in Oracle SQL Sata Modeler?

I need to model database in Oracle SQL Developer Data Modeler. I have to create ARC relationship (XOR), but I don't know how. I have found checkbox "In Arc" in Foreign Keys properties, but it is disable (grey). I don't see any other options, which…
kakavirus
  • 23
  • 1
  • 3
1
vote
0 answers

Why did primal keys auto-generate for some of my entities when I converted my entity model to a relational model?

I produced a relational model from my entity model and some of my entitiess now have primal keys that I didn't generate. I will provide some images from the diagrams. My Add entity In the realatioanl model Add entity The problem is that these…
Brad Troll
  • 13
  • 3
1
vote
2 answers

Is there a table in Oracle Ebs that keeps the change log of the iban information?

I need to see when an iban changed in oracle ebs system. Is there a specific log table for that? SELECT * FROM iby_ext_bank_accounts I checked this table but ı couldnt find
Musa Keskin
  • 15
  • 4
1
vote
1 answer

Tables in Data Modeler's Browser, not showing in Oracle Connection

I created an entity-relationship diagram (logical model) and engineered it to a relational model. The tables were generated. Now I need to use them from the connection XE as you see in the picture. The tables I made can only be seen on the data…
Oifoif
  • 13
  • 5
1
vote
1 answer

Oracle Data Modeler Scripts Stopped Working

The scripts in newer Oracle Data Modeler seems to have stopped working. Even though the Oracle Nashorn is selected as the Scripting engine, it's not working with the newer version of data modeler. Not sure what settings needs to be enabled for the…
Shaounak Nasikkar
  • 194
  • 1
  • 11
1
vote
0 answers

How to increase the UI font size in SQL Developer Data Modeler 18.2?

I am using Data Modeler 18.2 and I want to increase the font size of the Interface, but I cannot find a way to do it. I managed to do in the main sqldeveloper, but even though I've searched through many folders and config files, in data modeler I…
momchil milkov
  • 11
  • 4
1
vote
1 answer

Oracle SQL Developer ERD not automatically Include Relationship Table

For example, I have tables below: employee (emp_id PK, name, ...) attendance (att_id PK, emp_id FK, ....) In Oracle SQL Developer, when I drag and drop the employee table into the Relational, it is not automatically included the attendance…
Spring
  • 831
  • 1
  • 12
  • 42
1
2 3 4 5 6 7