This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

SQL

SQL Interview Questions and Answers – Part 1

By | August 30th, 2013|Database, SQL|

1). What is RDBMS ? Relational Data Base Management Systems (RDBMS) are database management systems that maintain data records and indices in tables. Relationships may be created and maintained across and among the data and tables. In a relational database, relationships between data items are expressed by means of tables. Interdependencies among these tables are [...]

Difference Between Groupby and Having Clause

By | July 19th, 2013|Database, SQL|

The GROUP BY Statement The GROUP BY statement is used in conjunction with the aggregate functions to group the result-set by one or more columns. SQL GROUP BY Syntax SELECT column_name, aggregate_function(column_name) FROM table_name WHERE column_name operator value GROUP BY column_name   SQL GROUP BY Example We have the following "Orders" table: O_Id OrderDate OrderPrice [...]

SQL Interview Questions and Answers

By | May 24th, 2013|Database, SQL|

What are two methods of retrieving SQL? What cursor type do you use to retrieve multiple recordsets? What is the difference between a "where" clause and a "having" clause? - "Where" is a kind of restiriction statement. You use where clause to restrict all the data from DB.Where clause is using before result retrieving. But [...]

Conditional Selections and Operators

By | July 30th, 2011|Database, SQL|

We have two clauses used in this Where Order by USING WHERE Syntax: select * from <table_name> where <condition>; the following are the different types of operators used in where clause. v      Arithmetic operators v      Comparison operators v      Logical operators v      Arithmetic operators          -- highest precedence +, -, *, / v      Comparison operators =, !=, [...]

Oracle Database Triggers

By | July 26th, 2011|Database, SQL|

Triggers are similar to procedures or functions in that they are named PL/SQL blocks with declarative, executable, and exception handling sections. A trigger is executed implicitly whenever the triggering event happens. The act of executing a trigger is known as firing the trigger. RESTRICTIONS ON TRIGGERES Like packages, triggers must be stored as stand-alone objects [...]

SQL – Introduction

By | July 20th, 2011|Database, SQL|

SQL is divided into the following Data Definition Language (DDL) Data Manipulation Language (DML) Data Retrieval Language (DRL) Transaction Control Language (TCL) Data Control Language (DCL) DDL -- create, alter, drop, truncate, rename DML -- insert, update, delete DRL -- select TCL -- commit, rollback, savepoint DCL -- grant, revoke CREATE TABLE SYNTAX Create table [...]

Check List For Oracle SQL

By | May 30th, 2011|Database, SQL|

  The following is a list of points which can be used as guideline to write and review custom SQL queries.   This is by no means an exhaustive list to get the best tuning results but can serve as a ready reference to avoid the common pitfalls. 1. Do not use the set operator [...]

SQL – Joins

By | May 4th, 2011|Database, SQL|

Joins: An SQL JOIN clause combines records from two or more tables in a database. It creates a set that can be saved as a table or used as is. A JOIN is a means for combining fields from two tables by using values common to each. SQL has four types of JOINs: INNER, OUTER, [...]