Loading
Nipun Tomar's contributions
Sub Query in Oracle: Part 1
In this article, I share the use of a Sub Query. If a Query that contains another Query, then the Query inside the main Query is called a Sub Query and the main Query is known as the parent Query.
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.
COALESCE in Oracle 11g
COALESCE function is most similar to CASE expression as we define the cases while using CASE expression
Error: ORA-00942: table or view does not exist
The above error commonly occurs while executing any SQL statement on database.
Oracle SQL Commands: Part 4
In this article you will learn about various alter and drop commands in Oracle.
Oracle SQL Commands : Part 3
In Oracle we can create our own procedure. A procedure is a collection of SQL statement that can be called by any valid object name and create a user-defined procedure we use the command create Procedure.
How to DROP columns from an existing table in oracle
In Oracle, the possibility to drop a column/columns in an existing table can be available only after the origin of oracle 8i.
Synonym types in oracle
In English language usually we heard about synonym which means the other name of a word, similarly synonym in oracle made the possibility to shorten the object names which are very much complex.
Oracle SQL Commands: Part 2
In this article you will learn about various create trigger commands in SQL Server.
Oracle SQL Commands: Part 1
While using SQL there are some queries we can use on a frequent basis, since these queries play a vital role in storing the data into the database.
Constraints in Oracle : Part 1
This article explains the Constraint clause in Oracle that is basically used to apply the specific rules to the data that restrict the values/data entered into the database columns.
Transactions in Oracle Database
Let us understand how the user queries are handled at the oracle Database, what are all the processes involved in it.
Code Security in .NET
The word itself describes that here we are going to briefly discuss about the security of code.
Methods of Session Maintenance in ASP.NET
In ASP.NET there are 3 types of methods for session maintenance.
Oracle Process Structure : Part 1
Recently I read about the Process of Oracle and want to share my knowledge of it with you all.
Oracle Process Structure : Part 2
In this article you will learn about various types of processes in Oracle.
Startup of Database in Oracle 11g
Considering that you have installed the oracle for the first time and is about to start the database instance.
Architecture of Oracle 11g: Part 1
Today, we will explain the Oracle 11g architecture. It is basically divided into the three major parts, Memory Structure, Logical Database Structure and Physical Structure
Architecture of Oracle 11g (Part 2)
In continuation of my previous article, here we will go through the second part of the memory structure of the Oracle architecture which is known as PGA (Program Global Area)
Text to Speech With Highlight Text Support in WPF
In this article you will learn how to highlight TEXT while text is being read in WPF.
