I am very new to Java so please bear with me. I am trying to build an SQL statement that will prefix an Oracle hint, like SELECT /*+ index(column index)*/ column,column,. I have a prepared statement built and I just want to put this hint ahead of the columns. Looks like this creates the list and columns: // create & return persistable objects: SuggestedPOSKUStoreQuantityEntity
return createPersistable(persistableList, ((SelectCommand)selectCommand).getSelectColumns()); Will I need to add the hint in the getSelectColumns function, or is there a way to break apart the prepared statement and insert it in there? I'm probably asking for help and providing too little info to help solve this issue?
Thank You.
return createPersistable(persistableList, ((SelectCommand)selectCommand).getSelectColumns()); Will I need to add the hint in the getSelectColumns function, or is there a way to break apart the prepared statement and insert it in there? I'm probably asking for help and providing too little info to help solve this issue?
Thank You.