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

Blogs

  • Akshay Phadke

    Packages In Oracle

    In this blog, you will learn about packages in Oracle.
    Akshay Phadke Aug 08, 2016
  • Akshay Phadke

    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
  • Sateesh Arveti

    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
  • Akshay Phadke

    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
  • Pradeep Shet

    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
  • Akshay Phadke

    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
  • Ashraf Ansari

    String Aggregation in Oracle

    In this blog you will learn to String Aggregation in Oracle.
    Ashraf Ansari Dec 22, 2014
  • Deepika Chaudhary

    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
  • Nipun Tomar

    Creating procedures in Oracle

    Here, we are going to explain the way for creating the stored procedure:
    Nipun Tomar Jan 15, 2014
  • Nipun Tomar

    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
  • Nipun Tomar

    Creating Functions in Oracle

    Here is a small description about creating and dropping functions in oracle.
    Nipun Tomar Jan 14, 2014
  • Nipun Tomar

    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
  • Nipun Tomar

    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
  • Nipun Tomar

    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
  • Nipun Tomar

    DROP vs DELETE vs TRUNCATE in Oracle

    Here is the difference between the commands that are used to remove the data from the database.
    Nipun Tomar Nov 07, 2013
  • Nipun Tomar

    Difference Between Rollback and Commit in Oracle

    As both ROLLBACK and COMMIT Commands are TCC (Transaction Control Commands), but are not similar to each other.
    Nipun Tomar Nov 01, 2013
  • Nipun Tomar

    ORACLE_HOME and ORACLE_BASE

    Here is the difference between the ORACLE_HOME and ORACLE_BASE.
    Nipun Tomar Oct 31, 2013
  • Nipun Tomar

    Error: ORA-00942: table or view does not exist

    The above error commonly occurs while executing any SQL statement on database.
    Nipun Tomar Oct 31, 2013
  • Nipun Tomar

    COALESCE in Oracle 11g

    COALESCE function is most similar to CASE expression as we define the cases while using CASE expression
    Nipun Tomar Oct 31, 2013