Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered Report

Chris SaxonBitmap indexes and locking
Hi TomI would like to ask a Question about Bitmap indexes, somethings in this indexes is still unclear for me.Many rumors revolves around what exactly gets locked (and how) during a DML operation on column\row with Bitmap index, it starts with a full exclusive...
Chris SaxonConvert verbs to present tense
Hi Guys,Is there a function within Oracle which will review the words within a text string and convert them to present tense?Thank you....
Chris SaxonHow can I determine the underlying expression for a given view name/column alias in a query?
I have several hundred views that contain column aliases in their definitions. I need to programmatically (preferably SQL query) determine the underlying expression for a given column alias, but I can't find any views or tables in Oracle that correlate the al...
Chris SaxonCannot remove explain plan from shared pool
Hello, I have a problem with a query. Basically I have 2 identical queries with 2 different SQL_IDs. One is using a fast execution plan and the other one is using the very slow one. Hence I decided to remove the slow plan from cache but DB tells me the object ...
Chris SaxonPrevent Duplicate value of column in Interactive Grid in case no Constraint at database level
in sample dataset emp and dept.how to prevent duplicate value of column in interactive grid.case -1-------Requirement of that in emp table emp name should be not duplicate for the same department. for example dept 10 - account i entered sam with employee id 89...