What will be the output of this Query?
select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual
- 6 Answers
- 17746 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 are field types?
how do you know the version of your mysql server? : Sql dba
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is faster join or subquery?
How to run sql functions in pl/sql?
What is prepared statement in sql?
What is primary and foreign key?
what are the different index configurations a table can have? : Sql dba
What is on delete set null?
When is a declare statement required?
How do rank () and dense_rank () differ?
Explain dml and ddl?
How many unique keys can a table have?
What is difference between procedure and trigger?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
