All Notes on BCA

QUERY:

create table customer
    (
    cus_no varchar2(6) primary key,
    cus_name varchar2(30),
    address varchar2(30),
    city varchar2(10),
    state varchar2(10),
    pincode number(6),
    bal_due number(10,2)
   );

Same table  for other format

create table customer_t5(
cust_no varchar2(6),
CONSTRAINT  cust_no_pk_t5 PRIMARY KEY(cust_no),
name varchar2(20),
address1 varchar2(30),
address varchar2(30),
city varchar2(15),
state varchar2(15),
pincode number(6),
bal_code number(10,2)
    );

Insert Query:

insert into customer values ('001','pratik','reti mohalla','rajsamand',
'rajsathan','313324','10000');

insert into customer values ('002','aman','jk mohalla','rajsamand',
'rajsathan','313324','10000');

insert into customer values ('003','dilkhush','dil','pratapgard',
'rajsathan','313324','10000');

insert into customer values ('004','Ajay','x mohalla','chennai',
'tamilnadu','123224','20000');

insert into customer values ('005','shiva','xyz mohalla','chennai',
'tamilnadu','21124','30000');

 insert into customer values ('006','dilkhush','my house, new mohalla',
'bangalore','karnatak','123224','20000');

insert into customer values ('007','jayesh','k road, new mohalla',
'bangalore','karnatak','233224','30000');

insert into customer values ('008','sayam','my city','bangalore',
'karnatak','233224','30000');

select * from customer;

OUTPUT:

cus_no	cus_name	address	city	state	pincode	due_bal
001	pratik	reti mohalla	rajsamand	rajsathan	313324	10000
002	aman	jk mohalla	rajsamand	rajsathan	313324	15000
003	dilkhush	dil	pratapgard	rajsathan	313324	10000
004	ajay	x mohalla	chennai	tamilnadu	123224	20000
005	shiva	xyz mohalla	chennai	tmailnadu	233224	30000
006	nimai	new mohalla	banglore	karnatak	123224	20000
007	jayesh	k road	banglore	karnatak	233224	30000
008	sayam	my city	banglore	karnatak	233224	30000