Click here to Skip to main content
11,928,352 members (52,973 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.151126.1 | Last Updated 1 Jan 1900
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid