I meant all tables the oracle login has access.

select * from <linked oracle server name>..SYS.ALL_TAB_COLUMNS where table_name = <your table name>;

It will give you columns of all tables you have access. 

select * from <linked oracle server name>..SYS.DBA_TAB_COLUMNS where table_name = <your table name>;

Thank you very much Keith! It works.

Anyone know why the differential backup size is close to full backup size after run sp_spaceused with @updateusage = true ?

Thank you very much. Help a lot from you guys. Any ideas why the reserved value in sp_spaceused is very close to the backup size? In my case, the reserved...

Thank you very much! You got all right. Appreciate ...

Thanks Johnathan.

In general, the issue is related to a binomial coefficient theory. The return rows should be nCm, read as n choose m. Here is...

You will miscount unique rows if you use this script. It can't distinguish unique rows from dups. For example, you have five rows with values a, b, c, d...

Thanks fhanlon.

Johnathan, There is still a problem with simple self-join. If the table has duplicates, the total number of return will not match the binomial coefficient...

Thank you very much Jonathan!

Thanks. You are right about the formula. Any ideas how to write it in sql?