Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

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


Please Help Members By Posting Answers For Below Questions

How does cross join work in sql?

956


What does the file extension accdb stand for?

916


How do I run a query in pl sql developer?

925


Write a sql query to convert all character to uppercase after hypen.

1376


Explain character-manipulation functions?

1067


what are properties of a transaction? : Sql dba

1017


What is a nested table in word?

909


What is a delimiter in sas?

978


How can you view the errors encountered in a trigger?

915


What is the difference between row level and statement level trigger?

958


Does a join table need a primary key?

902


How to get each name only once from an employee table?

1062


Is join and inner join the same?

941


What language is oracle sql developer?

938


What is the sql*loader? : aql loader

1003