What will be the output of this Query?
select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual
- 6 Answers
- 17737 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
Does sql use python?
how is exception handling handled in mysql? : Sql dba
what is log shipping? : Sql dba
What is difference between sql function and stored procedure?
what are the advantages and disadvantages of views in a database? : Sql dba
discuss about myisam index statistics collection. : Sql dba
What are aggregate and scalar functions?
explain primary keys and auto increment fields in mysql : sql dba
What happens when a trigger is associated to a view?
What does the sign mean in sql?
What is a variable in sql?
Explain what is sql*plus?
Write a sql query to convert all character to uppercase after hypen.
Which join condition can be specified using on clause?
which types of join is used in sql widely? : Sql dba
