• 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

  • 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

    Equivalent Oracle syntax of SQL:1999 syntax

    What is the equivalent Oracle syntax of the following SQL:1999 syntax?  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

    Best HA and OS options for data warehouse

    We are researching HA options and due to budgeting, the project is looking at migrating to a Dell Linux Oracle RAC environment. One of the databases on the Sun Solaris system is our data warehouse (OWB). My question: What are the best OS and HA ...  Continue Reading

  • April 21, 2006 21 Apr'06

    ORDER BY a specified sequence

    I'm trying to create an SQL query with the IN clause where I give the IDs to match. Now I want the order of these records to be the same as I give in the IN clause. But it's not happening.  Continue Reading

  • April 21, 2006 21 Apr'06

    What other certifications will increase my market value?

    I am an Oracle certified DBA, with work experience of more than four years. I want to do some other certifications so that I can increase my market value.  Continue Reading

  • April 21, 2006 21 Apr'06

    Query sometimes returns ORA-1403

    We have a query that sometimes returns ORA-1403. The same query executes successfully from the SQL*Plus prompt and many times from our application. Also, we can access the same data using cursors or an update query. The solution is to restart Oracle...  Continue Reading

  • April 20, 2006 20 Apr'06

    Solaris

    Solaris is the computer operating system that Sun Microsystems provides for its family of Scalable Processor Architecture-based processors as well as for Intel-based processors.  Continue Reading

  • April 20, 2006 20 Apr'06

    OAUG to unveil new user forums at Collaborate '06

    The executive director of the OAUG tells Oracle business applications users what to expect from next week's Collaborate '06 conference in Nashville.  Continue Reading

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close