Interested to Buy Any Domain ? << Click Here >> for more details...
primary key is foreign key for the same table?
- 2 Answers
- 7159 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 |
What is the difference between $oracle_base and $oracle_home?
What are the built-in functions used for sending Parameters to forms ?
What is using clause and give example?
Can we protect our pl/sql source code?
How to pass a cursor variable to a procedure?
how to retrive xml data for using sql query?
Explain how you would restore a database using RMAN to Point in Time?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
when do u go for hash partitioning?
Define 'view' advantage ?
How to speed up webrick?
Explain oracle insert into command?
Oracle General 
