CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

JDE Data Base Query assistance

edited Dec 4, 2013 11:15AM in CNC, DB and Operating System - JDE1 (MOSC) 2 commentsAnswered
Hello, I am trying to create a table count for all the tables in a particular user/schema for example in DV910 there are few table I would like to get a row count for each table.

I was giving this query I just need help making it for all tables inside DV910

select num_rows from dba_tables where table_name in ('F46L99','F3111')

BTW I have the list of the table per each schema or user we are on Oracle DB 11

Thanks,

Youssef

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center