Answer Posted / anand

Primary key is used to identify a row in a table and it
doesnot allow null values. It avoids duplication of rows.

whereas foreign key refers to a column or combination of
columns included in the defenition of referential integrity

How to update a table row with a record?

962

---

What is raw datatype?

1081

---

What is a directory object?

1029

---

Give the different types of rollback segments.

980

---

How do I manually uninstall oracle client?

1025

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4473

---

How to define a data field as not null?

1061

---

How to create lov dynamically at runtime & attach to text field?

1098

---

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1879

---

What is Redo Log Buffer in Oracle?

1127

---

How to convert characters to times in oracle?

955

---

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

1617

---

What is the difference between postgresql and oracle?

980

---

How to add a new column to an existing table with a default value?

967

---

How do I uninstall oracle client from windows?

962

---