Shulou(Shulou.com)05/31 Report--

Editor to share with you how to use lpad and rpad in oracle, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Grammar

LPAD (string,padded_length, [pad_string]): fill from left, L:left left, PAD:pad fill

RPAD (string,padded_length, [pad_string]): fill from right, R:right right, PAD:pad fill

explain

String: original data, that is, the data to be populated

Padded_length: length after fill

Pad_string: optional to fill the string. If not, paste the space.

For example:

Select lpad ('34th century, 6th century 0') as format from dual

Implementation result 000034

It can usually be used with a date sequence as a primary key

For example

Select to_char (sysdate,'YYYYMMDDHh34miss') | | lpad ('34Phone6) as format from dual

Implementation result 20170614110557000034

You can replace'34 'with a sequence.

For example

Select to_char (sysdate,'YYYYMMDDHh34miss') | | lpad (testSequences.nextval,6,'0') as format from dual above is all the contents of the article "how to use lpad and rpad in oracle". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.