Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Where can i download the employee database for oracle certification test?
On Sat, 12 Oct 2002 18:00:59 +0000, Ragnar wrote:
> In the Oracles html guide for "Oracle certified developer" there is a lot of
> code examples on a employee database. Is this database available for
> download somewhere?
>
> Regards
Here is the output from my Linux version of Oracle 9i R2. The hr schema is supplied with the database. If this is the correct schema. There are several different ones. Observe that the hr user is locked and has to be unlocked before you use it. Use oemapp dbastudio for this.
Cheers
dmz17
Connected to:
Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production
SQL> descr 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> Received on Sat Oct 12 2002 - 16:21:55 CDT
![]() |
![]() |