• November 28, 2005 28 Nov'05

    Difference between a primary key and a surrogate key

    What is the difference between a primary key and a surrogate key?  Continue Reading

  • November 28, 2005 28 Nov'05

    Receiving error at export command

    I have a problem trying to export a database and I cannot figure out what it might be. When writing this line of command (exp user/pass@orcl file=c:scott.dmb full=y), I receive an error message.  Continue Reading

  • November 28, 2005 28 Nov'05

    ORA-0658 error at run time

    All the objects in the database are valid, but at run time I am getting error "ORA-0658 PL/SQL: could not find program unit being called." I selected select * from all_objects where status='INVALID' and got no rows.  Continue Reading

  • November 28, 2005 28 Nov'05

    Counting rows in a LEFT OUTER JOIN

    I have a question regarding outer joins. I want to show a list of all retailers in our database and a count of their orders. I came up with a query that shows all retailers that have at least one order and the count, but it won't show retailers ...  Continue Reading

  • November 28, 2005 28 Nov'05

    Ways to handle an error on an INSERT statement

    I am receiving an error on my INSERT statement in a PL/SQL procedure. I had a table in that name during compilation of the procedure and I purposefully renamed it. Due to the table being missing this error is coming. I want to drop or handle this ...  Continue Reading

  • November 28, 2005 28 Nov'05

    Way to recover a database without backup?

    We have just lost a tablespace on our live database (looks like someone ran the command "drop tablespace $$$ including contents"). The tablespace (GSIF) is gone! But we can see the datafile. Is there a way of recovering the tablespace with its ...  Continue Reading

  • November 28, 2005 28 Nov'05

    Looking for an article recommending Oracle Designer

    I work for a large local government organization. I have been instructed to investigate Oracle Designer with a view to persuading IT management to purchase this case tool, in order that we may properly map all our existing applications so that our ...  Continue Reading

  • November 28, 2005 28 Nov'05

    Select only non-null columns

    Is there a way to pull only non-null fields from a query?  Continue Reading

  • November 28, 2005 28 Nov'05

    Difference between regular and REF cursors

    I have a question regarding your answer to the following question, posed on 23 December 2002: "Can you throw some light on REF cursors? Are they the same as the usual cursors that we define in PL/SQL? If not, how do they differ and when can we use ...  Continue Reading

  • November 28, 2005 28 Nov'05

    SQL execution error ORA-00904

    I'm receiving the SQL execution error "ORA-00904: invalid column name." I have checked all the names and they are correct. I checked the SQL string and it is working in TOAD, which means it retrieved the data. I am lost!  Continue Reading

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close