Table Linkage

[informer30]

Hi All,

is there a way in oracle you can view the linkage of tables
as you can in SQL enterprise manager?

Ps. I am new to oracle..

Many Thanks

 

[taupirho]

Can you explain a little more and perhaps give an example. I'm not sure what you mean.


In order to understand recursion, you must first understand recursion.

 

[informer30]

I want to see the table linkage...for example

employees.employee_id = sales.employee_id

this to be show as tables and the linkage represented. Rather than written in code as above...?

Many Thanks

 

[LKBrwnDBA]

Query DBA_CONSTRAINTS Where Constraint_type = 'F'.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[informer30]

I am new to oracle, please can you advise what that does?

Thanks

 

[LKBrwnDBA]

You should search the forums:

http://www.tek-tips.com/viewthread.cfm?qid=1092173

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[informer30]

Thanks for the link, but that does not resolve my question.

I am after a db linkage diagram in oracle and if this is possible...rather than displaying code, I want to see ERD in oracle....

Is this posssible?

 

[LKBrwnDBA]

Yes, if you get ERD software (program) to do it, you can see an ERD diagram of the databse.

There are many free and not so free programs that reverse engineer an Oracle database schema.

Check out some of these.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[informer30]

Thanks, but I am asking if a schema is available within orcale?

Thanks

 

[LKBrwnDBA]

So, what IS the question?:

is there a way in oracle you can view the linkage of tables

or

but I am asking if a schema is available within orcale?

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[informer30]

Hi

the first one is correct question:

is there a way in oracle you can view the linkage of tables


Thanks

 

[Turkbear]

Hi,
Not in Oracle (the DBMS) itself - Oracle does have ERD tools to create such a diagram as do 3rd party companies.

This link has some listed:

http://www.dba-oracle.com/t_case_tools_entity_relation_diagram_erd.htm

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[LKBrwnDBA]

You should have checked the forums, here is another script.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[informer30]

Hi All,

thanks for your help, the point I was making and trying to get to was the 'Query Builder'..which I have know found.

In query builder why can't I just double click or drag and drop a table from the object explorer and bring into the linkage?

Many Thanks