What will be the output of this Query?
select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

Answer Posted / dinesh kumar

Invalid Character Error

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does sql developer connect to oracle database?

521


What is the use of pl/sql table?

556


How to use distinct and count in sql query? Explain

607


Is primary key an index?

535


how to drop an existing index in mysql? : Sql dba

539






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

958


Can a table contain multiple primary key’s?

630


Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

547


what are the differences between binary and varbinary? : Sql dba

530


What is trigger in sql? Explain

537


How many types of normalization are there?

488


How long it takes to learn pl sql?

532


Why join is faster than subquery?

599


What is a boolean in sql?

521


What is index example?

557