Query to find the 10 Largest Objects in DB

SELECT * FROM
(
select
    SEGMENT_NAME,
    SEGMENT_TYPE,
    BYTES/1024/1024/1024 GB,
    TABLESPACE_NAME
from
    dba_segments
order by 3 desc 
) WHERE
ROWNUM <= 10 

Query to remove HTML Tags from Rich Text Long edit box

Below query used to remove HTML tags from Rich text box field.

SELECT REGEXP_REPLACE(DESCRLONG,'<[^>]*>',' '), DESCRLONG FROM PS_HRSTOR_QA_TBL;

Note: Above query only works on Oracle database.

Oracle OpenWorld Highlights

Run Process from hyperlink without code

The following steps help to run process from hyperlink or from push button without any code.

 

Link To Portal Folder

The below code can be used for a link to navigate to your portal folder.

Declare Function NavPageURL PeopleCode EOPP_SCRTN_WRK.FUNCLIB FieldFormula;

&LINKURL = NavPageURL(%Portal, %Node, "your-folder-object-name", "PSC", "", "", "False", "", "", "");
%Response.RedirectURL(&LINKURL);

Objects that can't be copied through File

Following objects can’t be copied through Copy project to File option.

· Access Groups
· Trees
· Roles
· Message Catalog Entries

SQL To find Who Modified PeopleCode

The below SQL helps to identify who modified PeopleCode.

SELECT objectvalue1 record_name, objectvalue2 field_name,
       objectvalue3 peoplecode_event, lastupddttm, lastupdoprid
  FROM pspcmprog
WHERE objectvalue1 = :record_name
   AND objectvalue2 = :field_name
   AND UPPER (objectvalue3) = UPPER (:peoplecode_event);