Answer Posted / sowmya makkena

select floor(months_between(sysdate,'22-mar-1995')) "age in months" from dual;

Can we use delete in merge statement?

1039

---

what is a primary key? : Sql dba

1034

---

What is online transaction processing (oltp)?

1017

---

Why does sql need a server?

1044

---

what is the difference between primary key and unique key? : Sql dba

1039

---

what are all different types of collation sensitivity? : Sql dba

982

---

What is data profiling in sql?

1081

---

How do I find duplicates in sql?

930

---

What is normalization in a database?

1160

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1159

---

What is consistency?

1126

---

What is dense_rank in sql?

987

---

Explain ddl statements in pl/sql?

1010

---

What is duration in sql profiler trace?

1082

---

What is sql prepared statement?

987

---