Click here to Skip to main content
13,000,636 members (39,382 online)

Comments by Gareth Barlow (NBNi) (Top 1 by date)

Gareth Barlow (NBNi) 2-Jan-11 6:49am View
Wont work on oracle but you can use
"select * from user_tables" for schema level tables or

"select * from all_tables where schema_name = 'schema_name'" to get tables from a different schema

Advertise | Privacy | Mobile
Web02 | 2.8.170624.1 | Last Updated 1 Jan 1900
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid