prefixed tables

[UDIT]

hi there ,
what are Prefixed and Non Prefixed Tables ,
and how can one put a primary key in a table using the CHECK constraint , although Oracle advises not to use the method but for personal information i wanted to know.

Thanks ,
Udit.

 

[karluk]

My guess is that "prefixed table" is simply a table referred to by the creator.table_name syntax rather than the table name alone. Anyone else know of some deeper concept that I'm missing?

I know that the creator.table_name syntax has some advantages, even though it's more cumbersome to use. If the table name alone is specified, sql like "select * from emp" can parse differently depending on who is executing it. The point is that "emp" may refer to karluk.emp when I'm executing but to udit.emp when you are executing. Always supplying the creator eliminates this ambiguity.

I don't know what is meant by putting "a primary key in a table using the CHECK constraint". Maybe someone else could shed some light.

 

[wushutwist]

To get around typing schema_name.table_name everytime, you can declare a public synonym. As far as the CHECK constraint thing, I am not too sure I understand what you mean. Are you talking about declaring a CHECK constraint on the PK of the table?
Wushutwist