Answer Posted / rajeev

select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual--This query will return error...
we can use below query..
select to_char(trunc(add_months(sysdate-1,3),'mm'),'mm/dd/yyyy') from dual;
output:05/01/2018

Enlist the advantages of sql.

937

---

Why should I use postgresql?

967

---

how to create a new view in mysql? : Sql dba

890

---

What are variables in pl sql?

1090

---

Can we create foreign key without primary key?

930

---

What do we need to check in database testing?

963

---

What are the basic techniques of indexing?

1012

---

What is the difference between microsoft access and sql?

958

---

How do you update sql?

912

---

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

985

---

Write a query to find the names of users that begin with "um" in sql?

923

---

What are the sql commands?

1094

---

Can we debug stored procedure?

955

---

What is the example of procedure?

873

---

how many triggers are allowed in mysql table? : Sql dba

994

---