Data base diagram , help pls

[Raghuraman]

HI friends,
I am new to oracle 9i, but a sqlserver professional.am now under
oracle.How can i see the relationship between the database tables in
oracle in terms of database diagram .

Thanks a lot
Raghu

[Jack]

Use oracle designer...
http://www.oracle.com/technology/products/designer/index.html

"Raghuraman" <raghuraman_ace@rediffmail.com> wrote in message
news:66c7bef8.0409220103.5d750b7e@posting.google.com... HI friends, I am new to oracle 9i, but a sqlserver professional.am now under oracle.How can i see the relationship between the database tables in oracle in terms of database diagram . Thanks a lot Raghu

[Daniel Morgan]

Jack wrote: Use oracle designer... http://www.oracle.com/technology/products/designer/index.html "Raghuraman" <raghuraman_ace@rediffmail.com> wrote in message news:66c7bef8.0409220103.5d750b7e@posting.google.com...HI friends,I am new to oracle 9i, but a sqlserver professional.am now underoracle.How can i see the relationship between the database tables inoracle in terms of database diagram .Thanks a lotRaghu

Or ERwin or dbArtisan or any other third-party product that provides
this capability. Unlike M$ ... Oracle does not see at as its mission
to put every other software company out of business.

You can also print the information from the data dictionary:

SELECT t.owner CHILD_OWNER,
t.table_name CHILD_TABLE,
t.constraint_name FOREIGN_KEY_NAME,
r.owner PARENT_OWNER,
r.table_name PARENT_TABLE,
r.constraint_name PARENT_CONSTRAINT
FROM user_constraints t, user_constraints r
WHERE t.r_constraint_name = r.constraint_name
AND t.r_owner = r.owner
AND t.constraint_type='R'
AND t.table_name = <child_table_name>;

--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

[Rick van Dijk]

hello raghu,

Maybe our tool, DeZign for Databases is something for you. It is a data
modeling tool. You can find more info at
http://www.datanamic.com/dezign/index.html. A 30 day evaluation version is
available at http://www.datanamic.com/download/index.html.

Regards,

Rick van Dijk

** Datanamic **
Tools for Database Developers
http://www.datanamic.com


"Raghuraman" <raghuraman_ace@rediffmail.com> schreef in bericht
news:66c7bef8.0409220103.5d750b7e@posting.google.com... HI friends, I am new to oracle 9i, but a sqlserver professional.am now under oracle.How can i see the relationship between the database tables in oracle in terms of database diagram . Thanks a lot Raghu

[Sybrand Bakker]

On Wed, 22 Sep 2004 17:20:16 +0200, "Rick van Dijk"
<rick@datanamic.com> wrote:
Maybe our tool, DeZign for Databases is something for you. It is a datamodeling tool. You can find more info athttp://www.datanamic.com/dezign/index.html. A 30 day evaluation version isavailable at http://www.datanamic.com/download/index.html.Regards,Rick van Dijk** Datanamic **Tools for Database Developershttp://www.datanamic.com

Please be informed your post is spam, and to promote your own product
in replying is considered unethical.


--
Sybrand Bakker, Senior Oracle DBA

[Hans Forbrich]

Sybrand Bakker wrote:
On Wed, 22 Sep 2004 17:20:16 +0200, "Rick van Dijk" <rick@datanamic.com> wrote:Maybe our tool, DeZign for Databases is something for you. It is a datamodeling tool. You can find more info athttp://www.datanamic.com/dezign/index.html. A 30 day evaluation version isavailable at http://www.datanamic.com/download/index.html.Regards,Rick van Dijk** Datanamic **Tools for Database Developershttp://www.datanamic.com Please be informed your post is spam, and to promote your own product in replying is considered unethical.

This one is somewhat tricky. It is a legitimate response to the OP's
question. However, we've seen a number of cases where the original
question is really nothing more than a setup to 'legitimize' the spam.

The response could have also mentioned one or two alternatives.

/Hans

[Mark C. Stock]

