by admin | Jun 16, 2015 | sem3
Embedded SQL Embedded SQL is a methodology of inserting inline SQL statements or queries into the source of a programming language, which is called as a host language. Because the host language can’t parse SQL, the inserted SQL is parsed by an embedded SQL...
by admin | Jun 16, 2015 | sem3
Database Objects A database objects in a relational database is a data structure used to either save or reference data. The most basic object that people interact with is the table. Other objects are indexes, stored procedures, sequences, views and many other. When a...
by admin | Jun 16, 2015 | sem3
SQL Data types SQL data type is an attribute that specifies type of data of any object. Each column, variable and expression has related data type in SQL. You would use these data types while creating your tables. You would choose a particular data type for a table...
by admin | Jun 16, 2015 | sem3
DDL DML DCL TCL DDL : DDL is abbreviation of data Definition Language. it’s used to create and modify the structure of database objects in database. SELECT – retrieve data from the a database INSERT – insert data into a table UPDATE – updates...
by admin | Jun 16, 2015 | sem3
SQL standard SQL standard could be a language for accessing and manipulating databases. What is SQL? SQL stands for Structured query language SQL enables you to access and manipulate databases SQL is associate ANSI (American National Standards Institute) standard What...
by admin | Jun 16, 2015 | sem3
XML Database An XML database may be a information persistence package that enables information to be such as, and typically hold on, in XML format. These information will then be queried, reworked, exported and came back to a calling system. XML databases are a flavor...
