What will be the output of this Query?
select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual
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
How does cross join work in sql?
What does the file extension accdb stand for?
How do I run a query in pl sql developer?
Write a sql query to convert all character to uppercase after hypen.
Explain character-manipulation functions?
what are properties of a transaction? : Sql dba
What is a nested table in word?
What is a delimiter in sas?
How can you view the errors encountered in a trigger?
What is the difference between row level and statement level trigger?
Does a join table need a primary key?
How to get each name only once from an employee table?
Is join and inner join the same?
What language is oracle sql developer?
What is the sql*loader? : aql loader