LATEST ARTICLE TAGGED ON "DATABASE DESIGN"

Indexes in SQL Server

Indexes are used in relational databases to quickly retrieve the data .It is similar to indexes at the front of the books whose purpose is to find a topic quickly.

SQL KEYS IN RDBMS

In this article, I want to explain about SQL Keys such as PRIMARY KEY, FOREIGN KEY, COMPOSITE KEY, and UNIQUE KEY AND ALTERNATE KEY.

Working With BLOB(Binary Large Objects)

A BLOB is a build-in data type supported by the database implementing SQL 99 alias SQL3 Standards. A BLOB is used to store large binary data ,such as bit images,audios,and multimedia clips as the column value in a database table.

Using Cursor in CallableStatement

A cursor defines the runtime execution environment for query when the result of the query execution can be captured.

Callable Statement in Java

In Java, CallableStatement is used to call the stored procedures and functions by using an object of the CallableStatement Interface.

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!