Pavan DBA's Blog

The DBA Knowledge Store

«
»

12cR2 feature # 5 – HISTORY in sqlplus prompt

Posted by Pavan DBA on December 17, 2016


12cR2 has introduced new option HISTORY in sqlplus to view or edit or delete the sql, pl/sql commands we have executed in SQL prompt. This works just like “history” command in Unix prompt.

SQL> set history on –> enables the history

SQL> set history off –> disables the history

SQL> show history –> to check if history is ON or OFF

example:

SQL> set history ON

SQL> select count(*) from emp;

SQL> desc dept

SQL> select name from v$database;

SQL> history
1 select count(*) from emp;
2 desc dept
*  3 select name from v$database; (* represents last used command)

This entry was posted on December 17, 2016 at 12:25 PM and is filed under 12cR2 New features. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

3 Responses to “12cR2 feature # 5 – HISTORY in sqlplus prompt”

  1. oracle057 said

    February 2, 2017 at 12:32 PM

    Thanks for posting awesome information and very good points were stated in the blog

    http://erptree.com/course/oracle-fusion-hcm-online-training/

    Reply

  2. Bhanu said

    December 19, 2016 at 7:32 PM

    If we enable history ,how will be performance ?

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

«
»
 
%d bloggers like this: