Interested to Buy Any Domain ? << Click Here >> for more details...
primary key is foreign key for the same table?
- 2 Answers
- 7061 Views
- Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / javed a. khan
Yes this is possible and it will allow.
CREATE TABLE learn_01(book_id NUMBER,
book_name VARCHAR2(100),
book_genre VARCHAR2(100),
isbn_number NUMBER ,
author VARCHAR2(100),
ref_book_id NUMBER)
alter table learn_01 add constraint book_pk primary key (book_id)
alter table learn_01 add constraint foreign key book_rf (ref_book_id) references learn_01
ALTER TABLE learn_01 add CONSTRAINT book_fk1 FOREIGN KEY (book_id) REFERENCES learn_01(book_id);
| Is This Answer Correct ? | 5 Yes | 0 No |
How to define a record variable to store a table row?
How to download oracle database 10g xe?
Is it possible to disable the parameter from while running the report ?
How can I combine multiple rows into a comma-delimited list in oracle?
what is the bitmap index?
What is the difference between Delete, Truncate and Drop in Oracle?
How to create an initialization parameter file?
How do I spool in oracle?
Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.
Is the After report trigger fired if the report execution fails ?
What are the different types of trigger and explain its various uses and functions?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
Oracle General 
