First select three of the following syntax: Second using MS Word or another text

Question

First select three of the following syntax:

Second using MS Word or another text editor, create a brief description of each and demonstrate how they would be used in Oracle. In your demonstration, create a model SQL statement for the syntax you have selected.

Example:      SELECT lastname, address, LTRIM(address, ‘P.O BOX’)

                        FROM customers

                        WHERE state = ‘FL’;   

LOWER UPPER INITCAP SUBSTR INSTR LENGTH LPAD and RPAD RTRIM and LRTIM REPLACE TRANSLATE CONCAT ROUND TRUNC MOD ABS POWER MONTHS BETWEEN ADD MONTHS NEXT DAY LAST DAY TO DATE NVL NVL2 NULLIF TO CHAR DECODE TO NUMBER

Explanation / Answer

1. Concat--- concat function is used to concatenate two character strings . It can be nested also.

2. Upper--- upper function is used to change the case of all characters of character strings to uppercase

3. Lower ---- lower function is used to change the case of all characters of character strings to lowercase.

Example

Select concat(concat(upper(firstname),' '),lower(lastname)) from employees where firstname is not null;

In this query

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.