Search results
Monday, July 5, 2021
PL/SQL procedure to Drop all the objects from the oracle user
Procedure to drop the objects from a Oracle Schema : Below is the pl/sql procedure to drop the user objects using condition. Use it with E...
Read post →
Saturday, November 23, 2019
Steps to create a database using windows cmd prompt:
Steps to create a database using windows cmd prompt: Pre-requisite: 1. Oracle Database must be installed: 2. Basic knowledge of script and d...
Read post →
Thursday, May 17, 2018
Linux script file to create database in Oracle
To create oracle database, user and tablespace in linux, use the below script file. Please go through the script file carefullly before exec...
Read post →
Wednesday, May 16, 2018
DELETE RECORDS USING BULK COLLECT - ORACLE
Below is the procedure to delete records from table1 using bulk collect method. In the below example the limit is specified as 100, 000 reco...
Read post →