Oracle Blogs

Post

Oracle

Welcome to oracle section of C# Corner. In this section, you will find oracle related source code samples, articles, tutorials, and tips.

Blogs

Architecture of Oracle APEX

The architecture of Oracle Application Express (APEX) involves multiple layers and components working together to enable the development and deployment of web applications.
Krishnaveni Shanmugabalu May 17, 2023
Significance of (+) in Oracle Joins

SIGNIFICANCE OF (+) symbol in the join in Oracle SQL
Krishnaveni Shanmugabalu May 11, 2023
Best Practices For Working With Date/Time Data In Oracle SQL

By following these best practices and utilizing the various date and time functions in Oracle SQL, you can effectively work with and manipulate date/time data in your queries.
Krishnaveni Shanmugabalu Apr 12, 2023
Create Table Structure From Existing Table In Oracle SQL

In this blog, you will learn how to create Table Structure from Existing Table in Oracle SQL.
Arvind Yadav Feb 21, 2023
Create Index In Oracle

In this blog, you will learn how to create an index in oracle.
Arvind Yadav Feb 21, 2023
Function to Return Number Of Specified Days Between Two Dates

In this post, we are using SQL to create a function that will return the number of specified days between two dates.
Pooja Sep 25, 2020
Packages In Oracle

In this blog, you will learn about packages in Oracle.
Akshay Phadke Aug 08, 2016
Batch File For Taking Cold Backup And Expdp

In this blog, you will learn about batch file for taking Cold Backup and Expdp.
Akshay Phadke Aug 08, 2016
Enable Case Insensitive String Comparison In Oracle 12C

In this blog, we will look into doing character case insensitive string comparison in Oracle 12c.
Sateesh Arveti Jul 14, 2016
Oracle Query To Get Total Count of Pending Counts Department Wise And Drill Down Data In Oracle

In this blog, you will see the Oracle query to get the total count of pending counts department wise and drill down data In Oracle.
Akshay Phadke Jul 10, 2016
SQL Parsing In Oracle PL/SQL

This blog will help you to understand how can we parse SQL query in oracle PL/SQL
Pradeep Shet May 02, 2016
Oracle 11g r2 Installation Error in Windows

In this blog you will learn about oracle 11g r2 Installation Error in Windows.
Akshay Phadke Apr 26, 2016
String Aggregation in Oracle

In this blog you will learn to String Aggregation in Oracle.
Ashraf Ansari Dec 22, 2014
Multiple Tables in Update Statement Oracle

In oracle, without using a cursor, by directly using the for loop it can be done for multiple records to update multiple tables.
Deepika Chaudhary Mar 12, 2014
Creating procedures in Oracle

Here, we are going to explain the way for creating the stored procedure:
Nipun Tomar Jan 15, 2014
Oracle Parameters For Procedures and Function

Generally when we execute any query or an argument the parameter acts as a placeholder for the values of a variable and return those values during the execution of stored procedure.
Nipun Tomar Jan 14, 2014
Creating Functions in Oracle

Here is a small description about creating and dropping functions in oracle.
Nipun Tomar Jan 14, 2014
How to use ORDER BY clause in SET operations

Here is a small description of how to use the ORDER BY clause in any of the SET operations.
Nipun Tomar Jan 02, 2014
GetDate(), DateDiff(), DateAdd(), DatePart() commands in Oracle

Below is the one by description of all the four date command with their syntax.
Nipun Tomar Nov 29, 2013
HOT and COLD Backups in Oracle

In Oracle, we basically use either Offline or Online backup. Here, although the words are different but the meaning is same our offline backup is called as COLD backup and online backup is known as...
Nipun Tomar Nov 12, 2013

Build Progressive Web Apps

Challenge yourself

Oracle Skill

E-Book Download

Get Certified

EF Core