ä»ä»¬çåºå«æ¯ï¼
substringæææ¯åé¾ã
substræçæ¯å符å½æ°ã
ä¾å¥æ¯è¾ï¼
substring
1ãThis is the substring after the character? in the URL.
å³URLä¸å符ï¼ä¹åçåå符串ã
2ãA substring is zero or more contiguous string length units of input string.
åå符串æ¯è¾å
¥å符串çé¶ä¸ªæå¤ä¸ªç¸é»å符串é¿åº¦åå
ãã
3ãIn Figure 5, the substring of length 1 from the first byte of the string has been specified.
å¨å¾5ä¸ï¼å·²ç»æå®å符串第ä¸ä¸ªåèçé¿åº¦ä¸º1çåå符串ã
substr
1ãThis explains the use of substr ( text, match [0], match [ 1]) in the last line of code.
è¿è§£éäºæåä¸è¡ä»£ç ä¸å符å½æ°ï¼textï¼match[0]ï¼match[1]ï¼ç使ç¨ã
2ãLength of a string variable: Input argument for the SUBSTR function, whichdetermines the desired length of the resulting string or output of the LENGTHfunction.
å符串åéçé¿åº¦ï¼å符å½æ°çè¾å
¥åæ°ï¼å³å®äºç»æå符串çææé¿åº¦æLENGTHå½æ°çè¾åºã
3ãUser define function REGEXP_SUBSTR.
ç¨æ·å®ä¹çå½æ°REGEXP SUBSTRã
温馨提示:答案为网友推荐,仅供参考