"Students" table schema and data used in various examples on SQLINFO.net site

Students table schema (ddl)

CREATE TABLE STUDENTS
     (
        STUDENT_ID                     NUMBER          NOT NULL , 
        PASSWORD                       VARCHAR2(15)        NULL , 
        EMPLOYEE_ID_FK                 VARCHAR2(15)        NULL , 
        CUSTOMER_ID_FK                 VARCHAR2(15)        NULL , 
        ACTIVE_FLG                     NUMBER(4,0)     NOT NULL , 
        LASTNAME                       VARCHAR2(30)        NULL , 
        FIRSTNAME                      VARCHAR2(20)        NULL , 
        MIDDLENAME                     VARCHAR2(20)        NULL , 
        PREFIX_NAME                    VARCHAR2(6)         NULL , 
        SUFFIX_NAME                    VARCHAR2(6)         NULL , 
        GENDER_CODE                    VARCHAR2(1)         NULL , 
        BIRTH_DTTM                     DATE                NULL , 
        BIRTH_CITY_NM                  VARCHAR2(20)        NULL , 
        BIRTH_STATE_CODE               VARCHAR2(2)         NULL , 
        BIRTH_COUNTRY_CODE             VARCHAR2(2)         NULL , 
        GPA                            NUMBER              NULL , 
        IS_ON_STAFF                    NUMBER(4,0)     NOT NULL , 
        SOC_SEC_NUM                    VARCHAR2(9)         NULL , 
        DRIVER_LICENSE_NUM             VARCHAR2(25)        NULL , 
        DRIVER_LICENSE_STATE_CODE      VARCHAR2(2)         NULL , 
        DRIVER_LICENSE_COUNTRY_OCDE    VARCHAR2(2)         NULL , 
        OTHER_ID_NUM                   VARCHAR2(25)        NULL , 
        CITIZEN_COUNTRY_CODE           VARCHAR2(2)         NULL , 
        MARITAL_STATUS_CODE            VARCHAR2(3)         NULL , 
        RACE_CODE                      VARCHAR2(5)         NULL , 
        ETHNIC_GROUP_CODE              VARCHAR2(5)         NULL , 
        VETERAN_MILITARY_STATUS_CODE   VARCHAR2(2)         NULL , 
        FIN_ALERT_CODE                 VARCHAR2(2)         NULL , 
        INACTIVE_DATE                  DATE                NULL , 
        INACTIVE_REASON                VARCHAR2(255)       NULL , 
        EMPLOYEE_INACTIVATING          NUMBER              NULL , 
        CONSTRAINT SYS_C004714 PRIMARY KEY (STUDENT_ID)
     )

NOCACHE
LOGGING
/


CREATE UNIQUE INDEX IX_STUDENTS1
       ON    STUDENTS(PASSWORD) ; 

CREATE UNIQUE INDEX IX_STUDENTS2
       ON    STUDENTS(OTHER_ID_NUM) ; 

CREATE INDEX IX_STUDENTS3
       ON    STUDENTS(DRIVER_LICENSE_NUM) ; 

CREATE INDEX IX_STUDENTS4
       ON    STUDENTS(LASTNAME) ; 

CREATE INDEX IX_STUDENTS5
       ON    STUDENTS(SOC_SEC_NUM) ;

If you find this site useful and are a book buyer/reader... You can support my site by clicking on one of the Links below to Abe books By doing this, I will receive a small commision on your purchase and making your purchase will not cost you any more money than if you went directly the site yourself! Abe Books sells books at a fraction of the original cost. I have purchased many books from them originally cost $40.00 for as little as $5 to $10 dollars including shipping costs Click on applicable icon to find books at Abe Books on ...
Oracle 8i and 9i	Oracle 10g	PL/SQL

Abe Books is one of my affiliates. I only use affiliates that I also purchase products from. I love Abe books. If it is printed they likely have a copy. I have also included a generic link to Abe Books below. Once on their site, you will find that they have a nice, easy to use search engine so to find what you are looking for.