"Hans Forbrich" <news.hans@telus.net> wrote in message
news:uql4d.125417$XP3.77689@edtnps84...
| Sybrand Bakker wrote:
|
| > On Wed, 22 Sep 2004 17:20:16 +0200, "Rick van Dijk"
| > <rick@datanamic.com> wrote:
| >
| >>
| >>Maybe our tool, DeZign for Databases is something for you. It is a data
| >>modeling tool. You can find more info at
| >>http://www.datanamic.com/dezign/index.html. A 30 day evaluation version
is
| >>available at http://www.datanamic.com/download/index.html.
| >>
| >>Regards,
| >>
| >>Rick van Dijk
| >>
| >>** Datanamic **
| >>Tools for Database Developers
| >>http://www.datanamic.com
| >
| > Please be informed your post is spam, and to promote your own product
| > in replying is considered unethical.
| >
|
| This one is somewhat tricky. It is a legitimate response to the OP's
| question. However, we've seen a number of cases where the original
| question is really nothing more than a setup to 'legitimize' the spam.
|
| The response could have also mentioned one or two alternatives.
|
| /Hans

Good balance Hans.

I've tried the product, and actually know through a friend of a friend one
of the guys marketing it in the states -- only to say that Rick's legit, I
won't comment on the product here, except to say that my experience was
positive

I could see posting a cross reference to c.d.o.marketplace (see my response
in ...) just to keep 'altruistic' responses from any 'tainted' by
marketing -- sound like a good approach?

By the way, Rick -- are you the same RvD that used to work in Oracle
Education? If so, contact me offline. But probably not, wrong side of the
pond. Unless it was some other division of Oracle?

++ mcs

[Daniel Morgan]

Rick van Dijk wrote:
hello raghu, Maybe our tool, DeZign for Databases is something for you. It is a data modeling tool. You can find more info at http://www.datanamic.com/dezign/index.html. A 30 day evaluation version is available at http://www.datanamic.com/download/index.html. Regards, Rick van Dijk ** Datanamic ** Tools for Database Developers http://www.datanamic.com "Raghuraman" <raghuraman_ace@rediffmail.com> schreef in bericht news:66c7bef8.0409220103.5d750b7e@posting.google.com...HI friends, I am new to oracle 9i, but a sqlserver professional.am now underoracle.How can i see the relationship between the database tables inoracle in terms of database diagram .Thanks a lotRaghu

Please do not use our forum for purposes of marketing.

If you wish to advertise please do so at c.d.o.marketplace.

Thank you.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

[Daniel Morgan]

Mark C. Stock wrote:
"Hans Forbrich" <news.hans@telus.net> wrote in message news:uql4d.125417$XP3.77689@edtnps84... | Sybrand Bakker wrote: | | > On Wed, 22 Sep 2004 17:20:16 +0200, "Rick van Dijk" | > <rick@datanamic.com> wrote: | > | >> | >>Maybe our tool, DeZign for Databases is something for you. It is a data | >>modeling tool. You can find more info at | >>http://www.datanamic.com/dezign/index.html. A 30 day evaluation version is | >>available at http://www.datanamic.com/download/index.html. | >> | >>Regards, | >> | >>Rick van Dijk | >> | >>** Datanamic ** | >>Tools for Database Developers | >>http://www.datanamic.com | > | > Please be informed your post is spam, and to promote your own product | > in replying is considered unethical. | > | | This one is somewhat tricky. It is a legitimate response to the OP's | question. However, we've seen a number of cases where the original | question is really nothing more than a setup to 'legitimize' the spam. | | The response could have also mentioned one or two alternatives. | | /Hans Good balance Hans. I've tried the product, and actually know through a friend of a friend one of the guys marketing it in the states -- only to say that Rick's legit, I won't comment on the product here, except to say that my experience was positive I could see posting a cross reference to c.d.o.marketplace (see my response in ...) just to keep 'altruistic' responses from any 'tainted' by marketing -- sound like a good approach? By the way, Rick -- are you the same RvD that used to work in Oracle Education? If so, contact me offline. But probably not, wrong side of the pond. Unless it was some other division of Oracle? ++ mcs

I would have been happy if he had named three or four products and his
had been one of them. That would be legitimately trying to help the OP.
To just promote a single product from which one derives their income is
spam from where I sit.

