Answer Posted / praveen

Let sysdate=30/07/2012;

let see dis query
select add_months(sysdate,-3) from dual;
//ans=07/30/2012-mm/dd/yyyy
select trunc(add_months(sysdate,-3),'mm') from dual;
//ans=07/01/2012-mm/dd/yyyy
select to_char(trunc(add_months(sysdate,-3),'mm'),'mm/dd/yyyy from dual;
//ans=07/01/2012-mm/dd/yyyy

What is nosql db?

960

---

Explain what is sql?

1109

---

How do you delete a table?

1065

---

What is an index in sql with example?

965

---

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2216

---

What is the difference between cluster and non-cluster index?

1104

---

What is difference between inner join and self join?

1079

---

how to calculate expressions with sql statements? : Sql dba

1032

---

Which is better cte or subquery?

1026

---

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1182

---

What is rownum?

972

---

what are string data types? : Sql dba

1039

---

What is sql data?

984

---

What is the syntax and use of the coalesce function?

1160

---

How does sql profiler work?

1011

---