Respuesta :

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.

Otras preguntas