Answer / welcomeashwin

ORA-00909 invalid number of arguments

Cause: An Oracle function was referenced with an incorrect
number of arguments. All Oracle functions, except for
SYSDATE, require at least one argument.

Action: Correct the syntax of the function by entering the
required number of arguments.

Answer / 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'

Answer / 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

Answer / dinesh kumar

Invalid Character Error

Answer / sreeharibabu

select to_char(trunc(add_months(sysdate,-3),'mm'),'mm/dd/yyyy') from dual;--sysdate:22-APR-2016 output :01/01/2016
-- corrections in add_months , mm ,mm/dd/yyyy
--- flow--
select add_months(sysdate,-3) from dual;--sysdate:22-APR-2016 -- output : 1/22/2016 8:15:24 AM

select trunc(add_months(sysdate,-3),'mm') from dual;--sysdate:22-APR-2016 output : 01/01/2016

Answer / 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

what is ref cursor in pl/sql?

3 Answers  

What's the procedure?

0 Answers  

How do I upgrade sql?

0 Answers  

Authentication mechanisms in Sql Server ?

1 Answers   BirlaSoft,

what is the difernece between named and anonymous pl/sql blocks??

8 Answers   TCS, Wells Fargo,

What is function and procedure?

0 Answers  

Can you load data into multiple tables at once? : aql loader

0 Answers  

Why do we go for stored procedures?

0 Answers  

what is the difference between to_char and to_date functions?

10 Answers   Infosys,

Can instead of triggers be used to fire once for each statement on a view?

0 Answers  

Is sql similar to python?

0 Answers  

why should required for Indexed by table in pl/sql

3 Answers