db2 substring function

Want to know db2 substring function? we have a huge selection of db2 substring function information on alibabacloud.com

The realization method of reverse function in DB2 _db2

Oracle,sql server, and DB2 should also have its reverse function, because there is a certain application scenario. CREATE OR REPLACE FUNCTION REVERSE ( p1 varchar) RETURNS varchar (m) Specific "REVERSE" LANGUAGE SQL Deterministic NO EXTERNAL ACTION reads SQL DATA BEGIN declare v_str varchar (m) default '; DECLARE V_index INTEGER; --Define subs

DB2 to create a SQL function to get the first letter of Chinese pinyin

There are times when we need to index a set of data using letters from A to Z. If the data format is all half-width English is easy to achieve, but if the index of a group of Chinese data will cause a little trouble, data input database may not have specified an index letter, This requires the application to automatically generate information for indexing. In general, the index of Chinese data uses the first letter of the Chinese pinyin of the phrase, for example: Phrase Index letter --- ----

Total Pages: 5 1 2 3 4 5 Go to: Go

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.