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 – PLSQL

/Tag:SQL - PLSQL

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 [...]