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