Installing Oracle 18c Binary on OEL 6.3

In this post, we are installing Oracle 18c binaries on OEL 6.3. First, we need to download the software and start runInstaller from software location. Select a “Set Up Software Only” and click next. Select on “Single instance database Installation” and click on next. Select on “Enterprise Edition” and click on next Put the Oracle […]

Read More

Display the sql_id for a query in Oracle 18c

The SET FEEDBACK command has an SQL_ID option to display the sql_id for the currently executed SQL or PL/SQL statements. The sql_id will be assigned to the predefined variable SQL_ID. Displays the number of records returned by a script when a script selects at least n records. SQL_ID returns the sql_id for the SQL or PL/SQL […]

Read More

SET LINESIZE window in Oracle 18c

Sets the total number of characters that SQL*Plus displays on one line before beginning a new line. WINDOW adjusts the linesize and pagesize for the formatted output according to the width and height of the screen. If the output is longer than the screen width, then the output is wrapped accordingly

To dynamically change […]

Read More