The basic functions in Oracle (P1)

View: 640    Dowload: 0   Comment: 0   Post by: naruto   Category: Oracle   Fields: Other

0 point/2 review File has been tested

The basic functions in Oracle ( P1 ) Blog / MSSQL database - oracle - Today 2Cwebvn would like to introduce you to the basic functions of Oracle , said that the basic function but here is a combination of functions in Oracle . This article is quite long , so I divided into sections for your ease of navigation , and to relieve stress because you do not have too much to absorb in one way for once . Time to start part 1 of this series okay .
Today 2Cwebvn would like to introduce you to the basic functions of Oracle , said that the basic function but here is a combination of functions in Oracle . This article is quite long , so I divided into sections for your ease of navigation , and to relieve stress because you do not have too much to absorb in one way for once . Time to start part 1 of this series okay .
The function in my Oracle divided into 7 main function groups as groups of characters and string functions , functions of the group date , the function of calculation , .. vv.moi groups have specific characteristics of each group .
The division into groups like this help you easily visualize , think and easier to remember . But it is also a little inconvenient sometimes functions in different groups because these functions have properties that groups function . So does his jaw was presented earlier then I would not present it again , you do not remember then review the previous section okay .
7 groups divide their Oracle function is :

1 . Group functions and sequences of characters ( Character / String Functions )

Ascii   Convert   Lower   Soundex  
AsciiStr   Decompose     Lpad   Substr  
Chr   Dump   Ltrim   Translate  
Compose   Initcap   Replace   Trim  
Concat   Instr   Rpad   Upper  
Concat with ||   Length   Rtrim   VSize  
 

2. Group function of conversion (Conversion Functions)

Bin_To_Num   NumToDSInterval   To_Date   To_Number  
Cast   NumToYMInterval   To_DSInterval   To_Single_Byte  
CharToRowid   RawToHex   To_Lob   To_Timestamp  
From_Tz   To_Char   To_Multi_Byte   To_Timestamp_Tz  
HexToRaw   To_Clob   To_NClob   To_YMInterval  
 

3. Group Functions date (Date Functions)

Add_Months   Last_Day   Round   To_Date  
Current_Date   LocalTimestamp   SessionTimeZone   Trunc  
Current_Timestamp   Months_Between   Sysdate   Tz_Offset  
DbTimeZone   New_Time   SysTimestamp    
From_Tz   Next_Day   To_Char    
 

4. Group of mathematical functions (Mathematical Functions)

Abs   Covar_pop   Max   Sqrt  
Acos   Covar_samp   Median   StdDev  
Asin   Count   Min   Sum  
Atan   Cume_Dist   Mod   Tan  
Atan2   Dense_Rank   Power   Tanh  
Avg   Exp   Rank   Trunc (numbers)  
Bin_To_Num   Extract   Remainder   Trunc (dates)  
BitAnd   Floor   Round (numbers)   Var_pop  
Ceil   Greatest   Round (dates)   Var_samp  
Corr   Least   Sign   Variance  
Cos   Ln   Sin    
Cosh   Log   Sinh    
 

5. Advanced Function Group (Advanced Functions)

BFilename   Group_ID   NULLIF   User  
Cardinality   Lag   NVL   UserEnv  
Case Statement   Lead   NVL2    
Coalesce   LNNVL   Sys_Context    
Decode   NANVL   Uid    
 

6. Group function error (Error Functions)

SQLCODE  
SQLERRM  
 

7. Group of miscellaneous functions (Miscellaneous Functions)

Retrieve user ID from the current Oracle session  
Retrieve the session ID for the user logged in  
 
So we have 7 points over function in Oracle team already. The next post I will introduce you to a group function, you remember tuned.
Any questions or comments please send contributions to us in the form below to comment, wish you success!

The basic functions in Oracle (P1)

The basic functions in Oracle (P1) Posted on 24-03-2014  The basic functions in Oracle ( P1 ) Blog / MSSQL database - oracle - Today 2Cwebvn would like to introduce you to the basic functions of Oracle , said that the basic function but here is a combination of functions in Oracle . This article is quite long , so I divided into sections for your ease of navigation , and to relieve stress because you do not have too much to absorb in one way for once . Time to start part 1 of this series okay . 5/10 640

Comment:

To comment you must be logged in members.

Files with category

 
File suggestion for you
File top downloads
Codetitle.net - library source code to share, download the file to the community
Copyright © 2015. All rights reserved. codetitle.net Develope by Vinagon .Ltd