• 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

    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

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close