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
- 3313 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 do daily transactions with out sql* loader control file regesterd in apps?
How to define default values for formal parameters?
Explain the use of rows option in imp command.
What exactly do quotation marks around the table name do?
3. Display all the client numbers in the ORDER table. Remove duplicates.
What is Hash Index?
How to start a specific oracle instance?
Can we insert data in view oracle?
What is Trigger in Oracle?
How to convert characters to dates in oracle?
What is an UTL_FILE.What are different procedures and functions associated with it?
How is it different from a normal table?
Oracle General 
