Thursday, July 9, 2009

SQL operators New for Oracle10g

IS NAN : New for Oracle10g. Matches the NaN special value, which means "not a number"
IS INFINITE : New for Oracle10g. Matches infinite BINARY_FLOAT and BINARY_DOUBLE values


You can also use the NOT operator to reverse the meaning
IS NOT NAN
IS NOT INFINITE

How do you disable all the OA Framework personalizations in eBusiness Suite?

All the personalizations done to the system can be disabled by simply setting a profile option to Yes at site level.
Name of this profile option is Disable Self-Service Personal

Note:- You can de-activate personalizations against individual pages selectively, by clicking on button "Manage Personalizations". You may need to give yourself access to responsibility named "Functional Administrator", so that you can disable personalizations selectively.