OraFAQ Forum: SQL & PL/SQL » inner join & equi-join , primary key generation

Home » SQL & PL/SQL » SQL & PL/SQL » inner join & equi-join , primary key generation

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

inner join & equi-join , primary key generation [message #8200]

Sun, 03 August 2003 08:15

shashi
Messages: 34
Registered: March 2001

Member

Looking for answers for the questions -

1)Difference between a inner join and equi-join

2)How is primary key generated . Is it only through sequences or any other way

Report message to a moderator

Re: inner join & equi-join , primary key generation [message #8204 is a reply to message #8200]

Sun, 03 August 2003 12:46

Nazma Bepat
Messages: 34
Registered: May 2003

Member

An inner join, also called equijoin, is the equality (=) linking of common
columns in two tables. Only returns rows where joined values exist and are
shared in both tables.

The best way to generate the primary key is from sequence.

create sequence table_name_seq;

Hope this helps.

Thanks

Nazma

Report message to a moderator

Previous Topic:	Call exe from Oracle
Next Topic:	Ordering column values which have numeric & alphanumeric values

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 16:31:23 CDT 2024