Diksha IT Training Centre

          Analytical  Functions in Oracle and it’s benefits   Hello Everyone, Today we will discuss about Analytical Functions in Oracle. Analytic functions in Oracle calculate an aggregate value based on a group of rows and return multiple rows for each group. In other word we can say Analytical functions are used to do analyze data over multiple rows and return the result in the current row. Also with   analytic functions, however, you can group the data that is used to calculate the function’s result, but show a value one each record in the result set, without grouping as well.   Advantage of Analytical Function is as below: Improve the Performance of Query Analtical Functions   are easier to write than sub queries and joins to get the same result. Easy to maintain. Before Starting of analytical function we need to understand below two points: OVER: The scope of an analytical function is defined in an OVER clause...

  Character Function SUBSTR and INSTR in Oracle   Hello Everyone , Today we will discuss about character Function SUBSTR and INSTR in Oracle SQL and its uses. In SQL Character Functions mainly operate on Character data , Character Function can be used with columns having character data.   SUBSTR :   SUBSTR functions allows you to extract a substring from a string. SUBSTR function returns a string value . If length is negative then SUBSTR function return a null value. Note:   If the position is positive, then Oracle Database counts from the beginning of char to find the first character. If the position is negative, then Oracle counts backward from the end of char Example of SUBSTR Function in Oracle SQL. To show uses of SUBSTR with different parameter I will take example from dual table and existing table in a database. To get the first 3 character we need to write below SQL query by using SUBSTR function to get the result. // GET FIRST 3 CHAR...