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

Can binary strings be converted into numeric or float data types?

965

What is the process of normalization?

1046

What are different types of schemas?

893

How to create sub reports?

226

What do you mean by a dependent functionality in a build?

1062

How to defragment indexes with alter index ... Reorganize?

1019

In how many ways you can invoke ssrs reports?

130

Explain what is “asynchronous” communication in sql server service broker?

865

Explain the benefits of user-defined functions?

985

What are sub reports?

186

Describe the functionalities that views support.

1049

What is Transparent Data Encryption?

938

What is log in sql server?

1075

What are differences in between sql server 2012 and sql server 2016?

973

How to return the top 5 rows from a select query in ms sql server?

1069