Log in

Results for "oracle"

Tags

    • admin

      Oracle Subquery factoring or WITH clause

      This clause used to assign a name to subquery that can be treated as temporary table and read multiple times in your main SQL query. This clause does not begin with “SELECT” and the main SELECT query has to be followed by this clause, you need to consider the subquery name as a tempor...

      Tags: oracle, oracle subquery, experts speak

      • admin

        Oracle Decode Function

        This function has the functionality of if-then-else statement. For example consider you want to print the order report as orderno, customer and status columns and for the status column you need to print Draft/InProgress/Complete but in order table this field is number that is 1/2/3 respectively. ...

        Tags: oracle decode function, oracle, firstplanet, free training, experts speak

        • admin

          Oracle Subquery factoring or WITH clause

          This clause used to assign a name to subquery that can be treated as temporary table and read multiple times in your main SQL query. This clause does not begin with “SELECT” and the main SELECT query has to be followed by this clause, you need to consider the subquery name as a tempor...

          Tags: oracle subquery factoring, oracle, with clause, firstplanet, experts speak

          • admin

            Oracle correlated subquery

            A subquery is a SELECT statement which is used in another SELECT statement. When you reference a column from the table in the parent query in the subquery is known as “Correlated subquery”. For instance you want to print the order report as orderno, customer_id and Total columns by fi...

            Tags: oracle, correlated subquery, firstplanet, database, experts speak

            • admin

              Oracle Having Clause

              Oracle HAVING clause is used in combination with the Oracle GROUP BY clause to limit the returned rows after the grouping. SQL statements can utilize both a WHERE clause and an Oracle HAVING clause.  For instance you want to print the customer sales summary report as customer_id ,totalsales ...

              Tags: oracle having clause, oracle, firstplanet, experts speak

              • admin

                Oracle MODEL clause

                The Oracle MODEL clause is a powerful new extension to the SELECT statement. The business reports fields require calculations which are difficult to build in SQL, such as financial analysis, market share, forecast, time analysis calculations with many logically interdependent formulas are special...

                Tags: oracle model clause, model clause, oracle, firstplanet, experts speak

                • admin

                  Oracle PIVOT clause

                  Oracle PIVOT clause is used for statistical analysis that takes data in separate rows, aggregates it and converts it into columns. For instance you want to print the customer sales report by order type as customer,standardTypeSales,posTypeSales columns and for the standardTypeSales & posTypeS...

                  Tags: oracle pivot clause, oracle, pivot clause, firstplanet, experts speak

                  • admin

                    Oracle UNPIVOT clause

                    Oracle UNPIVOT clause is used to rotates data from columns into rows. For instance you want to print the customer sales report from the pivot report table  pivot_order contains 3 columns customer, standardTypeSales, posTypeSales to customer, total and ordertype that is by rotating the column...

                    Tags: oracle, unpivot clause, oracle unpivot clause, firstplanet, experts speak

                    • admin

                      Oracle ROLLUP clause

                      Oracle ROLLUP clause is an extension of Oracle GROUP BY clause to group and aggregate at different levels in a collection of similar rows. This will return a row containing a subtotal for each group along with a total for all groups. For instance you want to print the customer order type wise sal...

                      Tags: oracle rollup clause, oracle, rollup operation, firstplanet, experts speak

                      • admin

                        Oracle "AND" and "OR" Conditions combination

                        Oracle "AND" and "OR" Conditions can be combined in single statement to retrieve the desired results. For instance you want to print the customer order details as orderno,customer,city, by filtering the orders using city column with various combinations. This can be achieved i...

                        Tags: oracle, conditions, combination, sql and conditions, experts speak