Install scott sample mode (Helloblock writing)

InstallScottSample ModeHelloblockWriting)

1Check whether the database hasScottExample mode:

SQL> select username from dba_users;

USERNAME

------------------------------------------------------------

SYS

SYSTEM

DBSNMP

MGMT_VIEW

SYSMAN

OUTLN

LBACSYS

WMSYS

TSMSYS

DIP

There are no scott users in the current database.

2, InstallationScottSample Mode

SQL> @? /Rdbms/admin/utlsampl. SQL

SQL> select username from dba_users where username = 'Scott ';

USERNAME

------------------------------------------------------------

SCOTT

3, VerificationScottExample mode:

SQL> conn scott/tiger

Connected.

Scott's default password is tiger.

SQL> show user;

USER is SCOTT

SQL> col tname format a10;

SQL> select * from tab;

TNAME TABTYPE CLUSTERID

----------------------------------

DEPT TABLE

EMP TABLE

BONUS TABLE

SALGRADE TABLE

User scott has multiple tables.

Mail: helloblock@126.com

QQ: 1654294099

This article is from the "Helloblock DBA footprint" blog, please be sure to keep this source http://helloblock.blog.51cto.com/7899615/1294381