Results 1 to 2 of 2

Thread: Oracle problem from Database Class

  1. #1
    Junior Member
    Join Date
    Apr 2013
    Answers
    1

    Oracle problem from Database Class

    I have this problem for my database class:
    Produce a list of jobs for departments 10, 50, and 20, in that order. Display the job ID and
    department ID by using the set operators.

    Here are the probable tables used for this problem:

    SQL> desc departments
    Name Null? Type
    ----------------------------------------- -------- ----------------------------
    DEPARTMENT_ID NOT NULL NUMBER(4)
    DEPARTMENT_NAME NOT NULL VARCHAR2(30)
    MANAGER_ID NUMBER(6)
    LOCATION_ID NUMBER(4)

    SQL> desc jobs
    Name Null? Type
    ----------------------------------------- -------- ----------------------------
    JOB_ID NOT NULL VARCHAR2(10)
    JOB_TITLE NOT NULL VARCHAR2(35)
    MIN_SALARY NUMBER(6)
    MAX_SALARY NUMBER(6)

    SQL> desc employees
    Name Null? Type
    ----------------------------------------- -------- ----------------------------
    EMPLOYEE_ID NOT NULL NUMBER(6)
    FIRST_NAME VARCHAR2(20)
    LAST_NAME NOT NULL VARCHAR2(25)
    EMAIL NOT NULL VARCHAR2(25)
    PHONE_NUMBER VARCHAR2(20)
    HIRE_DATE NOT NULL DATE
    JOB_ID NOT NULL VARCHAR2(10)
    SALARY NUMBER(8,2)
    COMMISSION_PCT NUMBER(2,2)
    MANAGER_ID NUMBER(6)
    DEPARTMENT_ID NUMBER(4)

    SQL> desc job_history
    Name Null? Type
    ----------------------------------------- -------- ----------------------------
    EMPLOYEE_ID NOT NULL NUMBER(6)
    START_DATE NOT NULL DATE
    END_DATE NOT NULL DATE
    JOB_ID NOT NULL VARCHAR2(10)
    DEPARTMENT_ID NUMBER(4)


  2. #2
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Oracle problem from Database Class

    What have you tried so far ?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact