What will be the output of this Query?
select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual
- 6 Answers
- 18778 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 sql and its types?
Write an sql query to select all records from the table?
How to use boolean type in select statement?
Is oracel sql developer written in java?
What are the commands used in sql?
Mention what is the plv (pl/vision) package offers?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
How do I find duplicates in two columns?
How is sql used in oracle?
Is join an inner join?
what is rdbms? : Sql dba
What is program debugging?
Why do we use sqlite?
What does pl sql developer do?
How do you respond to dementia behavior?
