TERADATA_SAMPLE_TABLES_FOR_PRACTICE

PARTY TABLE
==============
create table party(partyid integer,
partyname varchar(30),partycode integer,partyincome
integer,jdate date format 'YYYY-MM-DD',partyloc varchar(30));
insert into party(1,'vinay',10,40000,'2008-09-09','hyd');
insert into party(2,'vishnu',20,50000,'2008-08-09','mum');
insert into party(3,'LEELA',30,10000,'2008-07-08','che');
insert into party(4,'rakesh',40,40000,'2008-06-13','hyd');
insert into party(5,'rajesh',10,30000,'2008-09-18','mum');
insert into party(6,'  raman   ',20,80000,'2008-08-07','che');
insert into party(7,'hdfc',30,60000,'2008-10-10','hyd');
insert into party(8,'%icici',10,50000,'2008-11-11','mum');
insert into party(9,null,10,50000,'2008-11-11','che');

TEST TABLE
============
CREATE TABLE TEST(PARTYID INTEGER,
PARTYNAME VARCHAR(30),
TESTID VARCHAR(30))
--SEL * FROM PARTY;
INSERT INTO TEST(1,'VINAY','HYD');
INSERT INTO TEST(2,'VISHNU','BLORE');
INSERT INTO TEST(22,'VIKAS','BLORE');

EMP TABLE
===============
create table emp(eid integer,ename varchar(30),
mgrid integer,deptid integer);
insert into emp(1,'vinay',2,10);
insert into emp(2,'ramki',3,20);
insert into emp(3,'raju',1,30);
insert into emp(4,'krishna',2,20);
insert into emp(5,'mukesh',2,10);

EMP_NEW TABLE
===================
create table emp_NEW(eid integer,ename varchar(30),
mgrid integer,deptid integer);
insert into emp_NEW(1,'vinay',2,10);
insert into emp_NEW(2,'ramki',3,20);
create table dept(deptid integer,deptname varchar(30));
insert into dept(10,'IT');
INSERT INTO DEPT(30,'HR');

EMP_ADDRESS
===============
create table emp_ADDRESS(empid integer,empname varchar(30),
ADDRESS VARCHAR(30));
insert into emp_ADDRESS(1,'vinay','motinagar hyd');
insert into emp_address(2,'ramki','gachibowli hyd');
insert into emp_address(8,'murali','kukatpally hyd');