Category: sql

Assertions and Deferability of Constraints

Assertions and Deferability of Constraints

January 10, 2019 | By | Add a Comment

Constraints are rules that you establish to restrict the values that can be placed in your columns. In basic SQL, constraints are contained in the definitions of base tables and are of two kinds: column constraints and table constraints. The former is part of a column definition and check their rules whenever a statement attempts […]

Read More

select for update

select for update

August 30, 2011 | By | Add a Comment

select for update in Oracle

Read More

Oracle VMWARE – Oracle VM

Oracle VMWARE – Oracle VM

December 22, 2010 | By | 1 Comment

Hi Friends, Today we are going to know about Oracle VM. This software called as so many others name like Oracle Virtualbox, Oracle VMWARE, Oracle Virtualization etc. This is the best thing to learn or know something different than our actual routine work of database administration. We should at least know that what are the […]

Read More

DB2 and Oracle Server Comparison

DB2 and Oracle Server Comparison

December 9, 2010 | By | Add a Comment

Hi friends, Two biggest RDBMS from brand leaders. DB2 is product of IBM and Oracle Database server is from Oracle. How to make compare both because both found equally in most of features. Yes. But we found some difference between DB2 and Oracle Server. Wonderful article has bee published on our site. It is very […]

Read More

SQL Server 2008 and Server 2008 r2 features

SQL Server 2008 and Server 2008 r2 features

December 8, 2010 | By | Add a Comment

Hi Friends, A new article has been published for SQL Server 2008 version features and Server 2008 r2 version features. There are lot of new features introduced in server 2008. Performance of server 2008, memory management of ms sql, data mining feature, new data compression and query features are covering in sql server 2008 and […]

Read More

What is SQL and what are SQL versions

What is SQL and what are SQL versions

December 4, 2010 | By | Add a Comment

Hi Friends, Today we are discussing different topic called what is SQL and what are the SQL versions. If this questions is being asked to any DBA or Developer then can anybody will be able to answer? Due to this reason, We are publishing the article to explain everything of SQL. From the start to […]

Read More