Recent Articles

What is VPN?

What is VPN?

January 10, 2019 | By | Add a Comment

Article explains characteristics of VPN and definition of Virtual Private Network configuration. From a user perspective, each user is on the internal network. Each has access to all the resources available to someone who is physically connected to the local LAN. The speed or bandwidth is probably the only noticeable difference in a true VPN […]

Read More

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

Improve Oracle Database Performance using Data File Striping

Improve Oracle Database Performance using Data File Striping

January 10, 2019 | By | Add a Comment

While disk level striping really advantages many Oracle databases, Oracle databases necessitate striping at an additional granular level. Except we can streak in sizes of less than the cylinder size for the hard disk, the disk will have the hunt for disputation as the read-write head shifts among the cylinders.  In a perfect world, we […]

Read More

You should maintain your sql statement identical

You should maintain your sql statement identical

January 3, 2019 | By

I am starting this new section called SQL tutorial. This section doesn’t contain only basic SQL statement written learning but it also contains some guidance and advice from my experience. SQL is called as sequel sometimes. Don’t bother! Always use SQL writing pattern identical. It means you need to use your writing style pattern unique […]

Read More

SQL Tutorials with smart way

SQL Tutorials with smart way

January 3, 2019 | By | Add a Comment

This section is very useful to all kinds of the developer, programmer, and DBA. Because this is special guidance and tips about SQL tutorials and learning using smart way. You can write SQL statements and queries without any mistakes. I am providing you some best tips and help to avoid some silly mistakes. I saw […]

Read More

Portability In Oracle Dba

Portability In Oracle Dba

December 25, 2018 | By | Add a Comment

Oracle data base administrator first introduced Procedural Language or Structured Query Language (PL or SQL) in version 6.0 of its relational DBA management system (RDBMS). As its RDBMS evolved, Oracle DBA made developmental changes to the PL or SQL language by introducing new features and enhancing existing features. As of Oracle data base administrator9i, the […]

Read More