Learning Oracle Integration Cloud Services SOA | BPM

In Oracle RTRIM  function removes all the rightmost characters matching string from  Characters. The syntax for the  RTRIM function is: RTRIM (character,Removing String) For Example: SELECT RTRIM (' FOREST ',' EST ') FROM DUAL; Result : FOR

In Oracle LTRIM  function removes all the characters matching string from the left side of Characters. The syntax for the  LTRIM function is: LTRIM (character,Removing String) For Example: SELECT LTRIM (' FOREST ',' FOR ') FROM DUAL; Result : EST

In Oracle, RPAD function pads the right-side of a string with a specific set of characters.The syntax for the RPAD function is: RPAD( string1, padded_length, [ pad_string ] ). For Example SELECT RPAD (' SHAHEER ',12,*****) FROM DUAL; RESULT: SHAHEER*****

In Oracle, LPAD function pads the left side of a string with a specific set of characters. The syntax for the LPAD function is: LPAD ( string1, padded_length, [ pad_string ] ). For example SELECT LPAD (' SHAHEER ',12,'*****') FROM DUAL; RESULT: *****SHAHEER

In Oracle,  UPPER function converts all letters in the specified string to uppercase. The syntax for the  UPPER function is:  UPPER (string). For Example SELECT UPPER (' shaheer ') FROM DUAL; RESULT : SHAHEER

In Oracle, LOWER function converts all letters in the specified string to lowercase. The syntax for the LOWER function is : LOWER (string). For Example SELECT LOWER (' SHAHEER ') FROM DUAL; RESULT : shaheer

In Oracle, LENGTH function returns the length of the specified string.The syntax for the LENGTH function is: LENGTH ( string ) For Example SELECT LENGTH (' SHAHEER ') FROM DUAL RESULT: 7

In Oracle INITCAP function sets the first character in each word to uppercase and the rest to lowercase. The syntax for the INITCAP function is: INITCAP (string). For Example SELECT INITCAP (' SHAHEER' ) FROM DUAL; Result: Shaheer

In oracle the CONCAT function allows you to concatenate two strings together. The syntax for the CONCAT function is: CONCAT (CHAR1，CHAR2) For Example SELECT CONCAT (' SHAHEER ',' BADAR ') "RESULT" FROM DUAL;

In Oracle CHR returns the character having the binary equivalent to n as a VARCHAR2 value in either the database character set or, if you specify USING NCHAR_CS , the national character set. This function takes as an argument a NUMBER value, or any value that can be implicitly converted to NUMBER , and returns a character. The syntax for the CHR function is:   CHR(N) For Example: SELECT CHR(83) FROM DUAL; RESULT: S SELECT CHAR(115) FROM DUAL; RESULT: s

In Oracle PL/SQL, the ASCII function returns the NUMBER code that represents the specified character. The syntax for the ASCII function is: ASCII( single_character ) Example SELECT ASCII ( 'SHAHEER' ) FROM DUAL;     ASCII(CHAR)

Subversion is an open source version control system. Founded in 2000 by CollabNet, Inc. Subversion universally recognized and adopted as an open-source, centralized version control system characterized by its reliability as a safe haven for valuable data. The simplicity of its model and usage and its ability to support the needs of a wide variety of users and projects, from individuals to large-scale enterprise operations. Git is an open source distributed version control system for effective, high-speed processing from very small to very large project version management. Darcs is a free, open source source code management system. Darcs is easy to learn and efficient to use because it asks you questions in response to simple commands, giving you choices in your work flow. You can choose to record one change in a file, while ignoring another. As you update from upstream, you can review each patch name, even the full "diff" for interesting patches. Bazaar is a d...