oracle-databaseoracle-sqldeveloperoracle-sql-data-modeler
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 table.
Is there an option to enable (automatically included the relationship tables)?
Solution
Yes.
When you drag over your 'driving' table, CTRL+CLICK and Drag to the Modeling area.
- Orcale SQL select next and previous 3 rows of a specific row in groups
- Oracle SQL developer error: could not install some modules
- How to exit sqlplus when error happens
- What is the difference between -Xss and -XX:ThreadStackSize?
- EF query to Oracle throwing "ORA-12704: character set mismatch"
- Load data to remote DB using sqlldr
- Oracle ORDERED hint cost vs speed
- Oracle Merge Statement Raises "ORA-02012: missing USING keyword" Error
- How to debug a SP response in Quarkus using EntityManager
- How to avoid variable substitution in Oracle SQL Developer
- How to use Function inside of MERGE USING clause in Oracle?
- ORA-01861 Error When Trying to Create WHERE Date is 6 Months From Current Date
- Identify the content type within a BLOB field
- Does Connection pool also closes associated Session on the Database?
- Is it possible to use GROUP BY with bind variables?
- How to insert an "Optimizer hint" to Hibernate criteria api query
- Spring boot with Oracle AQ and Universal Connection Pool
- SQL/Oracle: Is it possible to have a group function in a check constraint?
- With python-oracledb what does 'DPY-4027: no configuration directory to search for tnsnames.ora' mean
- Return multiple ref cursors in single OUT parameter of stored procedure
- Creating triggers with table referencing
- Does Oracle have an equivalent of SQL Server's table variables?
- Oracle: What does `(+)` do in a WHERE clause?
- Oracle database 19C, In SQL query how to compare '["a", "b"]' = '["b", "a"]' is TRUE
- How to treat MAX() of an empty table as 0 instead of NULL
- Optimizing OLE DB Destination for Fast load from Oracle to SQL Server for SSIS
- Oracle client appears to be transmitting all 4000 varchar characters for each row
- Java JDBC executeUpdate not working on Delete SQL with TRUNC function in where clause
- Oracle thinks table doesn't exist during alter
- Update statement using with clause