Oracle Create scott schema ....
create oracle scott user
sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun Apr 10 17:49:19 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> @?/rdbms/admin/utlsampl.sql -----!!!!!!!!!!!!!!! run this script to create scott schema
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
[oracle@ora12c ~]$ !sql
sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun Apr 10 17:49:51 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> SELECT username, account_status FROM dba_users WHERE username = 'SCOTT';
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
SCOTT OPEN
SQL> connect scott/tiger
Connected.
SQL> select * from tab ;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
BONUS TABLE
DEPT TABLE
EMP TABLE
SALGRADE TABLE
====
with insert command
create table scott.emptest as select * from scott.emp where 1=2 ;
alter session set nls_date_format='dd-mon-yy';
set linesize 300
col x for a200
select 'insert into scott.emptest( EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values ('
||EMPNO||','''||ENAME||''','||''''||JOB||''','||MGR||','''||HIREDATE||''','||SAL||','||nvl( to_char(comm),'null')||','||DEPTNO||' );' X from scott.emp ;
HR data
https://github.com/oracle-samples/db-sample-schemas/tree/main/human_resources
https://github.com/oracle-samples/db-sample-schemas/releases
