Interested to Buy Any Domain ? << Click Here >> for more details...
what is primary key and foreign key when and where have to use
- 5 Answers
- 7313 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prashant
primary key has a unique & it is only one in a
databasewhile fkey is not unique. it is based on primary key
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ramprasad.s
HI
Primary key = (Not Null + Unique).
Foreign key = (For Referential table access).
Bye
sun_ramprasad@yahoo.com
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / chandrika
primary key has unique value, it dostnt contain null values
and duplicate values.
foregin key is primary key of another table
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / raveendran
Primary key is unique across entire table.In primary key
not null constraint is activated.Only one primary key in
one table.
foreign key points to primary key of another table
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / csprusty
To establish a relationship between 2 tables.
pk=(unique+not null)
fk=unique
| Is This Answer Correct ? | 1 Yes | 2 No |
Without giving condition how to retrieve the unmatched records from table.
What is oracle latest version?
12 RULES OF RDBMS
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Q1:code to connect to sql server(database) through jdbc application. Q2:code to connect to Mysql(database) through jdbc application. Q3:code to connect to oracle(database) through jdbc application.
i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.
which sql command we can use to get a print out from oracle?
When does a Transaction end ?
What is the usage of save points in oracle database?
which language is used to develop the oracle........?
What is enter substitution variable in oracle?
What does `(+)` do in a where clause?
Oracle General 
