cursor in sql

cursor in sql-: Cursor are used to process a collection of row computed by an embedded sql statement in host language programme.It can be thought of as a pointer that point to a single row from the result of a query that...

Continue reading

triggers in sql

Triggers In SQL-:  Triggers are the part of sql. Active database is a database which provide facility for specifying for active rules.These rules can be automatically triggered by events that occur on database and initiate...

Continue reading

open database connectivity

Open Database Connectivity-: Open Database Connectivity (ODBC)is a widely accepted application programming interface for database access. ODBC is designed for maximum interoperability as like the ability of a single application...

Continue reading

object oriented database management system

Object Oriented Database Management System(OODBMS)-: In recent years, several database applications have emerged whose complexities is not well handled by the relational database system as relational database system supports a...

Continue reading

limitation of rdbms

limitation of rdbms-:We can easily see that in the changing scenario of web, advance and complex applications requirements are not easily satisfied by traditional RDBMS.  Following are the limitations of RDBMS due to which it is...

Continue reading

Structured Data Types in dbms

Structured Data Types -: A structured data type is a user defined data type with elements that are not atomic rather they are divisible and can be used either separately or as a single unit as per requirements. It is a form of...

Continue reading

Object database system

Introduction -:In recent years, several database applications have emerged whose complexities is not well handled by the relational database system as relational database system supports a fixed set of data type which is...

Continue reading

transaction control language in sql

Transaction Control Language (TCL)-: TCL is the part of structure query language.It managed transaction in database.Understanding TCL we Divided TCL in some like A. Database Transaction:-The server ensures data consistency based...

Continue reading

Data Manipulation Language in sql

Data Manipulation Language (DML)-:Data Manipulation Language (DML) is a core part of SQL. When we want to add, update or delete data in the database, we execute a DML statement. A collection of DML statements that form a logical...

Continue reading