Scott Schema Oracle

Scott is a database user used for demonstration purposes containing the famous EMP, DEPT, BONUS and SALGRADE tables. The SCOTT user is created on default when oracle is installed. In case when not available we need to run the below path " @?/rdbms/admin/utlsampl.sql;" Here @ is used to run the package ?/ is to identify the home path of the oracle database where we can find a folder "rdbms" --> "admin" in which "utlsampl.sql" file is found. Executing this "utlsampl.sql" will create the SCOTT schema Step 1: the script to create SCOTT user and the corresponding tables in available in the "utlsampl.sql" file Step 2: Execute the package Step 3: conn to SCOTT user and check for tables. The default password for SCOTT user will be "Tiger" Step 4: check for table contents