0 comments

PeopleSoft SQL Query to find alphabets and numbers in Field

SELECT * FROM TABLENAME WHERE regexp_like (FIELDTOBECHECKED,'^[A-Za-z0-9]+$ ...

0 comments

Peoplesoft SQL Query to Identify Field Length and Field Datatype

SELECT DISTINCT P.LBLTEXT,P.FIELDNAME,P.RECNAME,F.LENGTH ,(CASE WHEN F.FIELDTYPE = '0' THEN 'Character' WHEN F.FIELDTYPE='1' THEN 'Long Character' WHEN F.FIELDTYPE='2' THEN 'Number' WHEN F.FIELDTYPE='3' THEN 'Signed number' WHEN F.FIELDTYPE='4' THEN 'Date' WHEN F.FIELDTYPE='5' THEN 'Time' WHEN F.FIELDTYPE='6' THEN 'DateTime' WHEN F.FIELDTYPE='8' THEN 'Attachment' ...