In Oracle, SELECT to_char(sysdate,'month') from dual

How do we get month name in SQL Server 2000, Oracle, MS Access?

Question Posted / menaka

Answer Posted / menaka

In Oracle,

SELECT to_char(sysdate,'month') from dual

Is This Answer Correct ?

50 Yes

11 No

Please Help Members By Posting Answers For Below Questions

What are the characteristics of modern DBMS?

1047

What is the main difference between ‘between’ and ‘in’ condition operators?

1128

What is a benefit of using an after insert trigger over using a before insert trigger?

940

Difference between report and query parameter. Why do we need different type of parameter?

912

How do you create a clustered index?

1020

How to create a user name in a database?

1010

What is best institute to Learn DotNET And SQL in chennai?

2135

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

999

What is bulkcopy in sql?

917

List out the differences between the clustered index and non-clustered index in sql server?

953

Does index slows down insert statements?

953

What is bit data type? What's the information that can be stored inside a bit column?

888

What are the different types of collation sensitivity?

1069

What is the difference between mysql and mysqli?

1117

How to resolve the orphan use problem? : sql server security

970