• September 30, 2005 30 Sep'05

    The group with the greatest COUNT

    I would like to retrieve the record that has the maximum number of counts (records) in the table. I have written a query using the MAX(COUNT(*)) but it doesn't work in SQL Server.  Continue Reading

  • September 26, 2005 26 Sep'05

    DISTINCT is not a function

    My question is related to count(*) and distinct. How can I list results where count(*) is greater than 2?  Continue Reading

  • September 26, 2005 26 Sep'05

    Cause of ORA-06550 error

    I'm getting an ORA-06550 error with submessage PLS-00103, which is objecting to the word 'INSERT.' I initially thought this would be a code issue but when I backed the database up and imported it to a standard Oracle-built database the problem went ...  Continue Reading

  • September 26, 2005 26 Sep'05

    RMAN vs. dbverify utility

    You have mentioned the use of the dbverify utility to check for errors in a datafile. Can we not also use RMAN to detect corrupt blocks and also to spot bad spots on disks? If we can use RMAN to cover both the above cases, what is the advantage/...  Continue Reading

  • September 26, 2005 26 Sep'05

    How to estimate database efficiency?

    We do not have any formulas for calculating the exact efficiency of the database and a whole lot depends on what the end users experience. I want to know what are the topics based on which we can at least make a rough estimation of the database ...  Continue Reading

  • September 26, 2005 26 Sep'05

    Migrating data using export/import utility

    I have a 8.0.5 database, and I would like to migrate the data into 9.2. I want to use the export/import utility to migrate the data. Do I need to create the tablespaces before importing the data into 9.2?  Continue Reading

  • September 26, 2005 26 Sep'05

    Can a foreign key relate to a primary key on either of two tables?

    I have a check table that contains both medical and dental checks. I also have a dental table and a medical table. My question is if there is a way to have a foreign key on the check table, on claim no, that relates back to a primary key, on claim...  Continue Reading