• April 27, 2006 27 Apr'06

    Oracle beefs up database security at Collaborate '06

    Oracle's new Database Vault and Secure Backup offerings promise to make it easier to avoid internal threats and automate disk-to-tape backup. SearchOracle.com talked to Oracle's Mark Townsend at Collaborate '06 in Nashville to find out more.  Continue Reading

  • April 25, 2006 25 Apr'06

    Open source EnterpriseDB takes aim at Oracle customers

    In an interview with SearchOracle.com, Andy Astor, EnterpriseDB's president and chief executive officer said his firm hopes to lure Oracle customers over to the open source world.  Continue Reading

  • April 21, 2006 21 Apr'06

    Using a pre-existing list

    I'm attempting to write a query against a table (Table_A) which has three columns. I have a pre-existing list that I'm attempting to bounce off my table. I want, however, all of the names in my pre-existing list to appear in my results. If the ...  Continue Reading

  • April 21, 2006 21 Apr'06

    ORA-00904 error on select statement

    I am working in JDEVELOPER using JDBC. This program is working with objects. I am getting this error on a SQL statement: "java.sql.SQLException: ORA-00904: "R": invalid identifier." How do I fix this? It seems like object r is not connected to ...  Continue Reading

  • April 21, 2006 21 Apr'06

    Using roles/grants vs. public synonym

    I created two users, U1 and U2, then created role R. I created tables in user U1 and gave grants to select, insert, update and delete to role R. I assigned role R to U2. Now if I log in through user U2 then I am able to see all objects of user U1. I...  Continue Reading

  • April 21, 2006 21 Apr'06

    SQL statement gets very long very fast

    I have the following SQL statement. I now need to substitute pkColumn in that statement with a composite primary key of, let's say, two integer columns. The problem, besides performance issues, is that the statement gets very long very fast and ...  Continue Reading

  • April 21, 2006 21 Apr'06

    Can't get data with synonym name

    I created a public synonym with the same object name to allow me to refer to that object without prefixing the schema name, and I gave a select insert and update grant to public on that object, but I still can't get the data by using the synonym ...  Continue Reading

  • April 21, 2006 21 Apr'06

    What is High Water Mark?

    What exactly is High Water Mark and how to relate it with PCTFREE and PCTUSED?  Continue Reading

  • April 21, 2006 21 Apr'06

    Multiple SIDs in same database?

    Can I create multiple Oracle SIDs in the same Oracle database or do I have to create a different SID using DBCA?  Continue Reading

  • April 21, 2006 21 Apr'06

    Is Oracle easy to learn?

    Is Oracle easy to learn? I am creating an information system using Visual Studio and Microsoft Access. I chose MS Access as it is not based on a command language whereas Oracle is. Also Access has a GUI whereas Oracle does not, correct? I'm a bit ...  Continue Reading