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
Translate I don't sing into Spanish
Answers (2)
You are the administrator of an organization with a single Active Directory domain. One of your senior executives tries to log onto a machine and receives the error "This user account has expired. Ask your administrator to reactivate your account.
Answers (1)
How do I turn on your asus chromebook flip?
Answers (1)
Circle with radius 5 units and center P (-4, - 10)
Answers (1)
The goal of quality assurance is toprovide management with the data needed to determine whichsoftware engineers are producingthe most defects. i. True ii. False
Answers (1)
New Questions in Computers & Technology
Which describes an operating system this is multitasking
Answers (1)
With consideration to Ethernet, why is it necessary to have a common language for communication across devices.
Answers (1)
In Windows Vista, the Run command can be found in which application?
Answers (1)
Data for which there is temporarily no room in RAM is diverted to where on your computer? A. The paging file on the hard drive B. The system file on the hard drive C. The memory file on the hard drive D. The CPU cache
Answers (2)
The Presonus Studio Live 24 console has analog D-sub direct outputs. What cable would you need to connect this to a HD Analog interface?
Answers (2)
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?