Answer Posted / vali

according to samir kumar sahoo we cant find ans i think
bcoz
if u enter rownum='x' u can not find the data
select * from emp where rownum=10
ans; no rows found

Explain index?

1307

---

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

---

what is the difference between restoring and recovering?

1054

---

What is the usage of merge statement?

1203

---

What is a named program unit?

1137

---

Can a parameter be passed to a cursor?

1180

---

What is a sub query and what are the different types of subqueries?

1173

---

How to use subqueries with the in operator using oracle?

1137

---

How to use an explicit cursor without open statements?

1102

---

How can Oracle users be audited?

1171

---

How do I find the database name in oracle?

1089

---

How many types of segments in Oracle?

1114

---

What is a trigger oracle?

1137

---

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1092

---

Can you drop an index associated with a unique or primary key constraint?

1069

---