You can perform a direct upgrade to the new release from the following releases: 11.2.0.3 and 11.2.0.4 12.1.0.1 and 12.1.0.2 12.2.0.1 The path that you must take to upgrade to the latest Oracle Database release depends on the release number of your current database. If your current Oracle Database is a release earlier than 11.2.0.3, […]
Category: Oracle 18c
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 […]
First login to Oracle 18c
Database administrators have specific responsibilities and must understand how to complete database administration tasks. To get started with database administration, you must understand basic database concepts, such as the types of database users, database security, and privileges. You must also be able to complete basic tasks, such as submitting commands and SQL to the database and […]
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 […]
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 Example To set the […]