Chapter 8, Problem 1RQ

Explanation of Solution

Display letters in uppercase in Oracle, Access, and SQL Server:

Display letters in uppercase using Oracle:

• User can display the letters in uppercase using “UPPER” function.
• Syntax for “UPPER” function:

  UPPER(text)

• From the above syntax, “text” specifies any text or any column name from specific table.

Example:

The example for “UPPER” function is given below:

SELECT * FROM STUDENT_ID, UPPER(STUDENT_NAME) FROM STUDENT;

The above query is used to display student ID and student name with uppercase letters from “STUDENT” table.

• Using “UPPER” function, user can change the every student name to uppercase letters.

Display letters in uppercase using Access:

• User can display the letters in uppercase using “UCASE” function.
• Syntax for “UCASE” function:

  UCASE(text)

• From the above syntax, “text” specifies any text or any column name from specific table.

Example:

The example for “UCASE” function is given below:

SELECT * FROM STUDENT_ID, UCASE(STUDENT_NAME) FROM STUDENT;

The above query is used to display student ID and student name with uppercase letters from “STUDENT” table.

• Using “UCASE” function, user can change the every student name to uppercase letters.

Display letters in uppercase using SQL Server:

The SQL Server also uses “UPPER” function to display letters in uppercase. For SQL Server, same procedure as Oracle.

Explanation of Solution

Display letters in lowercase using Oracle:

• User can display the letters in lowercase using “LOWER” function.
• Syntax for “LOWER” function:

  LOWER(text)

• From the above syntax, “text” specifies any text or any column name from specific table.

Example:

The example for “LOWER” function is given below:

SELECT * FROM STUDENT_ID, LOWER(STUDENT_NAME) FROM STUDENT;

The above query is used to display student ID and student name with uppercase letters from “STUDENT” table.

• Using “LOWER” function, user can change the every student name to lowercase letters.

Display letters in lowercase using Access:

• User can display the letters in uppercase using “LCASE” function.
• Syntax for “LCASE” function:

  LCASE(text)

• From the above syntax, “text” specifies any text or any column name from specific table.

Example:

The example for “LCASE” function is given below:

SELECT * FROM STUDENT_ID, LCASE(STUDENT_NAME) FROM STUDENT;

The above query is used to display student ID and student name with lowercase letters from “STUDENT” table.

• Using “LCASE” function, user can change the every student name to uppercase letters.

Display letters in lowercase using SQL Server:

The SQL Server also uses “LOWER” function to display letters in lowercase. For SQL Server, same procedure as Oracle.