Hot File

The basic functions in Oracle (P1)

View: 466    Dowload: 0   Comment: 0   Post by: naruto  
Author: none   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 .

Introduction

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 466

Comment:

To comment you must be logged in members.

Files with category

  • The basic functions in Oracle ( P3 )

    View: 535    Download: 0   Comment: 0   Author: none  

    The basic functions in Oracle ( P3 )

    Category: Oracle
    Fields: Other

    0/2 review
    The basic functions in Oracle ( P3 ) Blog / MSSQL database - oracle - This article is a sequel of the song " The basic functions in Oracle ( P2 ) " . In this section alone will solve all the functions and character strings in group 1 . Are you ready...

  • The basic functions in Oracle (P2)

    View: 588    Download: 0   Comment: 0   Author: none  

    The basic functions in Oracle (P2)

    Category: Oracle
    Fields: Other

    0/4 review
    The basic functions in Oracle ( P2 ) Blog / MSSQL database - oracle - Today 2Cwebvn please write to the jaw in a series on Oracle , the first post we have a vision of all the basic functions in Oracle , today I will go all details about the group is...

  • The basic functions in Oracle (P1)

    View: 467    Download: 0   Comment: 0   Author: none  

    The basic functions in Oracle (P1)

    Category: Oracle
    Fields: Other

    0/2 review
    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...

  • Oracle 10g Grid Control Installation On Red Hat Enterprise Linux 3 (RHEL3)

    View: 469    Download: 0   Comment: 0   Author: none  

    Oracle 10g Grid Control Installation On Red Hat Enterprise Linux 3 (RHEL3)

    Category: Oracle
    Fields: Education - Schools

    0/2 review
    In this article I'll describe the installation of Oracle 10g Grid Control on Red Hat Enterprise Linux 3 (RHEL3). The article is based on a server installation with a minimum of 2G swap and the following package groups installed.

  • Oracle Database 10g Release 2 (10.2.0.1) Installation On Fedora Core 4 (FC4)

    View: 466    Download: 0   Comment: 0   Author: none  

    Oracle Database 10g Release 2 (10.2.0.1) Installation On Fedora Core 4 (FC4)

    Category: Oracle
    Fields: Education - Schools

    0/2 review
    In this article I'll describe the installation of Oracle Database 10g Release 2 (10.2.0.1) on Fedora Core 4. The article is based on a Fedora Core 4 Server Installation with a minimum of 2G swap, secure Linux disabled and the following package groups...

  • MERGE Statement Enhancements in Oracle Database 10g

    View: 439    Download: 0   Comment: 0   Author: none  

    MERGE Statement Enhancements in Oracle Database 10g

    Category: Oracle
    Fields: Education - Schools

    0/2 review
    Oracle 10g includes a number of amendments to the MERGE statement making it more flexible.

  • Installation Enhancements in Oracle Database 10g

    View: 515    Download: 0   Comment: 0   Author: none  

    Installation Enhancements in Oracle Database 10g

    Category: Oracle
    Fields: Education - Schools

    0/2 review
    Installation of the Oracle 10g database software has been enhanced in several ways. This articles provides a brief summary of the improvements

  • File Upload and Download Procedures in Oracle Database 10g

    View: 676    Download: 0   Comment: 0   Author: none  

    File Upload and Download Procedures in Oracle Database 10g

    Category: Oracle
    Fields: Education - Schools

    0/3 review
    This article is an update of a previous Oracle9i article, which includes some modified configuration steps necessary in Oracle 10g. For this procedure to work the HTTP Server software, available on the Companion CD, must be installed into a separate...

 
Newsletter Email

File suggestion for you

File top downloads

logo codetitle
Codetitle.com - library source code to share, download the file to the community
Copyright © 2015. All rights reserved. codetitle.com Develope by Vinagon .Ltd