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.
Want to see more full solutions like this?
Chapter 8 Solutions
A Guide to SQL
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrProgramming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning