how to select table name?

[darwin101]

Could someone tell me how/if it is possiable to select the table name from oracle in a report type query? It would be great to also include the schema name.

Thanks for your help.

 

[karluk]

Maybe I'm misinterpreting your question, but I've sometimes found it useful to select the table name as a literal, so that I can easily identify which table my query is coming from.

select 'MYID' as schema_name, 'MY_TABLE' as table_name,
col1, col2, ... from my_table;

 

[darwin101]

Thats what I am trying not to do. I guess I should just use that method as it is 6 one way or half a dozen the other.
Thanks for responding