Answer Posted / nitin

Let SYSDATE = '20-Sep-2012'

Use below query,

select to_char(trunc(add_months(sysdate,-
3),'mm'),'mm/dd/yyyy') from dual;

It will give you ...
o/p :

'06/01/2012'

What is function and procedure?

1037

---

What is anonymous block in sql?

1125

---

what is a database? : Sql dba

1176

---

What are the two types of exceptions.

1174

---

Write the alter statement to enable all the triggers on the t.students table.

1128

---

Explain the the update statement in sql?

1044

---

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

1007

---

What is procedure function?

1068

---

What is the maximum number of triggers, you can apply on a single table?

1001

---

Does sql use python?

1039

---

Does group by remove duplicates?

1048

---

What is a data manipulation language?

1028

---

explain what is mysql? : Sql dba

1088

---

How many sql statements are used? Define them.

1045

---

What is not in sql?

952

---