What is Procedure

Procedure is a subprogram which is used to perform a specific action.

Here we will learn to connect to MYSQL DB via Java.

JDBC Statement, PreparedStatement and CallableStatement are interfaces which provides the ways to interact with the Databases(Oracle / MySQL / PostGre…etc) with the help of methods in it. But these statements have some difference in it.

Introduction

DELETE statement is used to delete one or more record from DB table.

Here we will learn about the UPDATE statement in Oracle. What is the use of it and syntax for the same.

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.

Function in Oracle

Oracle function are programme which takes some input perform some operation and provide outputs. Note function has to give some output while there is no restriction procedure for the same. Procedure may or may not provide return type.

Here we will learn about Insert statement in SQL(Structure Query Language).