Showing posts from April 8, 2008

INDEXES

INDEXES Indexing a table is an ‘access strategy’, that is, a way to sort and search records in the table. Indexes are essent…

SEQUENCE

SEQUENCE A sequence is a database object used to generate sequence numbers for rows in the tables. It can be used for produc…

VIEWS

VIEWS To reduce redundant data to the minimum possible, Oracles allows the creation of an object called a view. A view is ma…

SUBQUERIES

SUBQUERIES A Sub Query is a form of an SQL statement that appears inside another SQL statement. It is also termed as NESTED …

JOINS

JOINS Sometimes we require treating multiple tables as though they were a single entity. Then a single SQL sentence can mani…

ORACLE FUNCTIONS

ORACLE FUNCTIONS Oracle functions serve the purpose of manipulating data items and returning a result. Functions are also ca…

DUAL TABLE

DUAL TABLE Dual is a small Oracle worktable, which consists of only one row and one column, and contains the value X in that…

ARITHMETIC OPERATORS

ARITHMETIC OPERATORS Oracle allows arithmetic operators to be used while viewing records from the table or while performing …

CONSTRAINTS

CONSTRAINTS The oracle server uses constraints to prevent invalid data entry into tables. Constraints prevent the deletion o…

DELETE OPERATIONS used in SQL

DELETE OPERATIONS The verb DELETE in SQL is used to remove rows from table. To remove All the rows from a table. Or …

COMMANDS USED IN A TABLE

COMMANDS USED IN A TABLE:- CREATE TABLE COMMAND The CREATE TABLE command includes a single clause for the column definition.…

Categories of SQL statements

Categories of SQL statements:- SQL is a simple and powerful language used to create, access, and manipulate data and structu…

DATA TYPES THAT A CELL CAN HOLD

DATA TYPES THAT A CELL CAN HOLD Data Types:- CHAR (Size):- This data type is used to store character strings values of fixed…

STRUCTURED QUERY LANGUAGE

SQL (STRUCTURED QUERY LANGUAGE) SQL is an ANSI (American National Standards Institution) standard for accessing database sys…

Addition of polynomials

// Addition of polynomials // #include #include #define NULL 0 struct list { int coeff ; int power ; struct list *next; }; t…

Binary search

// Binary search // #include #include #define NULL 0 struct rec { int num; struct rec *left; struct rec *right; }; typedef s…

To implement stacks using array

//To implement stacks using array// #include "iostream.h" #include"conio.h" #include"ctype.h" …

Program of tower of Hanoi

// Program of tower of Hanoi // #include"iostream.h" #include"conio.h" int main() { int n; char beg=…

Implementing queue with arrays

//Implementing queue with arrays// #include"iostream.h" #include"conio.h" #define NIL -1 #define MAX 10 …

Circular linked list

// Circular linked list // #include #include #define NULL 0 struct list { int data; struct list *next; }; typedef struct lis…

Merge sort

// Merge sort // #include #include #define SIZE 10 class int_list { private: int arr[SIZE]; int no; public: int_list() { no=…

Quick sort

// Quick sort // #include #include #define SIZE 10 int main() { void quick(int [],int,int,int); clrscr(); int i,n,arr[SIZE];…

Heap sort

// Heap sort // #include"iostream.h' #include"conio.h" #define SIZE 30 int main() { int a[SIZE],heap[SIZE…

Implement queue as linked list

// Implement queue as linked list // #include"iostream.h" #include"conio.h" #include'alloc.h" #…

Program To circular Queue using C++

//circular Queue// #include #include #define NIL -1 #define MAX 5 typedef struct { int terms[MAX]; int front,rear; }que; cla…

Program of Doubly linked list using C++

// Doubly linked list // #include #include #define NULL 0 struct list { int data; struct list*next; struct list *prev; }; ty…

Load More
That is All