In oracle 18c, 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: 0ata065ztg2u0 – > This is the sql_id of the query . […]
A new utility oraversion has been introduced in Oracle 18c, Which provides Oracle database version/release related information. 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.
For displaying specific information.
$ oraversion -compositeVersion
$ oraversion -baseVersion
$ oraversion -majorVersion
$ oraversion -buildStamp
$ oraversion -buildDescription
In earlier version we have used row_num filter in where clause to limit the number of rows getting fetched. In oracle 18c, the new command, SET ROWLIMIT command enables users to set a limit for the number of rows displayed for a query. By default it is set to OFF. — For limiting number or […]
Recently Oracle has released its Oracle 18c in premise version.(previously it was only for oracle cloud). This release has lot of new features, which need to to be explored. So let’s start with Oracle binary installation and database creation. Download the Oracle software from oracle website.(DOWNLOAD LINK) Copy the software to your server and unzip […]