--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

[Rick van Dijk]

hello daniel and group,

I'm sorry. I will not do it anymore here. I can imagine that some people may
have problems with it in some groups. Therefor I'll make it good. On this
site you'll find a complete list of database modeling tools:

http://www.databaseanswers.com/modelling_tools.htm

But, I don't think it it 'unethical' to promote your own product. It is very
difficult not to reply when you can talk about your own product :).

--

Regards,

Rick van Dijk

** Datanamic **
Tools for Database Developers
http://www.datanamic.com

** Datanamic Solutions B.V. **
Ir. Driessenstraat 94F ** 2312 KZ Leiden ** The Netherlands

** E-Mail Adresses **
support@datanamic.com
sales@datanamic.com
info@datanamic.com

"Daniel Morgan" <damorgan@x.washington.edu> schreef in bericht
news:1095896002.82533@yasure... Rick van Dijk wrote: hello raghu, Maybe our tool, DeZign for Databases is something for you. It is a data modeling tool. You can find more info at http://www.datanamic.com/dezign/index.html. A 30 day evaluation version
is available at http://www.datanamic.com/download/index.html. Regards, Rick van Dijk ** Datanamic ** Tools for Database Developers http://www.datanamic.com "Raghuraman" <raghuraman_ace@rediffmail.com> schreef in bericht news:66c7bef8.0409220103.5d750b7e@posting.google.com...HI friends, I am new to oracle 9i, but a sqlserver professional.am now underoracle.How can i see the relationship between the database tables inoracle in terms of database diagram .Thanks a lotRaghu Please do not use our forum for purposes of marketing. If you wish to advertise please do so at c.d.o.marketplace. Thank you. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond)

[Hans Forbrich]

Rick van Dijk wrote:
hello daniel and group, I'm sorry. I will not do it anymore here. I can imagine that some people may have problems with it in some groups. Therefor I'll make it good. On this site you'll find a complete list of database modeling tools: http://www.databaseanswers.com/modelling_tools.htm But, I don't think it it 'unethical' to promote your own product. It is very difficult not to reply when you can talk about your own product :).

It's a fine line. Change the phrasing a bit and you _can_ talk about your
own product. For example, the original response could have been something
like:

--------------

There are a number of tools designed to do this. A list can be found at
http://www.databaseanswers.com/modelling_tools.htm

/Rick
btw: One tool, DeZign for Databases, is available from the organization
with which I work. Contact me offline or get more information at
http://www.datanamic.com/dezign/index.html

--------------

In this group, we have become hyper-sensitive about self-promotion and spam.
We have had a few people who have been absurdly persistant.

The above might get an "it's spam" reaction which could be easily ignored as
it provides alternatives up front AND puts the 'advertisment' after the
signature as a footnote.

Probably most important when being accused of spam here (which you did) -
apologize and don't argue. Thank you!

/Hans

[Ed prochak]

"Rick van Dijk" <rick@datanamic.com> wrote in message news:<ciu4eq$dfm$1@reader13.wxs.nl>... hello daniel and group, I'm sorry. I will not do it anymore here. I can imagine that some people may have problems with it in some groups. Therefor I'll make it good. On this site you'll find a complete list of database modeling tools: http://www.databaseanswers.com/modelling_tools.htm But, I don't think it it 'unethical' to promote your own product. It is very difficult not to reply when you can talk about your own product :). -- Regards, Rick van Dijk ** Datanamic ** Tools for Database Developers http://www.datanamic.com ** Datanamic Solutions B.V. ** Ir. Driessenstraat 94F ** 2312 KZ Leiden ** The Netherlands ** E-Mail Adresses ** support@datanamic.com sales@datanamic.com info@datanamic.com



I think I've posted before that I think describing products in
response to ligitimate questions is valid. As mentioned, the issue of
knowing whether there is a set up or not. This is a tough call.

