Skip to Main Content
Ask The Oracle Mentors
Ask a Question
Recently Answered Report
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...
Upcoming Office Hours
All Office Hours
Free training, how-tos and Q&A with Oracle experts, every month!
Salim Hlayel - سليم هليّل
Using Maps in Oracle APEX
Next: June 26 14:00 UTC
Hands-on Lab: Machine Learn...
Next: June 29 15:00 UTC
KSCOPE: Using Graph Studio ...
Next: July 1 15:00 UTC
JSON in Oracle Database
Next: July 13 17:00 UTC