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

Answer Posted / marco birchler

In Oracle make the first letter capital if you wish the
output names also capitalised. "Month" instead of "month"

Is This Answer Correct ?    13 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can a function call a stored procedure in sql server?

525


what is normalization? Explain different levels of normalization? : Sql server database administration

645


Why should one not prefix user stored procedures with ‘sp_’?

587


Why union all is faster than union?

504


Define model database?

568






How to connect of datebase with sql express.?

618


Explain transaction server explicit transaction?

501


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5495


What is the difference between rank and dense_rank?

501


Write a code to select distinct records without using the DISTINCT keyword.

644


You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

540


Explain what is analysis service repository?

530


Write down the syntax and an example for create, rename and delete index?

526


How to remove duplicate rows from table?

590


How to populate a table in sql server?

494