oracle function

Syntax:Replace (char, search_string, replacement_string)  Usage: SetCharString inSearch_stringConvert all to stringsReplacement_stringAnd no matching strings will be changed.  Example: SQL> select Replace ('fgsgswsgs ', 'fk', 'J') from

Single-record functions in SQL1. ASCIIReturns the decimal number corresponding to the specified character;SQL> select ascii ('A') A, ascii ('A') A, ascii ('0') zero, ascii ('') space from dual; A ZERO SPACE------------------------------------65 97 48

PL/SQL single-row functions and group functions A function is a program with zero or multiple parameters and a return value. Oracle has a series of built-in functions in SQL, which can be called SQL or PL/SQL statements. functions are mainly divided

1. decode function usage The DECODE function is one of the powerful functions of oracle pl/SQL. Currently, only oracle SQL provides this function, and other database vendors do not yet implement this function. What is the purpose of DECODE? First,

Function indexing concepts:Function-based index is a new product since 8i. It has the ability to index and calculate columns. It is easy to use and provides computed values, the query performance is improved logically without modifying the

Oracle8i function index experiment ======================================== ================================== Author: oracle http://oracle.itpub.net) Posted: Category: General Category Source: http://oracle.itpub.net/post/20957/146498 --------------

Create or replace function getthetime (oldtime in INT) Return varchar2 Is Thehour int; Themin int; Thesec int; Strtime varchar2 (2000 ); Begin If oldtime Strtime: = to_char (oldtime) | ''' second '''; Else Themin: = oldtime/60; Thesec: =

PL/SQL single-row functions and group functions A function has zero or multiple parameters and has a return value.Program. Oracle has a series of built-in functions in SQL, which can be called SQL or PL/SQL statements. functions are mainly

PL/SQL single-row functions and group functions A function is a program with zero or multiple parameters and a return value. Oracle has a series of built-in functions in SQL, which can be called SQL or PL/SQL statements. functions are mainly divided

A colleague asked me to help write a function and get a time period by inputting the number of minutes or seconds. Although it is very simple, I still paste it out when a backup is needed and use it directly: Create or replace function get_time (I

36. add_monthsAdd or subtract a monthSQL> select to_char (add_months (to_date ('000000', 'yyymmm'), 2), 'yyymmm') from dual; To_cha------200002SQL> select to_char (add_months (to_date ('000000', 'yyymmm'),-2), 'yyymmm') from dual; To_cha------199

PL/SQL single-row functions and group functions A function is a program with zero or multiple parameters and a return value. Oracle has a series of built-in functions in SQL, which can be called SQL or PL/SQL statements. functions are mainly divided

It has never been a good time to sort out database knowledge. Unfortunately, I suddenly don't know where to start ...... I think the difference between Oracle and SQL Server is their architecture. I am still not sure about this. I just have a little

InStr () returns the position of the string to be intercepted in the source string Grammar:InStr (Sourcestring,deststring,startposition,appearposition) Parameter description: Sourcestring: The source string to find in this string. Deststring: The

A friend is doing map-related programs, the requirements of the program is: There are a lot of points on the map, stored in the database, input is a polygon, output is contained in this polygon point. A friend discovers that there is a function in

oracle| string --intercept the most likely mixed string in Chinese and English according to the given byte length to avoid a half character problem Create or Replace function SUBSTR_GB (str_ varchar2, Begin_ Integer, Length_ integer) return varchar2

Oracle Package UTL_INADDRRole: Used to obtain host names and IP addresses in the LAN or Internet environment.1. IP address in utl_inaddr.get_host_address environmentPrompt for system error if query failsQuery www.qq.com IP AddressSelect

http://blog.csdn.net/huangwuyi/article/details/7407820First, the function1, take the whole mod (2,10) =22, take the whole trunc (12/10) =13, take the whole ceil (12/10) =24, NULL (NULL) specifies a value NVL (null,9) =95 cumulative sum (piece) =88347

If a function or expression uses one or more columns of a table, you can create an index for the table based on these functions or expressions, such an index is called a Function-BasedIndex ). Function indexes can calculate functions or expressions

Functions in Oracle (1)-The Decode ecode () function is one of the powerful functions of oracle pl/SQL. Currently, only oracle SQL provides this function, this function is not available for SQL implementations of other database vendors. The DECODE