Thursday, May 9, 2013
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';
Subscribe to:
Posts (Atom)
