Query of Order

CREATE TABLE reg(id number(10) primary key ,name varchar2(30),mob number(10),password varchar2(20),email varchar2(30),address varchar2(100));
desc reg
INSERT INTO reg (id,name,mob,password,email,address)
VALUES('20171', 'ajit', '9254213254', 'ajit123', 'ajit@gmail.com', 'kolkata india');
INSERT INTO reg (id,name,mob,password,email,address)
VALUES('20172', 'vikash', '9253351325', 'vikash123', 'vikash@gmail.com', 'RA-283,Nabaplly,Salt Lake,kolkata,india');
INSERT INTO reg (id,name,mob,password,email,address)
VALUES('20173', 'pravin', '9253554235', 'pravin123', 'pravin@gmail.com', 'RA-281,Nabaplly,Salt Lake,kolkata,india');
INSERT INTO reg (id,name,mob,password,email,address)
VALUES('20174', 'ram', '9898986658', 'sitamerijaan', 'ram@lanka.com', 'ayodhya');
INSERT INTO reg (id,name,mob,password,email,address)
VALUES('20175', 'sita', '9966696996', 'raammerajaan', 'sita@yauyaan.com', 'jankpur');
select * from reg
drop table reg
CREATE SEQUENCE sequence_reg
START WITH 20176
INCREMENT BY 1
minvalue 20176
maxvalue 20276;
INSERT INTO reg (id,name,mob,password,email,address)
VALUES(sequence_reg.nextval, 'laxhman', '9966696474', 'sitameribhabhi', 'lakxsman@yauyaan.com', 'ayodhya');
INSERT INTO reg (id,name,mob,password,email,address)
VALUES(sequence_reg.nextval, 'raavan', '9966252654', 'sitamericrush', 'don@shrilanka.com', 'srilanka');
create table orders(custmerid number(10),orderid number(10) primary key,info varchar2(200),details varchar2(200));
drop table orders
select * from orders
drop sequence sequence_orderid
desc orders
CREATE SEQUENCE sequence_orderid
START WITH 8877
INCREMENT BY 1
minvalue 8877
maxvalue 8977;
INSERT INTO orders VALUES('20171',sequence_orderid.nextval, 'Redmi NOte 3','RA-283,Nabaplly,Salt Lake,kolkata,india');
INSERT INTO orders VALUES('20171',sequence_orderid.nextval, 'Redmi Note 4','RA-283,Nabaplly,Salt Lake,kolkata,india');
INSERT INTO orders VALUES('20172',sequence_orderid.nextval, 'Redmi Note 4','RA-282,Nabaplly,Salt Lake,kolkata,india');