Click here to Skip to main content
12,445,482 members (62,669 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.160811.3 | Last Updated 1 Jan 1900
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid