Results 1 to 10 of 10
  1. #1
    Join Date
    Jul 2004
    Posts
    7

    Unanswered: how to working with oracle database schemas

    hi...
    i want to use Oracle schemas(Human Resources Schemas),that come with oracle database to reach Departments,Employees,... tables ,to work and practice SQL Commands ,how can i reach those schemas and work with them (is there any possibility to work through ISQLPLUS).

    Note : my operating system is Windows XP.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >(is there any possibility to work through ISQLPLUS).
    Yes, if the system is properly configured to support ISQLPLUS.
    The default installation does not include ISQLPLUS support.
    The setup of ISQLPLUS is non-trivial, but can be made to work.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    When you installed Oracle, you should have installed SQL*Plus as well. Find it as icon in Start - Programs - Oraclesomething, or in Start - Run box write "SQLPLUS".
    Both should run Oracle's SQL*Plus instance which will enable you to do what you wanted - practice SQL commands.

  4. #4
    Join Date
    Jul 2004
    Posts
    7

    More details

    folks... u didnt get the question
    i have ISQL*PLUS and SQL PLUS in my machine.
    They work properly,but my question is :
    how can i get the tables from Human Resources Schema (such as Departments and Employees tables,those tables have alot of data (i think real data)that make a sense when u work with, and they r the main tables that r used in alot of Oracle press books),so i hope u got me this time

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Oracle is not your typical Windoze point & click utility.

    You should start by RTFM

    http://download-west.oracle.com/docs...a96524/toc.htm
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  6. #6
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    What do you mean by "how can I get the tables"? Their names? Description? Data? If so, use (respectively)

    SQL> select * from tab;
    SQL> desc table_name_you'd_like_to_describe;
    SQL> select * from table_name_you'd_like_to_query;

    However, you'd better read the manual Anacedent advised.

  7. #7
    Join Date
    Aug 2004
    Location
    Bangalore, INDIA.
    Posts
    3

    Smile Access Privilege

    Hi All,

    If I'm getting your question right then, to get access to tables of Human Resources Schema (such as Departments and Employees tables,those tables have alot of data), that Schema in your case "Human Resource" or "SYS" i.e a super user, should GRANT you (your schema) access to those tables.

    Eg: GRANT SELECT ON TABLE_NAME TO SCHEMA_NAME;
    Note: This statement executed by the owner of the object, will give only SELECT privilege on specific table.

    Hope it is of some help.

  8. #8
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    A light just dawned (I think). Do you mean the EMP and DEPT tables that are loaded into the SCOTT schema that are used for examples in the oracle texts?
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  9. #9
    Join Date
    Jul 2004
    Posts
    7
    thnx guys...
    well regarding (GRANT SELECT ON TABLE_NAME TO SCHEMA_NAME) didnt work unfortunately..,
    regarding( Do you mean the EMP and DEPT tables that are loaded into the SCOTT schema ) no i dont mean those tables, i mean EMPLOYEES,DEPARTMENT...and other tables that come with oracle human resources schema,u can fined this schem in this path:
    oracle\ora92\demo\schema\human_resources. (windows plat forms)
    any way thx for ur help all

  10. #10
    Join Date
    Mar 2004
    Location
    California
    Posts
    58
    Well just to let you know, not all those tables are already created. Scripts are provided for you to create those table. To run a sl cript in SQl*plus type @<path of the file> at the sql prompt.

Posting Permissions

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