Oracle Database Discussions

SQL> conn ogan/password@opttest
Connected.
SQL> create table ogan_deneme
2 (
3 deneme_1 varchar2(10),pk
4 deneme_2 varchar2(10),
5 deneme_3 number
6 );

Table created.


SQL> alter table ogan_deneme add primary key (deneme_1);

Table altered.

SQL> create table ogan_deneme_2
2 (
3 deneme_1 varchar2(10),--fk
4 deneme_2 varchar2(10)--pk
5 );

Table created.

SQL> alter table ogan_deneme_2 add primary key (deneme_2);

Table altered.

SQL> alter table ogan_deneme add foreign key (deneme_1) references ogan_deneme_2 (deneme_2);

Table altered.

SQL>

in above mentioned query we used deneme_1(ogan_deneme) for two times one is creating for PK and secondly for creating FK references ogan_deneme_2 (deneme_2);
is this statement is true?

Thanks in advance