摘要:
An SQL that will identify permission lists along with permission lists description assigned to a specific component. SELECT menu.menuname, compdfn.pnlgrpname, auth.classid permission_list, ... 阅读全文
摘要:
If you want to see how much space your tables are taking in the database, log in to the shcema and execute this SQL. SELECT segment_name table_name, MAX (tablespace_name) tablespace_name, S... 阅读全文
摘要:
In many cases you might need to compare data between tables across different databases. For example your test instance and production instance. You can easily create a database link between the 2 i... 阅读全文
摘要:
I find the MINUS operator very handy and use it a lot to compare tables and find out missing things. For example suppose you want to compare Table1 with Table2. If the two tables have the same layou... 阅读全文
摘要:
A function to call UNIX and/or shell script from PeopleCode. /*call unix script from PeopleCode*/ Function CallScript; /*According to PeopleBooks, PS_HOME is always prefixed to the file location... 阅读全文
摘要:
This code i have got Ittool box.com. It is very usefull. we usually have requirement when we want to hide some translate values from translate field on page for some business reason. In this case we c... 阅读全文