Ask Question
Computers & TechnologyComputers & Technology
11 October, 05:46

1. How do you display letters in uppercase in Oracle, Access, and SQL Server? How do you display letters in lowercase in Oracle, Access, and SQL Server?

+3
Answers (1)
  1. 11 October, 06:10
    0
    Display letters in uppercase, in lowercase in Oracle, Access, and SQL Server

    Explanation:

    Oracle & SQL Server has an 'UPPER' function to display letters in uppercase.

    Syntax for 'UPPER' function is UPPER (text)

    Access has the 'UCASE' function to display letters in uppercase.

    Syntax for ' UCASE' function is UCASE (text)

    Oracle & SQL Server has a 'LOWER' function to display letters in lowercase.

    Syntax for 'LOWER' function is LOWER (text)

    Access has an 'LCASE' function to display letters in lowercase.

    Syntax for ' LCASE' function is LCASE (text)

    The 'text' specifies any character set or any column name from the specific table.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “1. How do you display letters in uppercase in Oracle, Access, and SQL Server? How do you display letters in lowercase in Oracle, Access, ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers
You Might be Interested in
Which of the following explains the growing need for a standard IT professional licensing program? Check all of the boxes that apply. Currently, a court of law recognizes IT certifications.
Answers (1)
Select the clothing items that would be appropriate in an office. A suit jacket and tie. A t shirt that says, "I heart music." A knee-length skirt. A pair of flip flops. A high heel. A tank top and short skirt. A sweatshirt.
Answers (1)
Teleconferencing is slower and more expensive than setting up a face-to-face meeting. T or F
Answers (1)
The good example of pivoting is changing thedimensions along the axis.? True? False
Answers (1)
Horizontal refrences in a spreadsheet identified by a number
Answers (1)
New Questions in Computers & Technology
An enumeration inherits methods from which of the following classes? a. java. lang. Object b. java. lang. Enum c. both a and b d. neither a nor b
Answers (1)
What do rocket scientists mean when they say, "forces come in pairs?"
Answers (1)
Which animal would you expect a dog's genes and proteins to be the most like? A. Wolf B. Bear C. Alligator D. Lion
Answers (1)
Which items you would most likely to keep in your database
Answers (1)
What is it called when you give credit in your writing to someone else's quote?
Answers (1)
Home » Computers & Technology » 1. How do you display letters in uppercase in Oracle, Access, and SQL Server? How do you display letters in lowercase in Oracle, Access, and SQL Server?
Sign Up Forgot Password?