What are the types of Strings in PL/SQL?

1.	What are the types of Strings in PL/SQL?
Answer» To pad a string with zeros, you can use RPAD or LPAD function in PL/SQL. Let us see how to pad the right SIDE of a string with zeros: RPAD(tom, 6) The output would have a WIDTH of 6 characters now. SINCE the string is of 3 characters, therefore REST of the space would be filled with 0S: tom000

Answer»

To pad a string with zeros, you can use RPAD or LPAD function in PL/SQL. Let us see how to pad the right SIDE of a string with zeros:

RPAD(tom, 6)

The output would have a WIDTH of 6 characters now. SINCE the string is of 3 characters, therefore REST of the space would be filled with 0S:

tom000

Discussion