Category Archives: Oracle

All notes on Oracle..

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 »

Setting up SQL Developer to use

In this post we will see that how to setup SQL Developer for the first time. The time we install Oracle,  SQL Developer is already installed along with it. I am installing Oracle on my machine. Just to demonstrate how initially SQL Developer respond . Once Oracle is installed on your machine , go to […]
Read More »

Upgrading Oracle APEX to Oracle Application Express Release 5.0.1

A short introduction on Oracle Apex: Oracle Application Express is mainly used to develop Web based applications with SQL and PL/SQL. The Web-based applications can be developed using a web browser which can easily be deployed for any desktop or mobile applications. There are various version that are been released by Oracle. In recent release […]
Read More »

Installing Linux Mint OS on Oracle Virtual Box

The purpose of this article is to show how we can create Linux Mint virtual machine using Oracle Virtual Box. To install Linux Mint we have to download the ISO file from its website i.e. http://www.linuxmint.com. Once you open the link you will see a download option at the right side of the page, go […]
Read More »

Flashback queries in Oracle

Reference taken from one of my article that was published on Experts-Exchange . With the help of flashback queries we have the option to look back in time to a certain state of a database, for example say we did some operation yesterday at 10 AM and today we want to go back to the […]
Read More »