Category Archives: Oracle

All notes on Oracle..

Getting monthly data with latest records in oracle

In this blog I am going to show how we can get monthly data for a given set of records. In many cases we try to get the data into reports with monthly , weekly etc. To achive this we can use N number of tools which are provided but sometime we have to write […]
Read More »

SQL Error: ORA-00921 in Oracle 12c

How to solve if you get SQL error “ORA-00921” while dropping an existing user in Oracle 12c. I got one user existing on my database called “SLOBA”. Now let us try to drop it.   Output as error:   Now alter the system session “_oracle_script” to true. Output : Now let us try to drop […]
Read More »

Using SQL Scripts in Oracle Application Express

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express. How it can be really helpful to use SQL scripts under SQL Workshop?Let us take an example […]
Read More »

Solve Error: ORA-65096 in 12c

In 12c database when we try to create any user we commonly see the error “Error: ORA-65096” . We can solve this problem by setting up the undocumented hidden parameter i.e. “_ORACLE_SCRIPT” to true.  In other way we have to user the prefix by adding “C##” or “c##” before the username in container database but […]
Read More »

Introduction to SQL Command Tool in Oracle APEX

Introduction: SQL Command Tool comes with APEX under SQL Workshop. It helps us to make changes on the database directly using a graphical user interface. This helps us writing any SQL/ PLSQL queries and execute it on the database and we can create any database objects which can later be used in our application. The […]
Read More »

Introduction to Oracle APEX SQL Workshop- The object browser

Summary APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.   In this blog I am going to show how we can use and utilize […]
Read More »

Composite Queries in Oracle

Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​ What are composite queries in Oracle ?When multiple queries are joined together using any set operators within SQL then they are called […]
Read More »

Meta Characters in Oracle

Meta characters are the characters in a programming language that are interpreted by the programming language to have specific meanings within the language itself. Meta characters are normally simple characters. For example we can take HTML or XML where we use less than or greater than symbols i.e. ” < ” and ” > “. […]
Read More »

SFTP from PLSQL

In this blog I am going to use a simple program to SFTP files from my database server to any target machine using SFTP. To demonstrate this I am using two servers one where I have Oracle installed and another server where SFTP is enabled. SFTP basically means a protocol in which we can move […]
Read More »

Executing Linux command from Oracle PLSQL

In this blog we are going to get an idea on how we can execute OS commands from PLSQL code. In many cases we get some requirements like to run or use some basic OS commands which can later be used in our business logic. To start with we have to created a “C” program […]
Read More »