Built-in Functions - Exercise

Problems

01. River Info

Problem Description

Database

Database

02. Concatenate Geography Data

03. Capital Code

04. (Descr)iption

05. Substring River Length

06. Replace A

07. Translate

08. LEADING

09. TRAILING

10. LTRIM & RTRIM

11. Character Length and Bits

12. Length of a Number

13. Positive and Negative LEFT

14. Positive and Negative RIGHT

15. Update iso_code

16. REVERSE country_code

17. Elevation --->> Peak Name

18. Arithmetical Operators

19. ROUND vs TRUNC

20. Absolute Value

22. EXTRACT Booked At

24. Match or Not

25. COUNT by Initial

26. SUM

27. Average Value