Question

explain any 2 character built-in
function ​

Answer 1

Answer:

home | O'Reilly's CD bookshelfs | FreeBSD | Linux | Cisco | Cisco Exam   Chapter 11   11. Character Functions Contents: Character Function Descriptions Character Function Examples A character function is a function that takes one or more character values as parameters and returns either a character value or a number value. The Oracle Server and PL/SQL provide a number of different character datatypes, including CHAR, VARCHAR, VARCHAR2, LONG, RAW, and LONG RAW. In PL/SQL, the three different datatype families for character data are: VARCHAR2 A variable-length character datatype whose data is converted by the RDBMS CHAR The fixed-length datatype RAW A variable-length datatype whose data is not converted by the RDBMS, but instead is left in "raw" form When a character function returns a character value, that value is always of type VARCHAR2 (variable length), with the following two exceptions: UPPER and LOWER. These functions convert to upper- and lowercase, respectively, and return CHAR values (fixed length) if the strings they are called on to convert are fixed-length CHAR arguments.