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

VisualBuilder Table

 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

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

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');

• Printer Friendly
• Email to a friend
• Add to my Favourites
• Download PDF version
• Report Bad Submissions
• Submit Feedback