Interested to Buy Any Domain ? << Click Here >> for more details...
emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
- 1 Answers
- 3361 Views
- I also Faced
- E-Mail Answers
Answer / vilas
Foregin key: It is the relation between two tables.it can be
used to create the relation between two tables,when two
tables have the unique rows (means emp_numb)then we can
used to foreign key.
eg:
create table student
{ name varchar(10),
rollno int(10));
.......this is student table........
create table student_Details
{ name varchar(10),
rollno int(10)refercence
);
.
| Is This Answer Correct ? | 3 Yes | 0 No |
How to join two tables in a single query using oracle?
Explain self joins in oracle?
How to create a table in a specific tablespace?
What are the built-in functions used for sending Parameters to forms ?
Give the Types of modules in a form?
Is there any function in oracle similar like group_concat of mysql?
List the types of joins used in writing subqueries?
What do you understand by database schema and what does it hold?
What is different bet native dynamic sql and Dbms_Sql?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
what is the difference between first normal form & second normal form?
what is primary key?
Oracle General 
