Ask Question
Computers and TechnologyComputers and Technology
11 February, 00:01

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?

+1
Answers (1)
  1. 11 February, 01:52
    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 and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers
You Might be Interested in
Joseph has just been hired on to a contractor company of the Department of Defense as their Senior Security Analyst.
Answers (1)
Which is the following not true about peer to peersoftware?
Answers (1)
True / False Generally, a multiply instruction takes more clock cycles than an add instruction.
Answers (1)
When should you talk to an adult you trust
Answers (1)
Which statements are true for conditional formatting? Conditional formatting enables you to a. Add more than one condition b. Apply 3D effects on charts c. Add rows and columns to data that satisfy certain conditions, and a.
Answers (1)
New Questions in Computers and Technology
What will entering the formula = SUM (C5:C18) in cell C19 result in?
Answers (1)
What is an appropriate action when an email thread becomes long? Do not forward it Start a new email thread Include the message chain when changes are made throughout the thread Use the reply all feature to explain all the steps that happened in the
Answers (1)
In the state of Florida your first conviction for DUI can result in your vehicle being impounded for: A. 20 days B. 10 Days C. 5 Days D. 15 Days
Answers (1)
Write the definition of a class employee base on the modular specification:. A data member for Id of type int (private). A data member for EmpName of type string (private). A data member for Salary of type double (private).
Answers (1)
What target audience does your product serve?
Answers (1)
Home » Computers and 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?