Thursday 30 July 2015

The Powerful Oracle RDBMS

Every firm must need data source management system software for shop and control the important points to meet the requirements like a corporate and business must collect and gaze after their employee data. The majority of the companies today use a relational data base to speed up their information program, for virtually any program the main function of databases product is data collection, data space for storing then retrieves appropriate information. In a relational databases method the info's are locked in well defined structured buy, to ensure that we can easily certainly obtain the relevant details from the database. Relational database managing process functions two procedures for generate an effect for that user that are reasonable operation and bodily operations. First, in a very logical operation you specify their queries for instance your request is any employee name or add a staff details towards the database. Then inside physical operation RDBMS determines the kind of queries and carries out the operation, for instance after user query the database first readily index to discover the request and study your data to the memory and after that perform many steps before produce an output for the user.

Oracle is currently the leading RDBMS and it is the database of choice for the majority of the world's largest producers of data. For instance, I recently designed a process depending on SQL and PL/SQL (Procedural Language SQL -Oracle's proprietor extension on the SQL language meant to provide with Oracle products) which includes loaded over three billion records every day. The Oracle database exploits advanced technological features as part of its dedication to produce robust Business Intelligence solutions.

The migration process from your current non-relational database towards the new relational database should be discussed in detail to supply a thorough comprehension of your exact needs to the service provider as one of the first steps inside the entire process. Then, the new relational database needs to be designed as well as set around preserve your organization application logic.

The Oracle RDBMS is definitely not really a free database. Licensing costs for giant multi-processor clusters may be hundreds of thousands of dollars annually. For this and also other reasons, the companies that use it tend to have enterprise-class databases. They have a much a dedicated database administrator to make sure their data is secure and properly maintained. The total number of installs could possibly be lower than those of MySQL, but a significantly higher amount of those could have an avid administrator. Of the enterprise class databases, Oracle has the largest business where there are nearly always positions available for experienced DBAs and developers.

Thursday 23 April 2015

ORACLE SQL: STRING FUNCTIONS

SQL string functions are used for string manipulation. The following functions are commonly used string functions:

1. CONCAT(): Return concatenated string

select concat('Ashok','Kumar') from dual;                                                                                       
CONCAT('AS                                                  
----------                                                         AshokKumar                      


2. INSTR(): Return position of first occurrence of a substring within a string

select instr('ASHOKKUMAR','A') FROM DUAL;                                                                                       
INSTR('ASHOKKUMAR','A')                                       
-----------------------                                             
                      1

select instr('ASHOKKUMAR','A',3) from dual;                         
                                                                
INSTR('ASHOKKUMAR','A',3)                                           
-------------------------                                           
                        9

The above example will give the give the position of 'A' within string 'ASHOKKUMAR' starting from 3rd character.


3. LOWER(): Converts a string to lowercase

select lower('Ashok Kumar') from dual;                                                                                        
LOWER('ASHO                                                         
-----------                                                         
ashok kumar   


4. LENGTH(): Return the length of a string in bytes

select length('Ashok Kumar') from dual;                                                                                         
                                                                 
LENGTH('ASHOKKUMAR')                                                
--------------------                                                
                  11 


5. REPLACE(): Replace occurences of a substring within a string with another substring

select replace('AshokKumar','Kumar','KUMAR') from dual;             
                                                                                                                                     
REPLACE('A                                                          
----------                                                          
AshokKUMAR   


6. REVERSE(): Reverse all the characters in a string

select reverse('Ashok Kumar') from dual;                                                                                        
REVERSE('AS                                                         
-----------                                                         
ramuK kohsA


7. LPAD(): Return the string, left-padded with the specified string 

select lpad('Ashok Kumar',15,'*') from dual;                                                                                    
LPAD('ASHOKKUMA                                                     
---------------                                                     
****Ashok Kumar  

In the above example the total length of the returned string will be 15


8. LTRIM(): Removes leading spaces from a string

select ltrim('    Ashok Kumar') from dual;                                                                                      
LTRIM('ASHO                                                         
-----------                                                         
Ashok Kumar  


9. SUBSTR(): Return the specified substring within a string
select substr('Ashok Kumar',4,2) from dual;                                                                                     
SU                                                                  
--                                                                  
ok    

In the above example 4 is the starting position from a string and 2 is the total number of characters to be selected


10. RPAD(): Return the string, right-padded with the specified string 

select rpad('Ashok Kumar',15,'*') from dual;                                                                                    
RPAD('ASHOKKUMA                                                     
---------------                                                     
Ashok Kumar****    


11. RTRIM(): Removes trailing spaces from a string
select rtrim('Ashok Kumar        ') from dual;                                                                                  
RTRIM('ASHO                                                         
-----------                                                         
Ashok Kumar 


12. TRIM(): Removes leading and trailing spaces from a string 

select trim('      Ashok Kumar      ') from dual;                   
                                                                 
TRIM('ASHOK                                                         
-----------                                                         
Ashok Kumar    


13. UPPER(): Converts a string to uppercase
select upper('Ashok Kumar') from dual;                                                                                                   
UPPER('ASHO                                                         
-----------                                                         
ASHOK KUMAR      


I hope the above examples in support of each string function will help you understand better.