A trigger is like a stored procedure that Oracle Database invokes automatically whenever a specified event occurs. Row level DML triggers are invoked for every row the specified DML statement touches (insert/update/delete). Since the database has to execute the trigger’s execution block in addition to the DML that invoked the trigger, by creating a trigger we… Continue reading
What is Procedure Procedure is a subprogram which is used to perform a specific action.
JDBC Statement, PreparedStatement and CallableStatement are interfaces which provide ways to interact with Databases(Oracle / MySQL / PostGre…etc) with the help of methods in it. But these statements have some difference in terms of features they provide.
Here we will learn about the UPDATE statement in Oracle. What is the use of it and syntax for the same.
Alter statement is the part of DDL (Data Definition Language). Which is used to change (Alter) the definition of a table.This tutorial is to provide details of Alter Statement in Oracle.
Here we will learn the difference between views created with “WITH CHECK OPTION” and “WITH READ ONLY“.
Oracle have different type of constraints. These constraints are like condition(rule)applied to column to maintain the integrity of Data.
Here we will learn about Insert statement in SQL(Structure Query Language).
The select statement comes under DQL(Data Query Language) statement. It is used to fetch data from Database. Data fetched from a table stored in result set. Now we will explore the different options available with select statements.
Here we will discuss the some key areas of Oracle which will be usefull for Java beginners(Not Oracle Expert). Oracle has Schemas which is nothing but User. Whenever a user has been created a new schema is also created. If it has grant of session then User can login to Oracle.Objects are also there in… Continue reading