Answer Posted / sarika

select * from tablename;

How to use fetch statement in a loop?

991

---

What is the difference between pre-select and pre-query?

1147

---

How to create a table in a specific tablespace?

929

---

How to define a variable to match a table column data type?

945

---

Explain alias?

1096

---

What is the relationship among database, tablespace and data file?

942

---

How does oracle handle read consistency?

1064

---

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

981

---

How to open and close an explicit cursor in oracle?

1016

---

What is a package in oracle?

1051

---

How to write a query with a right outer join in oracle?

1130

---

Explain a private synonyms?

998

---

How to load data from external tables to regular tables?

1011

---

When do you get a .pll extension in oracle?

1094

---

How to change system global area (sga) in oracle?

976

---