Results for "database"


  • Freshers should get trained in different domains !

    Freshers should get trained in different domains !

    By admin
    Mr Venkat Subramanian, Senior IT professional, working with Ramco Systems, says that it is necessary for a fresher to be trained in different domain areas, so that it would not only fetch him a job but also elevate his career opportunities in...
    • 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

        How to use Oracle EXISTS ?

            Oracle EXISTS Oracle EXISTS is used to tests for existence of rows in a subquery. The Exists condition is TRUE if subquery returns at least one row. For instance you want to print the product details as prodid,name,description by displaying the products which has related pr...

        Tags: oracle exists, oracle, firstplanet, database, experts speak

        • admin

          Managing SQL in Java Application

          There are many ways to manage SQL statement such as hard-coding in Data Access objects (DAO), storing in separate files (properties/xml), using metadata driven i.e., Object-Relational Mapping (ORM) example hibernate etc, embedded with SQLJ and writing in stored procedure. Each method has its own ...

          Tags: free training, sql, java application, database, experts speak

          • admin

            General rules of SQL Statement to improve performance

            SQL queries under workspace can suffer performance issues. Performance can affect due to huge SQL statements. Simpler SQL statements require less processing and generally perform better than complex statements. If you understand the purpose of statement then it is easy to write new statement that...

            Tags: firstplanet, sql statements, database, backend, experts speak

            • admin

              How to use hints to tune the SQL ?

              Oracle provides an increasing number of methods for changing the execution plans for your SQL. Among the most common tools for tuning SQL statements are hints. A hint is a code snippet that is embedded into a SQL statement to suggest to Oracle how the statement should be executed to improve the e...

              Tags: firstplanet, sql, coding, database, oracle, experts speak

              • admin

                Experts speak

                Using parallel operation enables multiple process work together simultaneously to resolve a single SQL statement that avoid performance time. Parallel execution is a commonly used method of speeding up operations by splitting a task in smaller sub task. For example, Imagine that your task is coun...

                Tags: swl tuning, database, oracle, dbms, experts speak

                • admin

                  All about SQL Tuning

                  SQL tuning is the process of ensuring that the SQL statements that an application will issue will run in the fastest possible time. All Developers must be known SQL tuning to produce excellent performance. Previously, i have delivered 11 blogs that explains about SQL tuning in various ways. Now, ...

                  Tags: jobs, job seekers, sql tuning, oracle, database, experts speak

                  • admin

                    Cumulative value in Oracle SQL

                    The calculation of cumulative column for one or more columns by partition with one or more columns can be achieved as follows Consider we have following records in sale table Customer            Product     ...

                    Tags: cumulative value, oracle, sql, database, experts speak

                    • admin

                      Calculating column using next record column(s):

                      The calculation of column using next record columns can be achieved in oracle SQL. This will be useful for writing advanced   business intelligence queries. The following example queries explain how to calculate a column using next record. Consider we have following records in prodsale ta...

                      Tags: oracle sql, calculate yearly growth rate, database, backend, experts speak