Shulou(Shulou.com)05/31 Report--

This article mainly explains "what are the new features of Oracle 12C". The content of the explanation is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "what are the new features of Oracle 12C".

In 12c, the History command is introduced, similar to the history command in Shell

The syntax is as follows:

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.

The process is as follows:

[oracle@cjcos ~] $sqlplus / as sysdba

SQL > hist

SP2-1650: History is off, use "SET HIST [ORY] ON" to enable History.

SQL > set hist on

SQL > show pdbs

SQL > select * from v$version

SQL > select tablespace_name from dba_tablespaces

SQL > alter session set container=cjcpdb01

SQL > select * from tab

SQL > hist

1 show pdbs

2 select * from v$version

3 select tablespace_name from dba_tablespaces

4 alter session set container=cjcpdb01

5 select * from tab

-re-implement Article 2

SQL > hist 2 run

-Edit the second article

SQL > hist 2 edit

Thank you for your reading, the above is the content of "what are the new features of Oracle 12C". After the study of this article, I believe you have a deeper understanding of what the new features of Oracle 12C are, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.