count(*) from Table

[bsbernabe]

Hello There,

my concern is to display the Table Name, Number of Columns & numbers of rows per table from oracle db

i try to use

Load *,

SQLCOLUMN but i only got is Table Name & Number of Column i need also numbers of rows per table, so i create a simple script individually to count the number of rows  per table like union SQL but my problem here is when  i run the script with union i cant define what table it is because the field displayed is count like below:

Select count(*) from Table union

Any other solution for this?

i need somebody help..

Best Regards,

Bing

[Chanty4u]

Hi,

not sure but did you tried with join instead of union?

Select count(*) from Table Join

[MayilVahanan · Accepted solution]

Hi @bsbernabe 

If you want to know the no. of records in the table, you can use count(Primarykey) in the front end. 

Or

Load *, 1 as RowCount;

Sql select * from yoursourcetable;

Then, in front end, you can use Sum(RowCount) to get the number of rows loaded.

Hope its helps