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

Define outer join in sql server joins?

934

What's new in sql management studio for sql server? : sql server management studio

1065

Explain the flow of creating a cube? : sql server analysis services, ssas

1050

How to get the number of affected rows?

1006

How to change the system date and time from SQL Plus Terminal ?

1221

Explain a checkpoint?

1033

Can a table have 2 primary keys?

983

What are functions in the sql server?

1219

What is repeatable read?

1017

What is database dimension? : sql server analysis services, ssas

1078

Can the “if update (colname)” statement be used in a delete trigger?

990

Define right outer join?

980

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

2162

Explain different types of collation sensitivity?

982

What are the restrictions applicable while creating views? : SQL Server Architecture

1023