Interested to Buy Any Domain ? << Click Here >> for more details...
What will be the output of this Query?
select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual
- 6 Answers
- 19790 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 33 Yes | 3 No |
Post New Answer View All Answers
what is an extent ? : Sql dba
Why primary key is required?
How to call shell script from pl sql procedure?
Does truncate require commit?
what are the difference between clustered and a non-clustered index? : Sql dba
what is sub-query? : Transact sql
How many scalar data types are supported in pl/sql?
What is self-join and what is the requirement of self-join?
What is a native sql query?
Can we update views in sql?
What are the disadvantages of file system?
What is your daily office routine?
How to get help at the sql prompt?
What is pivot query?
What are expressions?
