Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reg : Context-switching for built-in functions -

915396Apr 30 2013 — edited May 1 2013
Hi Experts,

Asking this question just out of curiosity to know the internal concepts.
In a SQL query often we use the in-built Oracle functions like LOWER, UPPER, etc.

In this case, does context-switch happen?

Will I be able to look into the code of these functions after logging into SYS schema as SYSDBA?
FYI - I've Oracle XE 11.2 installed in my home pc (currently in office, so don't have access to it).

Help much appreciated!

Thanks,
Ranit
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 29 2013
Added on Apr 30 2013
10 comments
503 views