select column_name, frdscr, ltrim(rtrim(substr(column_name, 3, length(column_name)-2))), ltrim(rtrim(frdtai))
from all_tab_columns, dd900.f9202
where FRSYR = ' '
and ltrim(rtrim(substr(column_name, 3, length(column_name)-2))) = ltrim(rtrim(frdtai))
and table_name = 'F4201' and owner = 'TESTDTA'
Tuesday, 20 September 2011
Simple script for getting JDE DD descriptions for column names in oracle
Subscribe to:
Post Comments (Atom)
-
Why am I still doing this. Fixing fat clients is not a lot of fun. Here is a couple of tips for connecting to the database using NTS and... -
Ever wanted to know what that pesky OMW transfer error message code meant, here is the list of errors and what they mean in some meaningful...
-
CK : User Preference Cookies (what is saved in user preferences – Enable Hover Forms etc) GF : Grid Format (added when user adds a fri...
No comments:
Post a Comment