Also, You may have hit the group during a stressful time (ie, when
we've just had a spate of spammers and trolls). So I'm not encouraging
you, but I guess we can say this is close to the line. The OP did ask
for products, so I don't hink you crossed that line.

So have a good day and good luck with sales.
Ed

[Joel Garry]

"Mark C. Stock" <mcstockX@Xenquery .com> wrote in message news:<Op6dncXEVazve8zcRVn-og@comcast.com>... "Hans Forbrich" <news.hans@telus.net> wrote in message news:uql4d.125417$XP3.77689@edtnps84... | Sybrand Bakker wrote: | | > On Wed, 22 Sep 2004 17:20:16 +0200, "Rick van Dijk" | > <rick@datanamic.com> wrote: | > | >> | >>Maybe our tool, DeZign for Databases is something for you. It is a data | >>modeling tool. You can find more info at | >>http://www.datanamic.com/dezign/index.html. A 30 day evaluation version is | >>available at http://www.datanamic.com/download/index.html. | >> | >>Regards, | >> | >>Rick van Dijk | >> | >>** Datanamic ** | >>Tools for Database Developers | >>http://www.datanamic.com | > | > Please be informed your post is spam, and to promote your own product | > in replying is considered unethical. | > | | This one is somewhat tricky. It is a legitimate response to the OP's | question. However, we've seen a number of cases where the original | question is really nothing more than a setup to 'legitimize' the spam. | | The response could have also mentioned one or two alternatives. | | /Hans Good balance Hans. I've tried the product, and actually know through a friend of a friend one of the guys marketing it in the states -- only to say that Rick's legit, I won't comment on the product here, except to say that my experience was positive I could see posting a cross reference to c.d.o.marketplace (see my response in ...) just to keep 'altruistic' responses from any 'tainted' by marketing -- sound like a good approach?

Doesn't seem much different than crossposting, sets up loophole like
opt-out in email (spammers can comply with can-spam act while putting
in nasty code in remove or contact link).

Of course, legitimizing the "multiple alternatives" has it's own
risks. The basic problem is that anyone who's job is marketing is
going to, at minimum, feel they must try to get any edge possible for
their product, and that's if they are ethical, which some obviously
aren't.

I still have mixed feelings about all this. I think that allowing a
direct response such as Rick's ought to be ok, yet Daniel has
convinced me otherwise.

jg
--
@home.com is bogus.
http://www.ent.iastate.edu/misc/insectsasfood.html

[Mark C. Stock]

"Joel Garry" <joel-garry@home.com> wrote in message
news:91884734.0409231329.18dc1bde@posting.google.com...
| "Mark C. Stock" <mcstockX@Xenquery .com> wrote in message
news:<Op6dncXEVazve8zcRVn-og@comcast.com>...
| > "Hans Forbrich" <news.hans@telus.net> wrote in message
| > news:uql4d.125417$XP3.77689@edtnps84...
| > | Sybrand Bakker wrote:
| > |
| > | > On Wed, 22 Sep 2004 17:20:16 +0200, "Rick van Dijk"
| > | > <rick@datanamic.com> wrote:
| > | >
| > | >>
| > | >>Maybe our tool, DeZign for Databases is something for you. It is a
data
| > | >>modeling tool. You can find more info at
| > | >>http://www.datanamic.com/dezign/index.html. A 30 day evaluation
version
| > is
| > | >>available at http://www.datanamic.com/download/index.html.
| > | >>
| > | >>Regards,
| > | >>
| > | >>Rick van Dijk
| > | >>
| > | >>** Datanamic **
| > | >>Tools for Database Developers
| > | >>http://www.datanamic.com
| > | >
| > | > Please be informed your post is spam, and to promote your own
product
| > | > in replying is considered unethical.
| > | >
| > |
| > | This one is somewhat tricky. It is a legitimate response to the OP's
| > | question. However, we've seen a number of cases where the original
| > | question is really nothing more than a setup to 'legitimize' the spam.
| > |
| > | The response could have also mentioned one or two alternatives.
| > |
| > | /Hans
| >
| > Good balance Hans.
| >
| > I've tried the product, and actually know through a friend of a friend
one
| > of the guys marketing it in the states -- only to say that Rick's legit,
I
| > won't comment on the product here, except to say that my experience was
| > positive
| >
| > I could see posting a cross reference to c.d.o.marketplace (see my
response
| > in ...) just to keep 'altruistic' responses from any 'tainted' by
| > marketing -- sound like a good approach?
|
| Doesn't seem much different than crossposting, sets up loophole like
| opt-out in email (spammers can comply with can-spam act while putting
| in nasty code in remove or contact link).
|
| Of course, legitimizing the "multiple alternatives" has it's own
| risks. The basic problem is that anyone who's job is marketing is
| going to, at minimum, feel they must try to get any edge possible for
| their product, and that's if they are ethical, which some obviously
| aren't.
|
| I still have mixed feelings about all this. I think that allowing a
| direct response such as Rick's ought to be ok, yet Daniel has
| convinced me otherwise.
|
| jg
| --
| @home.com is bogus.
| http://www.ent.iastate.edu/misc/insectsasfood.html


then the appropriate option for anyone that wants to respond to something
specifically in a commercial way is don't, but go ahead and post something
timely about your product or service in c.d.o.marketplace -- without a
cross-reference reply to the OP

++ mcs

[Hans Forbrich]

Joel Garry wrote:
"Mark C. Stock" <mcstockX@Xenquery .com> wrote in message news:<Op6dncXEVazve8zcRVn-og@comcast.com>... "Hans Forbrich" <news.hans@telus.net> wrote in message news:uql4d.125417$XP3.77689@edtnps84... | Sybrand Bakker wrote: | | > On Wed, 22 Sep 2004 17:20:16 +0200, "Rick van Dijk" | > <rick@datanamic.com> wrote: | > | >> | >>Maybe our tool, DeZign for Databases is something for you. It is a | >>data modeling tool. You can find more info at | >>http://www.datanamic.com/dezign/index.html. A 30 day evaluation | >>version is | >>available at http://www.datanamic.com/download/index.html. | >> | >>Regards, | >> | >>Rick van Dijk | >> | >>** Datanamic ** | >>Tools for Database Developers | >>http://www.datanamic.com | > | > Please be informed your post is spam, and to promote your own product | > in replying is considered unethical. | > | | This one is somewhat tricky. It is a legitimate response to the OP's | question. However, we've seen a number of cases where the original | question is really nothing more than a setup to 'legitimize' the spam. | | The response could have also mentioned one or two alternatives. | | /Hans Good balance Hans. I've tried the product, and actually know through a friend of a friend one of the guys marketing it in the states -- only to say that Rick's legit, I won't comment on the product here, except to say that my experience was positive I could see posting a cross reference to c.d.o.marketplace (see my response in ...) just to keep 'altruistic' responses from any 'tainted' by marketing -- sound like a good approach? Doesn't seem much different than crossposting, sets up loophole like opt-out in email (spammers can comply with can-spam act while putting in nasty code in remove or contact link). Of course, legitimizing the "multiple alternatives" has it's own risks. The basic problem is that anyone who's job is marketing is going to, at minimum, feel they must try to get any edge possible for their product, and that's if they are ethical, which some obviously aren't. I still have mixed feelings about all this. I think that allowing a direct response such as Rick's ought to be ok, yet Daniel has convinced me otherwise.

It's definitely a fine line. My gut says - as long as the response is not
pushing a product, but offering a solution, it's OK. But, as you say, the
unscrupulous will use the loophole. (I prefer to think the majority will
not be unscrupulous and they will simply end up with egg on their face.)

One example of self-promotion that I really appreciate and want to see
continue (as it does provide real and very necessary solutions) is Pete F's
security comments.

I'm against the cross-post.

/Hans

[Daniel Morgan]

Rick van Dijk wrote: hello daniel and group, I'm sorry. I will not do it anymore here. I can imagine that some people may have problems with it in some groups. Therefor I'll make it good. On this site you'll find a complete list of database modeling tools: http://www.databaseanswers.com/modelling_tools.htm But, I don't think it it 'unethical' to promote your own product. It is very difficult not to reply when you can talk about your own product :).

I appreciate your willingness to compromise. Please appreciate that we
are a bit sensitive right now after having to deal with one of the most
egregious examples of spamming know to the usenet.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)