ORACLE 18C

Display sql_id of the sql, using set feedback in oracle 18C – New feature

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 .    […]

oraversion utility in oracle 18c – New feature

A new utility oraversion has been introduced in Oracle 18c, Which provides Oracle database version/release related information.   HELP:

For displaying specific information.

SET ROWLIMIT in oracle 18C – New feature

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 […]

SETUP ORACLE 18C DATABASE – STEP BY STEP

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 […]

Skip to toolbar