Answer Posted / ajmal khan

There are many way to count the duplicate row in a table
select count(column_name)-count(distinct(column_name)) from
table_name;

Are subqueries faster than joins?

999

---

What is the difference between stored procedure and view?

1009

---

What is oracle sql called?

905

---

Which is better stored procedure or query?

951

---

What does := mean in pl sql?

1031

---

what is the command used to fetch first 5 characters of the string? : Sql dba

1627

---

What is trigger price?

963

---

What is sql key?

973

---

What is the importance of sqlcode and sqlerrm?

1334

---

What do you understand by pl/sql cursors?

1074

---

What is coalesce sql?

979

---

Can we change the table name in sql?

928

---

What is embedded sql with example?

1021

---

What are the two types of exceptions.

1147

---

What are all the ddl commands?

1171

---