The following are the tables we use for all the examples in this tutorial.

VisualBuilder Table

Col=Id Type =Int	Col=Name Type=varchar	Col= Description Type=CLOB
1	Sun Java	null
2	Visual Builder	null
3	Eclipse	null
4	IBM	null
5	Jakarta	null

 SQL Query:-

1. Create table visualbuilder ( Id int, name varchar(30), Description Clob);

2. Insert into visualbuilder (id, name) values(1,'Sun Java');

3. Insert into visualbuilder (id, name) values(2,'Visual Builder');

4. Insert into visualbuilder (id, name) values(3,'Eclipse');

5. Insert into visualbuilder (id, name) values(4,'IBM');

6. Insert into visualbuilder (id, name) values(5,'Jakarta');

Employee Table

Col= Id Type=Int	Col=Ename Type= varchar	Col= DeptId Type= Int
1	Adam	1
2	Susan	2
3	Adran	3
4	Hardy	3
5	Tim	2
6	Michael	1

SQL Query:-

1. Create table employee ( id int, ename varchar(30), deptId);

2. Insert into employee (id, ename, deptid) values(1,'Adam',1);

3. Insert into employee (id, ename, deptid) values(2,'Susan',2);

4. Insert into employee (id, ename, deptid) values(3,'Adran',3);

5. Insert into employee (id, ename, deptid) values(4,'Hardy',3);

6. Insert into employee (id, ename, deptid) values(5,'Tim',2);

7. Insert into employee (id, ename, deptid) values(6,'Michael',3);

 Department Table

Col= id Type= int	Col= Dname Type= varchar
1.	Sales
2	Account
3	Marketing

SQL Query:-

1. Create table department ( id int, dname varchar(30));

2. Insert into department (id, dname) values(1,'Sales');

3. Insert into department (id, dname) values(2,'Account');

4. Insert into department (id, dname) values(3,'Marketing');