oracle trunc string

This article is reproduced from: http://www.blogjava.net/gf7/archive/2012/07/01/381933.html function trunc is an Oracle-built function that can be "tailored" to date type data to accommodate different types of data requirements. In the previous

The decode () function is one of the powerful functions of Oracle Pl/sql, and it is currently available only in Oracle company SQL, and not in the SQL implementations of other database vendors. (But it's not a standard SQL function, but that's his

Today in the review project code to see such a problem, there is a number table, each time you need to randomly take 6 free numbers from such a table, that is, each time the 6 numbers are taken out should be different. And then I saw this SQL.Select

Today, I met Oracle's TRIM, TRUNC, and DECODE functions. I will record my experiences for future reference. Today, I met Oracle's TRIM, TRUNC, and DECODE functions. I will record my experiences for future reference. Today, I met Oracle's TRIM,

I.use of the Oracle Trunc () functionTRUNC (for dates)Precision to day Select Trunc (sysdate, ' DD ') from dual result is: 2010-9-17Accurate to Month select Trunc (sysdate, ' mm ') from dual result: 2010-9-1Accurate to Year select Trunc (sysdate, '

Original link http://blog.csdn.net/oscar999/article/details/16839417Preface Trunc is a shorthand for truncate. The Chinese translation is "truncate" or "truncated". On the surface, it should be a string or a number to intercept. There are actually

Nvl (string1, replace_with) Function: If string1 is null, The nvl function returns the value of replace_with; otherwise, the value of string1 is returned. This nvl serves the same purpose as isnull (string1, replace_with) in sqlserver. Note:

This article will introduce some of the functions that are often used in everyday life, or that are very interesting, though they are rarely used. It is divided into two kinds of introductions, namely: Famous letters-functions that are often

Practical Functions DECODE Syntax: DECODE (value, if1, then1, if2, then2, if3, then3,... else) Value represents any column of any type in a table or any result obtained through computation. When each value is tested, if the value is if1, the result

I. oracle basic SQL statements and functions, and oraclesql Functions I. Data Definition Language (ddl) Data definition language (ddl) is used to change the database structure, including creating, changing, and deleting database objects. The Data