Character function <br /> Name Description CONCAT (string 1, string 2) string 1 and string 2 is connected into a new string; example: select CONCAT (job, ename) from emp LPAD (field, the total size of the fill character) that is filled from lef ...
oracle date to judge, to judge the legality of the date of return tag value is 0 if the table name the date of legal and illegal if the date format will be returned to negative Enter the date format YYYY-MM-DD or YYYYMMDD type varchar2
oracle date function date validation check is correct, enter the date format for the CHAR type, YYYYMMDD or YYYY-MM-DD
rnrnrnrn Send mail to create an instance of <br /> common Package: create or replace package xx_mail_api is procedure sendmail (p_err_buf out varchar2 , P_ret_code out number , P_sendor in varchar2 , P_recipients in varchar2 , P_subject in varchar2
At present, the regular expression has been widely in many software applications, including * nix (Linux, Unix, etc.), HP and other operating system, PHP, C #, Java and other development environment. Oracle 10g SQL Regular Expression increased flexib ...
oracle function Daquan SQL in a single record of a function 1.ASCII Returns the character corresponding to the specified decimal number; SQL> select ascii ( 'A') A, ascii ( 'a') a, ascii ('0 ') zero, ascii (' ') spa ...
Oracle, if you have to use SQL to pairs of IP addresses to sort words: select ip, to_number (substr (ip, 1, instr (ip, '.', 1, 1) -1)) newip1, to_number (substr (ip, instr (ip ,'.', 1,1) +1, instr (ip, '.', 1, 2)-instr (ip ,&# ...
SQL in a single record of a function 1.ASCII Returns the character corresponding to the specified decimal number; SQL> select ascii ( 'A') A, ascii ( 'a') a, ascii ('0 ') zero, ascii (' ') space from dual; AA ZERO S ...
On the basis of regular expressions that can refer to "layman's language of regular expressions", Oracle10g achieved with the regular expression is basically the same, the details can refer to "10g in regular expressions." Ora ...
Sender: leejw (body of revolution, a capital letter ^_^), Area: Database Title: sql statement is optimized write some small tips Station: BBS SMTH (Thu Dec 20 15:58:23 2001) Some of SQL optimization tips. 1) I do not know whether they would like to u ...
Regular expressions in Oracle With 10g, regular expressions are finally available in SQL. That is, they were already supported through the owa_pattern package. The new operators and functions are regexp_like, regexp_instr, regexp_substr and regexp_re ...
oracle function (second talk) One-line string functions One-line string functions for manipulating string data, most of them have one or more parameters, most of them to return the string ascii () c1 is a string, return c1 the first letter of the asc ...
CREATE OR REPLACE function str2tbl (P_str in varchar2) return itemvalueType as l_str long default p_str | | ','; l_n number; l_data itemvalueType: = itemvalueType (); begin loop l_n: = instr (l_str,','); exit when (nvl (l_n, 0) = 0); ...
