Answer Posted / abc

select count(*) from tab;

How can I introduce multiple conditions in like operator?

724

---

candidate key is subset of super key but not vice-verse explain

1766

---

What is the difference between count (*), count (expression), count (distinct expression)?

763

---

Why does oracle 9i treat an empty string as null?

730

---

How can I get column names from a table in oracle?

748

---

What is execute immediate in oracle?

717

---

What is transaction control statement and how many types of transaction control statement in Oracle?

801

---

Is truncate autocommit in oracle?

832

---

How to use fetch statement in a loop?

761

---

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2717

---

How to create an oracle database manually?

788

---

How to commit the current transaction in oracle?

774

---

What is redo log?

787

---

What happens to indexes if you drop a table?

903

---

How to drop an existing view in oracle?

732

---