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;

Explain the uses of a database trigger?

1043

---

how to enter binary numbers in sql statements? : Sql dba

974

---

Can we insert data into materialized view?

945

---

How do I write a cron which will run a sql query and mail the results to agroup?

981

---

How do I run pl sql in sql developer?

1120

---

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1438

---

What is the need of merge statement?

1038

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1582

---

Is t sql a programming language?

1069

---

How do I run sql profiler?

1072

---

What do you mean by query optimization?

1002

---

What is a primary key sql?

1045

---

When is the explicit cursor used ?

1035

---

What is serial sql?

977

---

Why do we use view in sql?

964

---