Create scott/tiger at the beginning of Oracle for test. scotttiger

Create scott/tiger at the beginning of Oracle for test. scotttiger

Install oracle11g database software on redhat5.5 (32bit), install a database, log on to the database, and create scott/tiger for testing.

First, log on to the database. The database is not started when you log on here.

[Oracle @ localhost oradata] $ sqlplus/as sysdba

SQL * Plus: Release 11.2.0.1.0 Production on Thu Jul 9 17:54:53 2015

Copyright (c) 1982,200 9, Oracle. All rights reserved.

Connected to an idle instance.

SQL>

Create a scott user to learn SQL statements. Put the script in $ ORACLE_HOME/rdbms/admin/utlsampl. SQL

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

SQL> conn scott/tiger
Connected.
SQL> select * from emp;

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
------------------------------------------------------------------------------
7369 smith clerk 7902 17-DEC-80 800 20
7499 allen salesman 7698 20-FEB-81 1600 300 30
7521 ward salesman 7698 22-FEB-81 1250 500 30
7566 jones manager 7839 02-APR-81 2975 20
7654 martin salesman 7698 28-SEP-81 1250 1400 30
7698 blake manager 7839 01-MAY-81 2850 30
7782 clark manager 7839 09-JUN-81 2450 10
7788 scott analyst 7566 19-APR-87 3000 20
7839 king president 17-NOV-81 5000 10
7844 turner salesman 7698 08-SEP-81 1500 0 30
7876 adams clerk 7788 23-MAY-87 1100 20
7900 james clerk 7698 03-DEC-81 950 30
7902 ford analyst 7566 03-DEC-81 3000 20
7934 miller clerk 7782 23-JAN-82 1300 10

14 rows selected.

SQL>

 

Normally, the above results are not so neat. You can set the displayed variables in the home directory.

Environment Settings:
[Oracle @ localhost ~] $ Vim login. SQL
Define_editor = vi
Set line 180
Sets pages 999