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

Connect to Oracle Cloud Database using SQL Developer

By default, the Oracle DBaaS Cloud Service blocks access port 1521 used by tnsping. You have to open the port before you can connect using SQL Developer or Connecting to another instance via sqlplus. Log in to the Oracle Database Cloud Service and click on the service name which you already created. Note down the […]

Read More