oracle sql functions

Single-record functions in SQL 1. 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 322. CHRReturns the corresponding characters;SQL> select chr (54740)

to 0)1 Sample:2 Select round(123.456,0) fromDual Return123 3 Select round(123.456,1) fromDual Return123.5 4 Select round(-123.456,2) fromDual Return-123.46 3.ceil and Floor functionsThe ceil and floor functions are sometimes useful when it comes to business data. Ceil (n) takes the smallest integer greater than or equal to the value N, and Floor (N) takes the largest integer less than or equal to the value N; turn from: http://www.2cto.com/database/2

the right of the decimal point. The default value of N2 is 0, if N2 is a negative number, it is rounded to the corresponding digit on the left of the decimal point (although the N2 value mentioned in Oracle documents must be an integer, in fact, the judgment here is not rigorous, even if N2 is not an integer, it will also automatically perform processing after the N2 is rounded up. However, we need to pay special attention to other points that must b

', -3) from DUAL; 2, Length (c) Returns the length of the specified string. If For example: SELECT LENGTH (' A123 ') from DUAL; Guess what the return value of select LENGTH (') from DUAL; (iv). Date function (DateTime functions) In this type of function, the date is returned except for the value returned by the Months_between. 1, Add_months () returns the value after the specified date month +n, n can be any integer. For example: SELECT add_months

Common Oracle functions-character and mathematical functions, oracle mathematical functions Various functions are often used in the development and use of oracle. This chapter summarize

Common Oracle functions-date functions, oracle date functions In the development and use of oracle, a variety of date functions are often used. The online date

Oracle InStr functions For the InStr function, we often use this: to find the position of a specified substring from a string. For example: Sql> Select InStr (' Oracle ', ' or ') position from dual; POSITION ---------- 1 Starts at the first position of the string ' Oracle ',

Introduction to Oracle System Variable Functions and oracle Variable Functions Oracle functions are diverse, and system variable functions are one of them. The following describes the t

sys. dbms_random.value (0, 1) value from dual;13. Get the symbolS: select sign (-8) value-1O: select sign (-8) value from dual-1---------- Mathematical functions14. Circumference RateS: select pi () value 3.1415926535897931O: Unknown15. sin, cos, and tan parameters are in radians.For example, select sin (PI ()/2) value to get 1 (SQLServer)16. Asin, Acos, Atan, Atan2 return radians17. radian angle Interchange (, Oracle unknown)DEGREES: Radian-> AngleR

Oracle _ Common grouping functions and oracle grouping FunctionsZookeeper Oracle _ Common grouping Functions① Grouping Function1. max (column): calculates the maximum value, which is not required for the data type. Any data type can be used.2. min (column): calculates the mi

Seven common Oracle functions and seven oracle Functions 1. decode Function Select id, NAME, DECODE (LEVER, 1, 'Professor ', 2, 'associate Professor', 3, 'mentor ', 'lecturer') POSITION, (select classnum from class t where t. NUM = S. NUM) num from teacher s where t. lever in (1, 2, 3 ); The usage logic of the decode

Tags: no character format nbsp sysdate start Ceil Special examplesAbout several Oracle functions that handle the number of decimal places ()1. Rounding of several decimalsSelect Round (1.2345, 3) from dual;Results: 1.2352. Reserved two decimal places, onlySelect Trunc (1.2345, 2) from dual;Results: 1.23 Select Trunc (1.2399, 2) from dual; Results: 1.233. Take an integerReturns the largest integer greater th

single-record functions in SQL 1.ASCII Returns the decimal number corresponding to the specified character; Sql> Select ASCII (' a ') a,ascii (' A ') a,ascii (' 0 ') zero,ascii (') space from dual; A A ZERO space --------- --------- --------- --------- 65 97 48 32 2.CHR Give an integer and return the corresponding character;

Oracle analysis functions (notes), oracle Functions Analytics functions are new types of functions introduced by oracle Database in 9i and are continuously enhanced in later versions. T

, returns twice times the wage (2*sal), if it is 30, returns 3 times times the wage, if not, then returns half the wageSelect Ename,deptno,sal,Case DeptnoWhen Ten then 1*salWhen 2*salWhen 3*salelse SAL/2Endfrom EMP;②decode:decode (EXPR1,EXPR2,EXPR3,.........)Eg: Judge Deptno, if it is department 10th, returns one-fold pay (1*sal), or 0 if not.Sql>select Ename,deptno,sal,decode (deptno,10,sal,0) from EMP;Eg: to judge Deptno, if it is Department 10th, return one-fold salary (1*sal), return 30 time

SQL advanced (1) -- regular functions, SQL -- Functions When we compare and process strings, the like clause may be used at most. % Represents one or more characters, and _ represents one character. However, when processing complex strings, we find that this is far from what we need. So this low-end, not beautiful stat

Differences between Oracle procedures and functions: oracle process functions Oracle process and function are expected to be more familiar. The following describes the differences between Oracle process and function. We hope that

oracle| Function | conversion | String Oracle Common numerical functions, conversion functions, string functions introduced. numeric function: Absolute value of ABS (m) m MoD (M,n) m is the remainder after the n is removed Power (M,n) m's n-th-side Round (M[,n]) m rounded to

Oracle computing time functions (numtodsinterval, numtoyminterval), oracle computing functions Numtodsinterval (, X is a number, and c is a string, Indicates the unit of x. This function converts x to interval day to second. Commonly Used units include ('day', 'hour', 'minute ', 'second ') example

The ORACLE tutorial is: OraclePL/SQL single-row functions and group functions. A 1 function is a program with zero or multiple parameters and a return value. Oracle has a series of built-in functions in