Database Networking (MOSC)

MOSC Banner

12c New Feature: SQL*Plus Records History of Commands

edited Apr 18, 2017 3:14AM in Database Networking (MOSC) 4 comments

See the following link:

http://docs.oracle.com/database/122/SQPUG/HISTORY.htm#SQPUG-GUID-CCF9B047-3122-4644-BA06-5FA4B5812E9F

sqplus /nolog

SQL>set HIST[ory] ON   <==Set history ON

Issue commands:

SQL> create public database link test connect to test identified by test using 'test';

Database link created.

SQL>alter system set local_listener="(address=(protocol=tcp)(port=1521)(host=orclhost))" scope=memory;

System Altered

SQL> select * from dual;

D

-

X

SQL> desc dual;
Name                                      Null?    Type
----------------------------------------- -------- ----------------------

DUMMY                                              VARCHAR2(1)

SQL> hist   <==run HIST[ory] to show list:

  1 create public database link test connect to test identified by test using 'test';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center