Log in

Results for "mismatch"

Tags

    • admin

      SQL mistakes - Divisor is equal to zero

          To perform division operation the divisor should not be zero otherwise the query execution will be aborted by throwing error message as “Divisor is equal to zero”. For instance, there is an order having ‘orderqty’ = 100 (A) and ‘order taxamt&rs...

      Tags: oracle, sql mistakes, mismatch, firstplanet, divisor, experts speak

      • admin

        SQL mistakes – Column ambiguously defined

            This is very common mistakes occur when you query columns more than one table. This will happen when a column name in a join is referenced ambiguously, it exists in multiple tables. So if a column exists in multiple tables it is necessary to have the table reference. For in...

        Tags: oracle, sql mistakes, mismatch, firstplanet, experts speak

        • admin

          SQL mistakes – Subquery NULL value, returns empty rows

              This mistake will occur while fetching data based on values not listed in a list of values.  For instance if you want to retrieve all the invoices which are not yet paid and the payment table will have invoice reference once paid. SELECT invocieid,customerid,total FR...

          Tags: oracle, sql mistakes, mismatch, firstplanet, experts speak

          • admin

            SQL mistakes – Column length mismatch

            This type of error commonly occurs while inserting the rows from source tables for reporting purpose.  For instance the aging report can be displayed from “T_Aging” table, which calculated and inserted from 3 tables order, invoice and payment. INSERT INTO t_aging (col1,col2,...

            Tags: oracle, sql mistakes, mismatch, firstplanet, experts speak