Results 1 to 3 of 3

Thread: Schema

  1. #1
    Join Date
    Jan 2004
    Posts
    12

    Question Unanswered: Schema

    If I have a input parameter as the schema how can I go back and get the tables in that particular schema?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    SELECT TABLE_NAME FROM USER_TABLES;

  3. #3
    Join Date
    Jan 2004
    Posts
    12
    Thanks, I wasn't even thinking about the data dictionatry views. I was trying to be more complex. Sorry about that.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •