Create Database on Oracle Cloud

We will show you how to create database on oracl cloud database. Log into your Oracle Cloud Services account Go to the “Oracle Database Cloud Service” and create a new service Select “Oracle Database Cloud Service” as the type of subscription from the Dropdown Select the SSH Public Key as shown in the attached figure […]

Read More

How to make a table read only in Oracle

Oracle 11g allows tables to be marked as read-only using the ALTER TABLE command.

Let’s create a table and make it read-only.

Any DML statements that affect the table data results in an ORA-12081 error message.

DML and DDL operations return to normal once the table is switched back to read-write mode. […]

Read More

VARIABLE In Oracle 12.2

    You may use SQL*Plus to test queries with bind variables. Here is what you do before 12.2:

You can now simply:

Read More