Top big tables by rows in peoplesoft

SELECT table_name,
num_rows,
rank() over (order by num_rows DESC ),recdescr
FROM all_tables, PSRECDEFN
WHERE instr(table_name,'PS_',1) >0 and num_rows>0
and instr(table_name,recname)>0 and (length(table_name)-length(recname)<4)

Views: 73

▶ Reply to This

Replies to This Discussion

Permalink Reply by Aiko Noren on May 23, 2013 at 4:35am

This was reallyy veryy helpfull.I appreciate it.

Permalink Reply by kristen on July 9, 2017 at 1:15pm

it's a pleasure to meet you. I am USA Army personnel, i have an important thing to discus with you.
Please write me on my email (captkristen899@gmail.com)

RSS

PeopleSoft Jobs in US

Groups

Videos

  • Add Videos
  • View All

© 2024   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service