Tuesday, August 4, 2020
    Home Technology Why Scott becomes default schema in Oracle?

    Why Scott becomes default schema in Oracle?

    Hi ALL,

    As Oracle DBA we are familer with SCOTT schema. This schema is default sample and example schema which is available since past several  years.

    - Advertisement -

    Why this SCOTT schema still persists?

    Do you guess any reason?

    Who is  SCOTT?

    Actualy beginner of  SQL*Plus was Bruce Scott. He was original auther of SQL*Plus.  In the memory of Bruce Scott, a sample schema named “scott” has been created in Oracle database with set of example tables for learning purpose.  There are famous tables like EMP, DEPT, SALGRADE , BONUS.

    Password of Scott schema is “tiger” coming from his daughter’s cat name. His daughter’s cat name was “tiger”.

    Bruce Scott was the first employee of Oracle Corporation. Due to these reasons Oracle Corporation still use default sample schema named “SCOTT” and password of same schema as “tiger” .

    Thanks and Regards,

    Gitesh Trivedi

    [email protected]


    Previous articleAbout
    Next articleSQL a History


    Comments are closed.

    - Advertisment -

    Most Popular

    MySQL as PHP database

    The article illustrates the relationship between data and semantics of data stored in a database with reference to the semantic WEB

    Supply Chain Management in ERP

    The article provides detail of what is supply chain management system and what is the importance.

    Business Intelligence Market

    The blog explains how business intelligence is growing in Global market and what is the future of BI.

    Peer to Peer Technology

    The article explains what is the peer to peer p2p technology and how it works and helps to improve your knowledge.

    Recent Comments