Answer Posted / 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);

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1673

---

Are truncate and delete commands same? If so why?

1128

---

Where do we use decode and case statements?

982

---

How to loop through a cursor variable?

1063

---

How to create tables for odbc connection testing?

1082

---

Does oracle charge for java?

1040

---

How to assign values to variables?

1077

---

What happens to indexes if you drop a table?

1155

---

Differentiate between pre-select and pre-query?

1080

---

Explain what are the type of synonyms?

1089

---

What is a proxy class?

1016

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2942

---

How to insert a new row into a table in oracle?

1136

---

What is the quickest way to export a table to a flat file?

949

---

What is SQL access advisor in Oracle?

1175

---