Utilities Blog by JuCa Cruz
If it happened to me before, maybe what I've posted here will help you.
Saturday, April 13, 2013
Getting column info from Oracle table you don't own (without using describe)
How would one get columns information on table which he doesn't own, but has select granted? This is, without using
DESCRIBE table_name
My answer is:
select owner, column_name from all_tab_columns where table_name = 'STUDENT';
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment