Ask The Oracle Mentors

Recently Answered

	Bitmap 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...
	Convert 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....
	How 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...
	Cannot 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 ...
	Prevent 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...