Loading
Nipun Tomar's contributions
- Article · Oracle
Oracle Operators: Part 3
Let's continue with the third and the last part of Oracle Operators.
- Blog · Oracle
Creating procedures in Oracle
Here, we are going to explain the way for creating the stored procedure:
- Blog · Oracle
Creating Functions in Oracle
Here is a small description about creating and dropping functions in oracle.
- Blog · Oracle
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.
- Article · Oracle
Oracle Operators: Part 2
In this article we will learn how to use Set Operators in Oracle.
- Article · Oracle
Oracle Operators: Part 1
In Oracle, operators are used with the data items to perform the related actions and then return a result.
- Blog · Oracle
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.
- Article · Oracle
Exception Handling in Oracle
Generally, in PL/SQL while executing a program we might encounter an error. They can occurr during execution and are called an “EXCEPTION”. It will disrupt the normal flow of the program’s execution.
- Article · Oracle
Oracle Partitioning
In Oracle Partition is just like “Divide and conquer” approach, it is way or ability of database which allows a DBA to physically Split/ braked up all the very large tables, indexes and index organized tables in to smaller and manageable pieces/segments.
- Blog · Oracle
GetDate(), DateDiff(), DateAdd(), DatePart() commands in Oracle
Below is the one by description of all the four date command with their syntax.
- Article · Oracle
NTILE() Function in Oracle
In this article you will learn about the Oracle NTILE function.
- Article · Oracle
Reference Cursor in Oracle
In this article you will learn about Reference Cursors in Oracle.
- Article · Oracle
Oracle Golden Gate (GG)
Learn Oracle GoldenGate architecture and its core processes, including Manager, Extract, trails, Data Pump, Collector, and Replicat for real-time data replication.
- Article · Oracle
Cursors For Loop in Oracle
This article shows the use of Oracle cursors for loops with an appropriate example. The process of opening, fetching, and closing is handled implicitly by a cursors FOR LOOP. If there is a need to FETCH and PROCESS each and every record from a cursor, the cursor FOR LOOP is helpful for that.
- Article · Oracle
Cursors In Oracle
This article introduces the term Cursors in Oracle. Cursors are the temporary private working area where queries are processed. Implicit Cursors and Explicit Cursors are two types of Cursors.
- Article · Oracle
Joins in Oracle: Part 1
In Oracle, join is the most powerful operation which is used to merge the information from different tables based on the common field between them.
- Blog · Oracle
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 HOT backup.
- Article · Oracle
Oracle SQL Commands: Part 9
In this article you will learn about more Oracle commands.
- Article · Oracle
Oracle SQL Commands: Part 8
In this article you will learn about various Oracle commands.
- Blog · Oracle
DROP vs DELETE vs TRUNCATE in Oracle
Here is the difference between the commands that are used to remove the data from the database.
- Article · Oracle
Oracle SQL Commands: Part 7
In this article you will learn about various Oracle commands.
- Article · Oracle
Oracle SQL Commands: Part 6
In this article you will learn about various select commands in Oracle.
- Article · Oracle
Sub Query in Oracle: Part 2
This article explains the use of Sub Queries. Here we see examples of Multiple Row Sub Query, Multiple Column Sub Query, Nested Sub Query, Correlated Sub Query.
