Oracle 18c New Features

 Oracle 18c New Features

Introduction

In this blog i am going to explain three new Oracle 18c New Features which is useful for oracle database administrators 

SET ROWLIMIT 

ORAVERSION UTILITY

SET FEEDBACK OPTION

SET ROWLIMIT command enables users to set a limit for the number of rows displayed for a query.

for limiting number  of rows to 5 in Oracle 18c New Features

SQL> set rowlimit 5

SQL> select username from dba_users;

USERNAME

—————————

SYS

SYSTEM

ABHIRAM

CHAITANYA

MANASA

5 rows selected. (rowlimit reached)

for limiting number  of rows to 3

SQL> set rowlimit 3

SQL> select username from dba_users;

USERNAME

————————

SYS

SYSTEM

CHAITANYA

3 rows selected. (rowlimit reached)

Oraversion Utility in Oracle 18c New Features

A new utility Oraversion has been introduced in Oracle 18c New Features Which provides Oracle database version/release related information.

oraversion -help

This program prints release version information.

These are its possible arguments:

-compositeVersion: Print the full version number: a.b.c.d.e.

-baseVersion: Print the base version number: a.0.0.0.0.

-majorVersion: Print the major version number: a.

-buildStamp: Print the date/time associated with the build.

-buildDescription: Print a description of the build.

-help: Print this message.

$ oraversion -compositeVersion

18.3.0.0.0

 

$ oraversion -baseVersion

18.0.0.0.0

 

$ oraversion -majorVersion

18

 

$ oraversion -buildStamp

180628094320

 

$ oraversion -buildDescription

Release_Update

In Oracle 18c New Features, we can display the sql_id of the sql queries we are running using set feedback option.

By default it will be OFF.

SQL> set feedback ON SQL_ID

SQL> select name from v$database;

NAME

———

ORA18C

1 row selected.

SQL_ID: 0btb065ytg2v0 –  > This is the sql_id of the query . 

Note : Info on  Oracle 18c New Features it maybe differ in your environment like production,testing,development etc and naming conventions

THANKS FOR VIEWING MY BLOG FOR MORE UPDATES FOLLOW ME OR SUBSCRIBE ME