How to Select Schema of Record or Table of Peoplesoft in SQL

How to Select Schema of Record or Table of Peoplesoft in SQL

How to Select Schema of Record or Table of Peoplesoft in SQL

You can view fields or all detail of table of peoplesoft in database by use sql statement

SELECT * FROM ALL_TAB_COLUMNS
where owner = ‘owner name’ AND TABLE_NAME =’RecordName’;

If you want to show all field of record then you can use this sql

SELECT COLUMN_NAME FROM ALL_TAB_COLUMNS
where owner = ‘owner name’ AND TABLE_NAME =’RecordName;