Answer Posted / tripti gour

yes, we can
ex.

create table t1
(empno number(4) not null,
ename varchar2(30),
constraint u_k_t1 unique key (empno));

How to create a stored procedure in oracle?

1151

---

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

1746

---

Please explain compound trigger in oracle?

1110

---

What is a initialization parameter file in oracle?

1082

---

Explain the use of grant option in exp command.

1109

---

State any two functions of oracle?

1097

---

How many types of auditing in Oracle?

1086

---

What happens to the current transaction if the session is killed?

1036

---

Explain enable novalidate constraint.

1132

---

What is oracle thin client?

1076

---

How data locks are respected in oracle?

1110

---

What is a parameter file in oracle?

1188

---

What is a Garbage Collection? and what is full recursive Garbage collection?

2956

---

What are nested tables?

1226

---

How to export your own schema?

1051

---