Answer / mukesh

Yes

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);

What are inner join and outer join?

3 Answers  

---

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

0 Answers  

---

Preparing for Oracle PL/SQL Interviews – Need Help with Common Questions

1 Answers  

---

What is a server parameter file in oracle?

0 Answers  

---

SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me

6 Answers   TCS,

---

Explain about integrity constraint?

0 Answers  

---

I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?

1 Answers  

---

what is difference between cartesian join & cross join even they give same result?

4 Answers   Bank Of America,

---

how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group

2 Answers   Verizon,

---

What's dateware house and what's clustor with practicle example

0 Answers  

---

which statement is running fastly ie insert or delete?

13 Answers   Oracle,

---

How to declare a local variable?

0 Answers  

---