Category Archives: Database

Why MongoDB does not start in Fedora ? [SOLVED]

Hello guys, Today I want to share with you how to easily make MongoDB work in Fedora. Recently, while moving to F19 I have faced the issue when my Mongo does not start. What I mean by does not start … Continue reading

Posted in Fedora, MongoDB, OS | Tagged , , , , , | 2 Comments

Oracle SQL: Formatting Strings, DECODE, UPPER(), LOWER()

Case: Write a query that displays the employee’s Full Name and Job Title in the following format: DAVIES, CURTIES is Store Clerk for all employees whose last name ends with S and first name starts with C or K. Give … Continue reading

Posted in Database, ORACLE, SQL | Tagged , , , , , , , , | Leave a comment

Oracle SQL: Date with words, Sort by Day of the Week

Case question: Display each employee’s last name, hire date, and salary review date, which is the first Tuesday after a year of service, but only for those hired after 1997. Label the column REVIEW DAY. Format the dates to appear … Continue reading

Posted in Database, ORACLE, SQL | Tagged , , , | 2 Comments

Oracle SQL : Using NVL(), LENGTH(), UPPER()

Here is the case: Create a query that displays the city names, country codes and state province names, but only for those cities that start on S and have at least 8 characters in their name. If city does not … Continue reading

Posted in Database, ORACLE, SQL | Tagged , , , , , , , | Leave a comment

Oracle SQL: Finding Difference Between two dates in YEARS

My friend asked me how to create following SQL query: For each employee hired before 1992, display the employee’s last name, hire date and calculate the number of YEARS between TODAY and the date the employee was hired. Label the … Continue reading

Posted in Database, ORACLE, SQL | Tagged , , , , , , | 7 Comments