Friday, September 11, 2020

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 

No comments:

Post a Comment

ITIL Process

ITIL Process Introduction In this Blog i am going to explain  ITIL Process, ITIL stands for Information Technology Infrastructure Library ...