SELECT * FROM TABLENAME WHERE regexp_like (FIELDTOBECHECKED,'^[A-Za-z0-9]+$ ...
January 31, 2013
Peoplesoft SQL Query to Identify Field Length and Field Datatype
Posted by Dineshkumar R | ALL POSTS, SQL Queries,
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' ...