Arc relationship (XOR) in Oracle SQL Sata Modeler?

oracle relationship foreign-key-relationship xor oracle-sql-data-modeler
kakavirus picture kakavirus · Oct 16, 2014 · Viewed 7.9k times · Source

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 pertain to Arc.

Answer

thatjeffsmith picture thatjeffsmith · Oct 17, 2014

You need to select the relationship lines in the diagram, and then hit the 'New Arc' button on the main toolbar.

From the help:

"To create an arc, do so after creating all the relationships to be included. Select the entity box, select all relationship lines to be included (hold Shift and click each line), and click the New Arc button in the toolbar."

enter image description here

Related questions

Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More
How do I limit the number of rows returned by an Oracle query after ordering?

Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I can do this: select * from sometable order by name limit 20,10 to get the 21st to the 30th rows (skip the …

Read More
ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More