Oracle Database 12c Release 2 - SQL*Plus History Command


As you know that we can repeat our previous SQL*Plus commands in Windows CMD. But in UNIX based systems not supported command line history of SQL*PLus.  For this reason in UNIX and Linux, we used rlwrap utility to see the SQL*Plus command line history and quickly recall previous SQL*Plus commands.

With seconds release of Oracle Database 12c coming SQL*Plus history command for the history of the command line in Linux.

I want to share some example for this command:

Before using History we must enable history command as below:

SQL> set history on

The syntax of HISTORY command as bellow

SQL> help history

 HISTORY
 -------

 Stores, lists, executes, edits of the commands
 entered during the current SQL*Plus session.

 HIST[ORY] [N {RUN | EDIT | DEL[ETE]}] | [CLEAR]

 N is the entry number listed in the history list.
 Use this number to recall, edit or delete the command.

 Example:
 HIST 3 RUN - will run the 3rd entry from the list.

 HIST[ORY] without any option will list all entries in the list.


As you seen from syntax, we can edit, delete, clear list items in history.

SQL> set history on 
SQL> 
SQL> 
SQL> select name from v$database;

NAME
---------
DB122

SQL> select name, database_role from v$database;

NAME   DATABASE_ROLE
--------- ----------------
DB122   PRIMARY

SQL> 
SQL> select banner from v$version; 

BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
PL/SQL Release 12.2.0.1.0 - Production
CORE 12.2.0.1.0 Production
TNS for Linux: Version 12.2.0.1.0 - Production
NLSRTL Version 12.2.0.1.0 - Production

SQL> 
SQL> 
SQL> hist list
  1  select name from v$database;
  2  select name, database_role from v$database;
  3  select banner from v$version;

SQL> 
SQL> 
SQL> hist 1 run

NAME
---------
DB122

SQL> hist 3 run

BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
PL/SQL Release 12.2.0.1.0 - Production
CORE 12.2.0.1.0 Production
TNS for Linux: Version 12.2.0.1.0 - Production
NLSRTL Version 12.2.0.1.0 - Production

SQL> 
SQL> 
SQL> hist clear
SQL> 
SQL> hist list
SP2-1651: History list is empty.
SQL> 
SQL> 
SQL> select name from v$database;

NAME
---------
DB122

SQL> select banner from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
PL/SQL Release 12.2.0.1.0 - Production
CORE 12.2.0.1.0 Production
TNS for Linux: Version 12.2.0.1.0 - Production
NLSRTL Version 12.2.0.1.0 - Production

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
db122

SQL> 
SQL> 
SQL> hist list
  1  select name from v$database;
  2  select banner from v$version;
  3  select instance_name from v$instance;

SQL> 
SQL> 
SQL> hist 2 edit

Oracle SQL*Plus using vi editor for editing of history command line.



SQL> 
SQL> hist list
  1  select name from v$database;
  2  select banner from v$version;
  3  select instance_name from v$instance;
  4  select banner from v$version
     where rownum <=1;


SQL> hist 4 run 

BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> 
SQL> 
SQL> hist clear
SQL> 
SQL> set history off 
SQL> 
SQL> 
SQL> hist list
SP2-1650: History is off, use "SET HIST[ORY] ON" to enable History.
SQL>


Please watch for a video tutorial on Youtube:



Best Regards
Mahir M. Quluzade

Popular posts from this blog

Which device is mapped Oracle ASM disk?

Hi,

Yesterday Yuva Kishore is commented on my Oracleasm - Instantiating disk : failed post and asked a question: We can list the asm disks (listdisks) but where can we find the mapping that ASMDISK1 is mapped to /dev/sda1 and so on? 

I want answer this question with this post.

If you  are using ASMLib for configure ASM Disks, then you can use following steps for define which device mapped which ASM Disk.

As you  know, oracleasm listdisks is return only ASM disk names

[grid@oel62-rac1 ~]$ oracleasm listdisks ASMDISK01 ASMDISK02 ASMDISK03 ASMDISK04 ASMDISK05 [grid@oel62-rac1 ~]$
If you want find which ASM disk is mapped which device, then you must use oracleasm querydisk with ASM disk name.

[grid@oel62-rac1 ~]$ oracleasm querydisk -d ASMDISK01 Disk "ASMDISK01"  Is a valid ASM disk On device[8,17]
As see you, ASMDISK01 is valid ASM disk on device [8,17].

What is means?

It means ASMDISK01 is mapped to device [8,17].

How to find [8,17] device?

 We must use Linux ls –l  c…
Read more

Oracle Data Guard 11g - How to safely remove a Data Guard Broker configuration?

Image
When you need safely remove broker-managed Data Guard Configuration then, oracle recommend following steps…

You know dg_broker_start parameter is TRUE and data guard configuration information contains in broker configuration files dg_broker_config_file1, dg_broker_config_file2 with broker-managed Data Guard Configuration.

Following steps I use on my test machines witch is running on Oracle Virtual Box. I captures video on this machines, too. Primary and Standby Database running on Oracle Linux Server 6.2 and installed Oracle Database 11g Release 2 (11.2.0.3).

DG – is my breoker-managed Data Guard configuration. admdb is primary database, stldb – is standby database.

DGMGRL> show configuration Configuration - dg Protection Mode: MaxPerformance Databases: admdb - Primary database stldb - Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS
Archive log destinations like as

SQL> show parameter log_archive_dest_ NAME …
Read more

Oracle Database 12c Release 2 - Long Identifiers

Image
Prior to Oracle Database 12c Release 2 have a problem with long identifier name, for example, in 11.2 version you cannot create long name (max 30 Bytes) tables.  As you see, from screenshots length of table name column is maximum 30.



In Oracle Database 12c Release 2 changed the length of identifier names, and this change depends on the COMPATIBLE initialization parameter. Documentation says:

If COMPATIBLE is set to a value of 12.2 or higher, then names must be from 1 to 128 bytes long with these exceptions: Names of databases are limited to 8 bytes. Names of disk groups, pluggable databases (PDBs), rollback segments, tablespaces, and tablespace sets are limited to 30 bytes. If an identifier includes multiple parts separated by periods, then each attribute can be up to 128 bytes long. Each period separator, as well as any surrounding double quotation marks, counts as one byte. For example, suppose you identify a column like this: "schema"."table"."column" …
Read more