Create procedure in Oracle
Procedure is used to execute the block of SQL statements multiple times in the database server. It works similar to the function or procedure of…
Create View in Oracle
View is a virtual table that is created from an existing database table. The way of creating, updating, and deleting view has been shown in…
Create auto-increment or auto-generated field in Oracle
The auto-increment attribute is used in the primary key field of the database table to increment the field automatically when any new record is inserted…
Third Normal Form (3NF) in Oracle
The concept of the third normal form (2NF) has been explained in this tutorial by using the Oracle database tables. Run the SQL Developer application…
Second Normal Form (2NF) in Oracle
The concept of the second normal form (2NF) has been explained in this tutorial by using the Oracle database tables. Run the SQL Developer application…
First Normal Form (1NF) in Oracle
The concept of the first normal form (1NF) has been explained in this tutorial by creating the tables in the Oracle database. Run the SQL…
How to send email using Gmail account
It is a common requirement to send email using any scripting language for the web application. The SMTP server of the Gmail account is commonly…
Java Inheritance Examples
Inheritance is a very important feature of object oriented programming. The way of creating single and multi-level inheritance has been shown in this tutorial. Example-1:…
Java Constructor Examples
Different types of constructors can be defined in Java to do the initialization tasks. The way of defining parameterless constructor, parameterized constructor, and copy constructor…
Use of String in Java
Many built-in string functions exist in Java to perform different types of tasks. The uses of some commonly used string functions and the purpose of…