Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    76

    Unanswered: selecting the schema

    Hi All,

    How to select the schema names. Will below query solve my requirement.

    select distinct(owner) from all_objects;

    Also is it possible to have different schema name and user name.

    Cheers,
    Cheeku

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    That query will show all schemas that contain objects.

    This will show you all users, whether they own objects or not:

    SQL> select username from all_users;

    You can't have different schema and user names. The name of a schema is simply the name of the owner of the schema objects.

Posting Permissions

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