Oracle SQLcl (Oracle SQL Developer Command Line) is a command line tool for Oracle Database. SQLcl has some nice features in comparison ...

In this post, I am sharing 5 SQL queries which are most needed by the Oracle developers, especially when we have ...

In Toad for Oracle, use Auto Replace option to create autocomplete shortcuts for most frequently used Oracle commands such as SELECT ...

Below is the step by step guide to how to schedule a job in Oracle SQL Developer. Steps to Schedule a ...

In this tutorial, you will learn how to create the procedure for DML statements in Toad for Oracle. Toad has an ...

Here I am giving an example of PL/SQL stored function to validate the Credit Card number and identify its type, whether ...

Here I am giving an example to validate email address using PL/SQL regular expressions (REGEXP) in Oracle. Validate Email Using PL/SQL ...

In this tutorial, I am giving an example to how to set SQL prompt in the [email protected]> format in Oracle. Set ...

In Oracle, TRUNCATE command is a DDL statement, so you can not execute it directly in Oracle Procedure. To execute DDL ...

In this tutorial, you will learn how to run Oracle SQL Script (SQL*PLUS) from the command line in Windows. Make sure ...

Here I am giving some examples of SQL*PLUS scripts in Oracle. By using SQL scripts you can do almost anything in ...

In this blog post, I am sharing a function with which you can check if a file is an image file ...

Here I am giving an example to save BLOB data as a file in PL/SQL. BLOB data you can get it ...

Below I am giving a function example to get the BLOB from a file in PL/SQL. PL/SQL Function to Get BLOB ...

In Toad, you can export the data to an Excel file and into an Excel instance. In Excel instance, it opens ...

In this tutorial, you will learn how to take backup of Oracle Database using Toad. Toad uses Oracle’s Export utility (Exp.exe) ...

In Toad for Oracle, follow these steps to generate insert statements script. Steps to Generate Insert Statements Script in Toad for ...

In this tutorial, I am giving an example to export query result to an Excel file in Oracle SQL Developer. The ...

In Toad, use EDIT command to edit the data in Data Grid window. The syntax of the command is same for ...

In this tutorial, you will learn how to fetch data from Oracle database in C# (C-Sharp). The following are the software ...