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
- 19844 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
How do you add a column to a table?
How to add new employee details in an employee_details table with the following details
When is a declare statement required?
what is the difference between a having clause and a where clause? : Sql dba
What is the difference between distinct and unique in sql?
define sql delete statement ? : Sql dba
What if we write return in procedure?
How can you fetch first 5 characters of the string?
how to drop an existing index in mysql? : Sql dba
How do you declare a user-defined exception?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
Do we need to rebuild index after truncate?
what are the differences between char and nchar? : Sql dba
How exception is different from error?
Can a foreign key have a different name?
