Oracle Live SQL - Script: F.A.4. DBMS

Statement 1

create table Customer_Details(Customer_id int(8) primary key,fname varchar2(20) NOT NULL,lname varchar2(20) NOT NULL,phone_no int(10) NOT NULL,email_id varchar2(30) NOT NULL,street varchar2(10) NOT NULL,city varchar2(20) NOT NULL,state_name varchar2(20) NOT NULL,pincode int(6) NOT NULL)

ORA-00907: missing right parenthesis

More Details: https://docs.oracle.com/error-help/db/ora-00907

Statement 2

create table Customer_Details(Customer_id int(8) primary key,fname varchar2(20) NOT NULL,lname varchar2(20) NOT NULL,phone_no int(10) NOT NULL,email_id varchar2(30) NOT NULL,street varchar2(10) NOT NULL,city varchar2(20) NOT NULL,state_name varchar2(20) NOT NULL,pincode int(6) NOT NULL))

ORA-00907: missing right parenthesis

More Details: https://docs.oracle.com/error-help/db/ora-00907

Statement 3

create table Customer_Details(Customer_id int(8) primary key,fname varchar2(20) NOT NULL,lname varchar2(20) NOT NULL,phone_no int(10) NOT NULL,email_id varchar2(30) NOT NULL,street varchar2(10) NOT NULL,city varchar2(20) NOT NULL,state_name varchar2(20) NOT NULL,pincode int(6) NOT NULL)

ORA-00907: missing right parenthesis

More Details: https://docs.oracle.com/error-help/db/ora-00907

Statement 4

create table Customer_Details(Customer_id int(8) primary key,fname varchar2(20) NOT NULL,lname varchar2(20) NOT NULL,phone_no int(10) NOT NULL,email_id varchar2(30) NOT NULL,street varchar2(10) NOT NULL,city varchar2(20) NOT NULL,state_name varchar2(20) NOT NULL,pincode int(6) NOT NULL)

ORA-00907: missing right parenthesis

More Details: https://docs.oracle.com/error-help/db/ora-00907

Statement 5

create table Customer_Details(Customer_id int(8),fname varchar2(20) NOT NULL,lname varchar2(20) NOT NULL,phone_no int(10) NOT NULL,email_id varchar2(30) NOT NULL,street varchar2(10) NOT NULL,city varchar2(20) NOT NULL,state_name varchar2(20) NOT NULL,pincode int(6) NOT NULL,primary key(Customer_id))

ORA-00907: missing right parenthesis

More Details: https://docs.oracle.com/error-help/db/ora-00907

Statement 6

create table Customer_Details(Customer_id int(8), 
fname varchar2(20) NOT NULL, 
lname varchar2(20) NOT NULL, 
phone_no int(10) NOT NULL, 
email_id varchar2(30) NOT NULL, 
street varchar2(10) NOT NULL, 
city varchar2(20) NOT NULL, 
state_name varchar2(20) NOT NULL, 
pincode int(6) NOT NULL, 
constraint customer 
primary key(Customer_id) 
)

ORA-00907: missing right parenthesis

More Details: https://docs.oracle.com/error-help/db/ora-00907

Statement 7

create table Customer_Details(Customer_id int(8), 
fname varchar2(20) NOT NULL, 
lname varchar2(20) NOT NULL, 
phone_no int(10) NOT NULL, 
email_id varchar2(30) NOT NULL, 
street varchar2(10) NOT NULL, 
city varchar2(20) NOT NULL, 
state_name varchar2(20) NOT NULL, 
pincode int(6) NOT NULL, 
constraint customer, 
primary key(Customer_id) 
)

ORA-00907: missing right parenthesis

More Details: https://docs.oracle.com/error-help/db/ora-00907

Statement 8

desc Customer_Details

TABLE CUSTOMER_DETAILS
Column Null? Type
CUSTOMER_ID NOT NULL NUMBER(8,0)
FNAME NOT NULL VARCHAR2(25)
LNAME NOT NULL VARCHAR2(25)
PHONE_NUMBER NOT NULL NUMBER(10,0)
EMAIL_ID NOT NULL VARCHAR2(30)
STREET NOT NULL VARCHAR2(30)
CITY NOT NULL VARCHAR2(20)
STATE_NAME NOT NULL VARCHAR2(20)
PINCODE NOT NULL NUMBER(6,0)

9 rows selected.

Column	Null?	Type
CUSTOMER_ID	NOT NULL	NUMBER(8,0)
FNAME	NOT NULL	VARCHAR2(25)
LNAME	NOT NULL	VARCHAR2(25)
PHONE_NUMBER	NOT NULL	NUMBER(10,0)
EMAIL_ID	NOT NULL	VARCHAR2(30)
STREET	NOT NULL	VARCHAR2(30)
CITY	NOT NULL	VARCHAR2(20)
STATE_NAME	NOT NULL	VARCHAR2(20)
PINCODE	NOT NULL	NUMBER(6,0)

Statement 9

CREATE TABLE CUSTOMER_DETAILS 
( Customer_id NUMBER(8) NOT NULL, 
FNAME VARCHAR(25) NOT NULL, 
LNAME VARCHAR(25) NOT NULL, 
PHONE_NUMBER NUMBER(10) NOT NULL, 
EMAIL_ID VARCHAR(30) NOT NULL, 
STREET VARCHAR(30) NOT NULL, 
CITY VARCHAR(20) NOT NULL, 
STATE_NAME VARCHAR(20) NOT NULL, 
PINCODE NUMBER(6) NOT NULL, 
PRIMARY KEY (Customer_id) 
)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 10

desc CUSTOMER_DETAILS

TABLE CUSTOMER_DETAILS
Column Null? Type
CUSTOMER_ID NOT NULL NUMBER(8,0)
FNAME NOT NULL VARCHAR2(25)
LNAME NOT NULL VARCHAR2(25)
PHONE_NUMBER NOT NULL NUMBER(10,0)
EMAIL_ID NOT NULL VARCHAR2(30)
STREET NOT NULL VARCHAR2(30)
CITY NOT NULL VARCHAR2(20)
STATE_NAME NOT NULL VARCHAR2(20)
PINCODE NOT NULL NUMBER(6,0)

9 rows selected.

Column	Null?	Type
CUSTOMER_ID	NOT NULL	NUMBER(8,0)
FNAME	NOT NULL	VARCHAR2(25)
LNAME	NOT NULL	VARCHAR2(25)
PHONE_NUMBER	NOT NULL	NUMBER(10,0)
EMAIL_ID	NOT NULL	VARCHAR2(30)
STREET	NOT NULL	VARCHAR2(30)
CITY	NOT NULL	VARCHAR2(20)
STATE_NAME	NOT NULL	VARCHAR2(20)
PINCODE	NOT NULL	NUMBER(6,0)

Statement 11

desc CUSTOMER_DETAILS

TABLE CUSTOMER_DETAILS
Column Null? Type
CUSTOMER_ID NOT NULL NUMBER(8,0)
FNAME NOT NULL VARCHAR2(25)
LNAME NOT NULL VARCHAR2(25)
PHONE_NUMBER NOT NULL NUMBER(10,0)
EMAIL_ID NOT NULL VARCHAR2(30)
STREET NOT NULL VARCHAR2(30)
CITY NOT NULL VARCHAR2(20)
STATE_NAME NOT NULL VARCHAR2(20)
PINCODE NOT NULL NUMBER(6,0)

9 rows selected.

Column	Null?	Type
CUSTOMER_ID	NOT NULL	NUMBER(8,0)
FNAME	NOT NULL	VARCHAR2(25)
LNAME	NOT NULL	VARCHAR2(25)
PHONE_NUMBER	NOT NULL	NUMBER(10,0)
EMAIL_ID	NOT NULL	VARCHAR2(30)
STREET	NOT NULL	VARCHAR2(30)
CITY	NOT NULL	VARCHAR2(20)
STATE_NAME	NOT NULL	VARCHAR2(20)
PINCODE	NOT NULL	NUMBER(6,0)

Statement 12

SELECT * FROM CUSTOMER_DETAILS


CUSTOMER_ID FNAME LNAME PHONE_NUMBER EMAIL_ID STREET CITY STATE_NAME PINCODE
70000001 KOMAL DHANJAL 7529810009 komaldhanjal@gmail.com 4 MOHALI PUNJAB 160047
70000002 ABHINAV NANDRAJOG 6284665396 abhinav@gmail.com 10 ZIRAKPUR PUNJAB 160104
70000003 ADITYA MOUDGIL 9814922983 aditya@gmail.com 40 SIRHIND PUNJAB 140406
70000004 SAHIL KUMAR 9888059745 sahilkumar@gmail.com 17 AMRITSAR PUNJAB 140047
70000005 HARSHIT SAINI 9530909795 hsaini@gmail.com 47 RAMGARH HARAYANA 140078
70000006 NAVYA ARORA 9813452983 navya@gmail.com 67 KHANNA PUNJAB 141401
70000009 SANJEEV KUMAR 9813452966 sanjeev@gmail.com 56 MOHALI PUNJAB 141404
70000010 RAJAT BHARDWAJ 7685674893 rajat@gmail.com 65 PANCHKULA HARAYANA 130106
70000008 VANSH BANSAL 7564897352 vanshbansal@gmail.com 75 SOHANA PUNJAB 160034
70000007 CHITRA KARAYAT 8427345558 chitra@gmail.com 78 CHANDIGARH CHANDIGARH 160089

10 rows selected.

CUSTOMER_ID	FNAME	LNAME	PHONE_NUMBER	EMAIL_ID	STREET	CITY	STATE_NAME	PINCODE
70000001	KOMAL	DHANJAL	7529810009	komaldhanjal@gmail.com	4	MOHALI	PUNJAB	160047
70000002	ABHINAV	NANDRAJOG	6284665396	abhinav@gmail.com	10	ZIRAKPUR	PUNJAB	160104
70000003	ADITYA	MOUDGIL	9814922983	aditya@gmail.com	40	SIRHIND	PUNJAB	140406
70000004	SAHIL	KUMAR	9888059745	sahilkumar@gmail.com	17	AMRITSAR	PUNJAB	140047
70000005	HARSHIT	SAINI	9530909795	hsaini@gmail.com	47	RAMGARH	HARAYANA	140078
70000006	NAVYA	ARORA	9813452983	navya@gmail.com	67	KHANNA	PUNJAB	141401
70000009	SANJEEV	KUMAR	9813452966	sanjeev@gmail.com	56	MOHALI	PUNJAB	141404
70000010	RAJAT	BHARDWAJ	7685674893	rajat@gmail.com	65	PANCHKULA	HARAYANA	130106
70000008	VANSH	BANSAL	7564897352	vanshbansal@gmail.com	75	SOHANA	PUNJAB	160034
70000007	CHITRA	KARAYAT	8427345558	chitra@gmail.com	78	CHANDIGARH	CHANDIGARH	160089

Statement 13

desc CUSTOMER_DETAILS

TABLE CUSTOMER_DETAILS
Column Null? Type
CUSTOMER_ID NOT NULL NUMBER(8,0)
FNAME NOT NULL VARCHAR2(25)
LNAME NOT NULL VARCHAR2(25)
PHONE_NUMBER NOT NULL NUMBER(10,0)
EMAIL_ID NOT NULL VARCHAR2(30)
STREET NOT NULL VARCHAR2(30)
CITY NOT NULL VARCHAR2(20)
STATE_NAME NOT NULL VARCHAR2(20)
PINCODE NOT NULL NUMBER(6,0)

9 rows selected.

Column	Null?	Type
CUSTOMER_ID	NOT NULL	NUMBER(8,0)
FNAME	NOT NULL	VARCHAR2(25)
LNAME	NOT NULL	VARCHAR2(25)
PHONE_NUMBER	NOT NULL	NUMBER(10,0)
EMAIL_ID	NOT NULL	VARCHAR2(30)
STREET	NOT NULL	VARCHAR2(30)
CITY	NOT NULL	VARCHAR2(20)
STATE_NAME	NOT NULL	VARCHAR2(20)
PINCODE	NOT NULL	NUMBER(6,0)

Statement 14

desc CUSTOMER_DETAILS

TABLE CUSTOMER_DETAILS
Column Null? Type
CUSTOMER_ID NOT NULL NUMBER(8,0)
FNAME NOT NULL VARCHAR2(25)
LNAME NOT NULL VARCHAR2(25)
PHONE_NUMBER NOT NULL NUMBER(10,0)
EMAIL_ID NOT NULL VARCHAR2(30)
STREET NOT NULL VARCHAR2(30)
CITY NOT NULL VARCHAR2(20)
STATE_NAME NOT NULL VARCHAR2(20)
PINCODE NOT NULL NUMBER(6,0)

9 rows selected.

Column	Null?	Type
CUSTOMER_ID	NOT NULL	NUMBER(8,0)
FNAME	NOT NULL	VARCHAR2(25)
LNAME	NOT NULL	VARCHAR2(25)
PHONE_NUMBER	NOT NULL	NUMBER(10,0)
EMAIL_ID	NOT NULL	VARCHAR2(30)
STREET	NOT NULL	VARCHAR2(30)
CITY	NOT NULL	VARCHAR2(20)
STATE_NAME	NOT NULL	VARCHAR2(20)
PINCODE	NOT NULL	NUMBER(6,0)

Statement 15

desc CUSTOMER_DETAILS

TABLE CUSTOMER_DETAILS
Column Null? Type
CUSTOMER_ID NOT NULL NUMBER(8,0)
FNAME NOT NULL VARCHAR2(25)
LNAME NOT NULL VARCHAR2(25)
PHONE_NUMBER NOT NULL NUMBER(10,0)
EMAIL_ID NOT NULL VARCHAR2(30)
STREET NOT NULL VARCHAR2(30)
CITY NOT NULL VARCHAR2(20)
STATE_NAME NOT NULL VARCHAR2(20)
PINCODE NOT NULL NUMBER(6,0)

9 rows selected.

Column	Null?	Type
CUSTOMER_ID	NOT NULL	NUMBER(8,0)
FNAME	NOT NULL	VARCHAR2(25)
LNAME	NOT NULL	VARCHAR2(25)
PHONE_NUMBER	NOT NULL	NUMBER(10,0)
EMAIL_ID	NOT NULL	VARCHAR2(30)
STREET	NOT NULL	VARCHAR2(30)
CITY	NOT NULL	VARCHAR2(20)
STATE_NAME	NOT NULL	VARCHAR2(20)
PINCODE	NOT NULL	NUMBER(6,0)

Statement 16

INSERT INTO CUSTOMER_DETAILS(70000001,'ABHINAV','NANDRAJOG',6284665396,'ABHINAV@GMAIL.COM','DHAKOLI','ZIRAKPUR','PUNJAB',160104)

ORA-00928: missing SELECT keyword

More Details: https://docs.oracle.com/error-help/db/ora-00928

Statement 17

INSERT INTO CUSTOMER_DETAILS VALUES('70000001', 'KOMAL', 
'DHANJAL','7529810009', 'komaldhanjal@gmail.com','4', 
'MOHALI','PUNJAB',160047)

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461061) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 18

select * from CUSTOMER_DETAILS


CUSTOMER_ID FNAME LNAME PHONE_NUMBER EMAIL_ID STREET CITY STATE_NAME PINCODE
70000001 KOMAL DHANJAL 7529810009 komaldhanjal@gmail.com 4 MOHALI PUNJAB 160047
70000002 ABHINAV NANDRAJOG 6284665396 abhinav@gmail.com 10 ZIRAKPUR PUNJAB 160104
70000003 ADITYA MOUDGIL 9814922983 aditya@gmail.com 40 SIRHIND PUNJAB 140406
70000004 SAHIL KUMAR 9888059745 sahilkumar@gmail.com 17 AMRITSAR PUNJAB 140047
70000005 HARSHIT SAINI 9530909795 hsaini@gmail.com 47 RAMGARH HARAYANA 140078
70000006 NAVYA ARORA 9813452983 navya@gmail.com 67 KHANNA PUNJAB 141401
70000009 SANJEEV KUMAR 9813452966 sanjeev@gmail.com 56 MOHALI PUNJAB 141404
70000010 RAJAT BHARDWAJ 7685674893 rajat@gmail.com 65 PANCHKULA HARAYANA 130106
70000008 VANSH BANSAL 7564897352 vanshbansal@gmail.com 75 SOHANA PUNJAB 160034
70000007 CHITRA KARAYAT 8427345558 chitra@gmail.com 78 CHANDIGARH CHANDIGARH 160089

10 rows selected.

CUSTOMER_ID	FNAME	LNAME	PHONE_NUMBER	EMAIL_ID	STREET	CITY	STATE_NAME	PINCODE
70000001	KOMAL	DHANJAL	7529810009	komaldhanjal@gmail.com	4	MOHALI	PUNJAB	160047
70000002	ABHINAV	NANDRAJOG	6284665396	abhinav@gmail.com	10	ZIRAKPUR	PUNJAB	160104
70000003	ADITYA	MOUDGIL	9814922983	aditya@gmail.com	40	SIRHIND	PUNJAB	140406
70000004	SAHIL	KUMAR	9888059745	sahilkumar@gmail.com	17	AMRITSAR	PUNJAB	140047
70000005	HARSHIT	SAINI	9530909795	hsaini@gmail.com	47	RAMGARH	HARAYANA	140078
70000006	NAVYA	ARORA	9813452983	navya@gmail.com	67	KHANNA	PUNJAB	141401
70000009	SANJEEV	KUMAR	9813452966	sanjeev@gmail.com	56	MOHALI	PUNJAB	141404
70000010	RAJAT	BHARDWAJ	7685674893	rajat@gmail.com	65	PANCHKULA	HARAYANA	130106
70000008	VANSH	BANSAL	7564897352	vanshbansal@gmail.com	75	SOHANA	PUNJAB	160034
70000007	CHITRA	KARAYAT	8427345558	chitra@gmail.com	78	CHANDIGARH	CHANDIGARH	160089

Statement 19

 INSERT INTO CUSTOMER_DETAILS VALUES(70000001,'ABHINAV','NANDRAJOG',6284665396,'ABHINAV@GMAIL.COM','10','ZIRAKPUR','PUNJAB',160104)

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461061) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 20

 INSERT INTO CUSTOMER_DETAILS VALUES(70000002,'ABHINAV','NANDRAJOG',6284665396,'ABHINAV@GMAIL.COM','10','ZIRAKPUR','PUNJAB',160104)

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461061) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 21

INSERT INTO CUSTOMER_DETAILS VALUES(70000003, 'ADITYA','MOUDGIL',9814922983, 'aditya@gmail.com','40','SIRHIND','PUNJAB',140406)

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461061) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 22

SELECT * FROM CUSTOMER_DETAILS


CUSTOMER_ID FNAME LNAME PHONE_NUMBER EMAIL_ID STREET CITY STATE_NAME PINCODE
70000001 KOMAL DHANJAL 7529810009 komaldhanjal@gmail.com 4 MOHALI PUNJAB 160047
70000002 ABHINAV NANDRAJOG 6284665396 abhinav@gmail.com 10 ZIRAKPUR PUNJAB 160104
70000003 ADITYA MOUDGIL 9814922983 aditya@gmail.com 40 SIRHIND PUNJAB 140406
70000004 SAHIL KUMAR 9888059745 sahilkumar@gmail.com 17 AMRITSAR PUNJAB 140047
70000005 HARSHIT SAINI 9530909795 hsaini@gmail.com 47 RAMGARH HARAYANA 140078
70000006 NAVYA ARORA 9813452983 navya@gmail.com 67 KHANNA PUNJAB 141401
70000009 SANJEEV KUMAR 9813452966 sanjeev@gmail.com 56 MOHALI PUNJAB 141404
70000010 RAJAT BHARDWAJ 7685674893 rajat@gmail.com 65 PANCHKULA HARAYANA 130106
70000008 VANSH BANSAL 7564897352 vanshbansal@gmail.com 75 SOHANA PUNJAB 160034
70000007 CHITRA KARAYAT 8427345558 chitra@gmail.com 78 CHANDIGARH CHANDIGARH 160089

10 rows selected.

CUSTOMER_ID	FNAME	LNAME	PHONE_NUMBER	EMAIL_ID	STREET	CITY	STATE_NAME	PINCODE
70000001	KOMAL	DHANJAL	7529810009	komaldhanjal@gmail.com	4	MOHALI	PUNJAB	160047
70000002	ABHINAV	NANDRAJOG	6284665396	abhinav@gmail.com	10	ZIRAKPUR	PUNJAB	160104
70000003	ADITYA	MOUDGIL	9814922983	aditya@gmail.com	40	SIRHIND	PUNJAB	140406
70000004	SAHIL	KUMAR	9888059745	sahilkumar@gmail.com	17	AMRITSAR	PUNJAB	140047
70000005	HARSHIT	SAINI	9530909795	hsaini@gmail.com	47	RAMGARH	HARAYANA	140078
70000006	NAVYA	ARORA	9813452983	navya@gmail.com	67	KHANNA	PUNJAB	141401
70000009	SANJEEV	KUMAR	9813452966	sanjeev@gmail.com	56	MOHALI	PUNJAB	141404
70000010	RAJAT	BHARDWAJ	7685674893	rajat@gmail.com	65	PANCHKULA	HARAYANA	130106
70000008	VANSH	BANSAL	7564897352	vanshbansal@gmail.com	75	SOHANA	PUNJAB	160034
70000007	CHITRA	KARAYAT	8427345558	chitra@gmail.com	78	CHANDIGARH	CHANDIGARH	160089

Statement 23

INSERT INTO CUSTOMER_DETAILS VALUES('70000004', 'SAHIL', 
'KUMAR','9888059745', 'sahilkumar@gmail.com','17', 
'AMRITSAR','PUNJAB',140047)

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461061) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 24

INSERT INTO CUSTOMER_DETAILS VALUES('70000005', 'HARSHIT', 
'SAINI','9530909795', 'hsaini@gmail.com','47', 
'RAMGARH','HARAYANA',140078)

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461061) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 25

INSERT INTO CUSTOMER_DETAILS VALUES(70000006, 'NAVYA','ARORA',9813452983, 'navya@gmail.com','67','KHANNA','PUNJAB',141401)

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461061) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 26

INSERT INTO CUSTOMER_DETAILS VALUES(70000009, 'SANJEEV','KUMAR',9813452966, 'sanjeev@gmail.com','56','MOHALI','PUNJAB',141404)

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461061) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 27

INSERT INTO CUSTOMER_DETAILS VALUES('70000010', 'RAJAT', 
'BHARDWAJ','7685674893', 'rajat@gmail.com','65', 
'PANCHKULA','HARAYANA',130106)

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461061) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 28

INSERT INTO CUSTOMER_DETAILS VALUES('70000008', 'VANSH', 
'BANSAL','7564897352', 'vanshbansal@gmail.com','75', 
'SOHANA','PUNJAB',160034)

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461061) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 29

SELECT * FROM CUSTOMER_DETAILS


CUSTOMER_ID FNAME LNAME PHONE_NUMBER EMAIL_ID STREET CITY STATE_NAME PINCODE
70000001 KOMAL DHANJAL 7529810009 komaldhanjal@gmail.com 4 MOHALI PUNJAB 160047
70000002 ABHINAV NANDRAJOG 6284665396 abhinav@gmail.com 10 ZIRAKPUR PUNJAB 160104
70000003 ADITYA MOUDGIL 9814922983 aditya@gmail.com 40 SIRHIND PUNJAB 140406
70000004 SAHIL KUMAR 9888059745 sahilkumar@gmail.com 17 AMRITSAR PUNJAB 140047
70000005 HARSHIT SAINI 9530909795 hsaini@gmail.com 47 RAMGARH HARAYANA 140078
70000006 NAVYA ARORA 9813452983 navya@gmail.com 67 KHANNA PUNJAB 141401
70000009 SANJEEV KUMAR 9813452966 sanjeev@gmail.com 56 MOHALI PUNJAB 141404
70000010 RAJAT BHARDWAJ 7685674893 rajat@gmail.com 65 PANCHKULA HARAYANA 130106
70000008 VANSH BANSAL 7564897352 vanshbansal@gmail.com 75 SOHANA PUNJAB 160034
70000007 CHITRA KARAYAT 8427345558 chitra@gmail.com 78 CHANDIGARH CHANDIGARH 160089

10 rows selected.

CUSTOMER_ID	FNAME	LNAME	PHONE_NUMBER	EMAIL_ID	STREET	CITY	STATE_NAME	PINCODE
70000001	KOMAL	DHANJAL	7529810009	komaldhanjal@gmail.com	4	MOHALI	PUNJAB	160047
70000002	ABHINAV	NANDRAJOG	6284665396	abhinav@gmail.com	10	ZIRAKPUR	PUNJAB	160104
70000003	ADITYA	MOUDGIL	9814922983	aditya@gmail.com	40	SIRHIND	PUNJAB	140406
70000004	SAHIL	KUMAR	9888059745	sahilkumar@gmail.com	17	AMRITSAR	PUNJAB	140047
70000005	HARSHIT	SAINI	9530909795	hsaini@gmail.com	47	RAMGARH	HARAYANA	140078
70000006	NAVYA	ARORA	9813452983	navya@gmail.com	67	KHANNA	PUNJAB	141401
70000009	SANJEEV	KUMAR	9813452966	sanjeev@gmail.com	56	MOHALI	PUNJAB	141404
70000010	RAJAT	BHARDWAJ	7685674893	rajat@gmail.com	65	PANCHKULA	HARAYANA	130106
70000008	VANSH	BANSAL	7564897352	vanshbansal@gmail.com	75	SOHANA	PUNJAB	160034
70000007	CHITRA	KARAYAT	8427345558	chitra@gmail.com	78	CHANDIGARH	CHANDIGARH	160089

Statement 30

SELECT * FROM CUSTOMER_DETAILS ORDER BY CUSTOMER_ID ASC


CUSTOMER_ID FNAME LNAME PHONE_NUMBER EMAIL_ID STREET CITY STATE_NAME PINCODE
70000001 KOMAL DHANJAL 7529810009 komaldhanjal@gmail.com 4 MOHALI PUNJAB 160047
70000002 ABHINAV NANDRAJOG 6284665396 abhinav@gmail.com 10 ZIRAKPUR PUNJAB 160104
70000003 ADITYA MOUDGIL 9814922983 aditya@gmail.com 40 SIRHIND PUNJAB 140406
70000004 SAHIL KUMAR 9888059745 sahilkumar@gmail.com 17 AMRITSAR PUNJAB 140047
70000005 HARSHIT SAINI 9530909795 hsaini@gmail.com 47 RAMGARH HARAYANA 140078
70000006 NAVYA ARORA 9813452983 navya@gmail.com 67 KHANNA PUNJAB 141401
70000007 CHITRA KARAYAT 8427345558 chitra@gmail.com 78 CHANDIGARH CHANDIGARH 160089
70000008 VANSH BANSAL 7564897352 vanshbansal@gmail.com 75 SOHANA PUNJAB 160034
70000009 SANJEEV KUMAR 9813452966 sanjeev@gmail.com 56 MOHALI PUNJAB 141404
70000010 RAJAT BHARDWAJ 7685674893 rajat@gmail.com 65 PANCHKULA HARAYANA 130106

10 rows selected.

CUSTOMER_ID	FNAME	LNAME	PHONE_NUMBER	EMAIL_ID	STREET	CITY	STATE_NAME	PINCODE
70000001	KOMAL	DHANJAL	7529810009	komaldhanjal@gmail.com	4	MOHALI	PUNJAB	160047
70000002	ABHINAV	NANDRAJOG	6284665396	abhinav@gmail.com	10	ZIRAKPUR	PUNJAB	160104
70000003	ADITYA	MOUDGIL	9814922983	aditya@gmail.com	40	SIRHIND	PUNJAB	140406
70000004	SAHIL	KUMAR	9888059745	sahilkumar@gmail.com	17	AMRITSAR	PUNJAB	140047
70000005	HARSHIT	SAINI	9530909795	hsaini@gmail.com	47	RAMGARH	HARAYANA	140078
70000006	NAVYA	ARORA	9813452983	navya@gmail.com	67	KHANNA	PUNJAB	141401
70000007	CHITRA	KARAYAT	8427345558	chitra@gmail.com	78	CHANDIGARH	CHANDIGARH	160089
70000008	VANSH	BANSAL	7564897352	vanshbansal@gmail.com	75	SOHANA	PUNJAB	160034
70000009	SANJEEV	KUMAR	9813452966	sanjeev@gmail.com	56	MOHALI	PUNJAB	141404
70000010	RAJAT	BHARDWAJ	7685674893	rajat@gmail.com	65	PANCHKULA	HARAYANA	130106

Statement 31

UPDATE CUSTOMER_DETAILS SET 'EMAIL_ID' = 'abhinav@gmail.com' where  CUSTOMER_ID=70000002

ORA-01747: invalid user.table.column, table.column, or column specification

More Details: https://docs.oracle.com/error-help/db/ora-01747

Statement 32

UPDATE CUSTOMER_DETAILS SET EMAIL_ID = 'abhinav@gmail.com' where  CUSTOMER_ID=70000002

1 row(s) updated.

Statement 33

SELECT * FROM CUSTOMER_DETAILS


CUSTOMER_ID FNAME LNAME PHONE_NUMBER EMAIL_ID STREET CITY STATE_NAME PINCODE
70000001 KOMAL DHANJAL 7529810009 komaldhanjal@gmail.com 4 MOHALI PUNJAB 160047
70000002 ABHINAV NANDRAJOG 6284665396 abhinav@gmail.com 10 ZIRAKPUR PUNJAB 160104
70000003 ADITYA MOUDGIL 9814922983 aditya@gmail.com 40 SIRHIND PUNJAB 140406
70000004 SAHIL KUMAR 9888059745 sahilkumar@gmail.com 17 AMRITSAR PUNJAB 140047
70000005 HARSHIT SAINI 9530909795 hsaini@gmail.com 47 RAMGARH HARAYANA 140078
70000006 NAVYA ARORA 9813452983 navya@gmail.com 67 KHANNA PUNJAB 141401
70000009 SANJEEV KUMAR 9813452966 sanjeev@gmail.com 56 MOHALI PUNJAB 141404
70000010 RAJAT BHARDWAJ 7685674893 rajat@gmail.com 65 PANCHKULA HARAYANA 130106
70000008 VANSH BANSAL 7564897352 vanshbansal@gmail.com 75 SOHANA PUNJAB 160034
70000007 CHITRA KARAYAT 8427345558 chitra@gmail.com 78 CHANDIGARH CHANDIGARH 160089

10 rows selected.

CUSTOMER_ID	FNAME	LNAME	PHONE_NUMBER	EMAIL_ID	STREET	CITY	STATE_NAME	PINCODE
70000001	KOMAL	DHANJAL	7529810009	komaldhanjal@gmail.com	4	MOHALI	PUNJAB	160047
70000002	ABHINAV	NANDRAJOG	6284665396	abhinav@gmail.com	10	ZIRAKPUR	PUNJAB	160104
70000003	ADITYA	MOUDGIL	9814922983	aditya@gmail.com	40	SIRHIND	PUNJAB	140406
70000004	SAHIL	KUMAR	9888059745	sahilkumar@gmail.com	17	AMRITSAR	PUNJAB	140047
70000005	HARSHIT	SAINI	9530909795	hsaini@gmail.com	47	RAMGARH	HARAYANA	140078
70000006	NAVYA	ARORA	9813452983	navya@gmail.com	67	KHANNA	PUNJAB	141401
70000009	SANJEEV	KUMAR	9813452966	sanjeev@gmail.com	56	MOHALI	PUNJAB	141404
70000010	RAJAT	BHARDWAJ	7685674893	rajat@gmail.com	65	PANCHKULA	HARAYANA	130106
70000008	VANSH	BANSAL	7564897352	vanshbansal@gmail.com	75	SOHANA	PUNJAB	160034
70000007	CHITRA	KARAYAT	8427345558	chitra@gmail.com	78	CHANDIGARH	CHANDIGARH	160089

Statement 34

SELECT * FROM CUSTOMER_DETAILS ORDER BY CUSTOMER_ID ASC


CUSTOMER_ID FNAME LNAME PHONE_NUMBER EMAIL_ID STREET CITY STATE_NAME PINCODE
70000001 KOMAL DHANJAL 7529810009 komaldhanjal@gmail.com 4 MOHALI PUNJAB 160047
70000002 ABHINAV NANDRAJOG 6284665396 abhinav@gmail.com 10 ZIRAKPUR PUNJAB 160104
70000003 ADITYA MOUDGIL 9814922983 aditya@gmail.com 40 SIRHIND PUNJAB 140406
70000004 SAHIL KUMAR 9888059745 sahilkumar@gmail.com 17 AMRITSAR PUNJAB 140047
70000005 HARSHIT SAINI 9530909795 hsaini@gmail.com 47 RAMGARH HARAYANA 140078
70000006 NAVYA ARORA 9813452983 navya@gmail.com 67 KHANNA PUNJAB 141401
70000007 CHITRA KARAYAT 8427345558 chitra@gmail.com 78 CHANDIGARH CHANDIGARH 160089
70000008 VANSH BANSAL 7564897352 vanshbansal@gmail.com 75 SOHANA PUNJAB 160034
70000009 SANJEEV KUMAR 9813452966 sanjeev@gmail.com 56 MOHALI PUNJAB 141404
70000010 RAJAT BHARDWAJ 7685674893 rajat@gmail.com 65 PANCHKULA HARAYANA 130106

10 rows selected.

CUSTOMER_ID	FNAME	LNAME	PHONE_NUMBER	EMAIL_ID	STREET	CITY	STATE_NAME	PINCODE
70000001	KOMAL	DHANJAL	7529810009	komaldhanjal@gmail.com	4	MOHALI	PUNJAB	160047
70000002	ABHINAV	NANDRAJOG	6284665396	abhinav@gmail.com	10	ZIRAKPUR	PUNJAB	160104
70000003	ADITYA	MOUDGIL	9814922983	aditya@gmail.com	40	SIRHIND	PUNJAB	140406
70000004	SAHIL	KUMAR	9888059745	sahilkumar@gmail.com	17	AMRITSAR	PUNJAB	140047
70000005	HARSHIT	SAINI	9530909795	hsaini@gmail.com	47	RAMGARH	HARAYANA	140078
70000006	NAVYA	ARORA	9813452983	navya@gmail.com	67	KHANNA	PUNJAB	141401
70000007	CHITRA	KARAYAT	8427345558	chitra@gmail.com	78	CHANDIGARH	CHANDIGARH	160089
70000008	VANSH	BANSAL	7564897352	vanshbansal@gmail.com	75	SOHANA	PUNJAB	160034
70000009	SANJEEV	KUMAR	9813452966	sanjeev@gmail.com	56	MOHALI	PUNJAB	141404
70000010	RAJAT	BHARDWAJ	7685674893	rajat@gmail.com	65	PANCHKULA	HARAYANA	130106

Statement 35

INSERT INTO CUSTOMER_DETAILS VALUES('70000007', 'CHITRA', 
'KARAYAT','8427345558', 'chitra@gmail.com','78', 
'CHANDIGARH','CHANDIGARH',160089)

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461061) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 36

SELECT * FROM CUSTOMER_DETAILS ORDER BY CUSTOMER_ID ASC


CUSTOMER_ID FNAME LNAME PHONE_NUMBER EMAIL_ID STREET CITY STATE_NAME PINCODE
70000001 KOMAL DHANJAL 7529810009 komaldhanjal@gmail.com 4 MOHALI PUNJAB 160047
70000002 ABHINAV NANDRAJOG 6284665396 abhinav@gmail.com 10 ZIRAKPUR PUNJAB 160104
70000003 ADITYA MOUDGIL 9814922983 aditya@gmail.com 40 SIRHIND PUNJAB 140406
70000004 SAHIL KUMAR 9888059745 sahilkumar@gmail.com 17 AMRITSAR PUNJAB 140047
70000005 HARSHIT SAINI 9530909795 hsaini@gmail.com 47 RAMGARH HARAYANA 140078
70000006 NAVYA ARORA 9813452983 navya@gmail.com 67 KHANNA PUNJAB 141401
70000007 CHITRA KARAYAT 8427345558 chitra@gmail.com 78 CHANDIGARH CHANDIGARH 160089
70000008 VANSH BANSAL 7564897352 vanshbansal@gmail.com 75 SOHANA PUNJAB 160034
70000009 SANJEEV KUMAR 9813452966 sanjeev@gmail.com 56 MOHALI PUNJAB 141404
70000010 RAJAT BHARDWAJ 7685674893 rajat@gmail.com 65 PANCHKULA HARAYANA 130106

10 rows selected.

CUSTOMER_ID	FNAME	LNAME	PHONE_NUMBER	EMAIL_ID	STREET	CITY	STATE_NAME	PINCODE
70000001	KOMAL	DHANJAL	7529810009	komaldhanjal@gmail.com	4	MOHALI	PUNJAB	160047
70000002	ABHINAV	NANDRAJOG	6284665396	abhinav@gmail.com	10	ZIRAKPUR	PUNJAB	160104
70000003	ADITYA	MOUDGIL	9814922983	aditya@gmail.com	40	SIRHIND	PUNJAB	140406
70000004	SAHIL	KUMAR	9888059745	sahilkumar@gmail.com	17	AMRITSAR	PUNJAB	140047
70000005	HARSHIT	SAINI	9530909795	hsaini@gmail.com	47	RAMGARH	HARAYANA	140078
70000006	NAVYA	ARORA	9813452983	navya@gmail.com	67	KHANNA	PUNJAB	141401
70000007	CHITRA	KARAYAT	8427345558	chitra@gmail.com	78	CHANDIGARH	CHANDIGARH	160089
70000008	VANSH	BANSAL	7564897352	vanshbansal@gmail.com	75	SOHANA	PUNJAB	160034
70000009	SANJEEV	KUMAR	9813452966	sanjeev@gmail.com	56	MOHALI	PUNJAB	141404
70000010	RAJAT	BHARDWAJ	7685674893	rajat@gmail.com	65	PANCHKULA	HARAYANA	130106

Statement 37

SELECT * FROM CUSTOMER_DETAILS


CUSTOMER_ID FNAME LNAME PHONE_NUMBER EMAIL_ID STREET CITY STATE_NAME PINCODE
70000001 KOMAL DHANJAL 7529810009 komaldhanjal@gmail.com 4 MOHALI PUNJAB 160047
70000002 ABHINAV NANDRAJOG 6284665396 abhinav@gmail.com 10 ZIRAKPUR PUNJAB 160104
70000003 ADITYA MOUDGIL 9814922983 aditya@gmail.com 40 SIRHIND PUNJAB 140406
70000004 SAHIL KUMAR 9888059745 sahilkumar@gmail.com 17 AMRITSAR PUNJAB 140047
70000005 HARSHIT SAINI 9530909795 hsaini@gmail.com 47 RAMGARH HARAYANA 140078
70000006 NAVYA ARORA 9813452983 navya@gmail.com 67 KHANNA PUNJAB 141401
70000009 SANJEEV KUMAR 9813452966 sanjeev@gmail.com 56 MOHALI PUNJAB 141404
70000010 RAJAT BHARDWAJ 7685674893 rajat@gmail.com 65 PANCHKULA HARAYANA 130106
70000008 VANSH BANSAL 7564897352 vanshbansal@gmail.com 75 SOHANA PUNJAB 160034
70000007 CHITRA KARAYAT 8427345558 chitra@gmail.com 78 CHANDIGARH CHANDIGARH 160089

10 rows selected.

CUSTOMER_ID	FNAME	LNAME	PHONE_NUMBER	EMAIL_ID	STREET	CITY	STATE_NAME	PINCODE
70000001	KOMAL	DHANJAL	7529810009	komaldhanjal@gmail.com	4	MOHALI	PUNJAB	160047
70000002	ABHINAV	NANDRAJOG	6284665396	abhinav@gmail.com	10	ZIRAKPUR	PUNJAB	160104
70000003	ADITYA	MOUDGIL	9814922983	aditya@gmail.com	40	SIRHIND	PUNJAB	140406
70000004	SAHIL	KUMAR	9888059745	sahilkumar@gmail.com	17	AMRITSAR	PUNJAB	140047
70000005	HARSHIT	SAINI	9530909795	hsaini@gmail.com	47	RAMGARH	HARAYANA	140078
70000006	NAVYA	ARORA	9813452983	navya@gmail.com	67	KHANNA	PUNJAB	141401
70000009	SANJEEV	KUMAR	9813452966	sanjeev@gmail.com	56	MOHALI	PUNJAB	141404
70000010	RAJAT	BHARDWAJ	7685674893	rajat@gmail.com	65	PANCHKULA	HARAYANA	130106
70000008	VANSH	BANSAL	7564897352	vanshbansal@gmail.com	75	SOHANA	PUNJAB	160034
70000007	CHITRA	KARAYAT	8427345558	chitra@gmail.com	78	CHANDIGARH	CHANDIGARH	160089

Statement 38

SELECT * FROM CUSTOMER_DETAILS ORDER BY CUSTOMER_ID ASC


CUSTOMER_ID FNAME LNAME PHONE_NUMBER EMAIL_ID STREET CITY STATE_NAME PINCODE
70000001 KOMAL DHANJAL 7529810009 komaldhanjal@gmail.com 4 MOHALI PUNJAB 160047
70000002 ABHINAV NANDRAJOG 6284665396 abhinav@gmail.com 10 ZIRAKPUR PUNJAB 160104
70000003 ADITYA MOUDGIL 9814922983 aditya@gmail.com 40 SIRHIND PUNJAB 140406
70000004 SAHIL KUMAR 9888059745 sahilkumar@gmail.com 17 AMRITSAR PUNJAB 140047
70000005 HARSHIT SAINI 9530909795 hsaini@gmail.com 47 RAMGARH HARAYANA 140078
70000006 NAVYA ARORA 9813452983 navya@gmail.com 67 KHANNA PUNJAB 141401
70000007 CHITRA KARAYAT 8427345558 chitra@gmail.com 78 CHANDIGARH CHANDIGARH 160089
70000008 VANSH BANSAL 7564897352 vanshbansal@gmail.com 75 SOHANA PUNJAB 160034
70000009 SANJEEV KUMAR 9813452966 sanjeev@gmail.com 56 MOHALI PUNJAB 141404
70000010 RAJAT BHARDWAJ 7685674893 rajat@gmail.com 65 PANCHKULA HARAYANA 130106

10 rows selected.

CUSTOMER_ID	FNAME	LNAME	PHONE_NUMBER	EMAIL_ID	STREET	CITY	STATE_NAME	PINCODE
70000001	KOMAL	DHANJAL	7529810009	komaldhanjal@gmail.com	4	MOHALI	PUNJAB	160047
70000002	ABHINAV	NANDRAJOG	6284665396	abhinav@gmail.com	10	ZIRAKPUR	PUNJAB	160104
70000003	ADITYA	MOUDGIL	9814922983	aditya@gmail.com	40	SIRHIND	PUNJAB	140406
70000004	SAHIL	KUMAR	9888059745	sahilkumar@gmail.com	17	AMRITSAR	PUNJAB	140047
70000005	HARSHIT	SAINI	9530909795	hsaini@gmail.com	47	RAMGARH	HARAYANA	140078
70000006	NAVYA	ARORA	9813452983	navya@gmail.com	67	KHANNA	PUNJAB	141401
70000007	CHITRA	KARAYAT	8427345558	chitra@gmail.com	78	CHANDIGARH	CHANDIGARH	160089
70000008	VANSH	BANSAL	7564897352	vanshbansal@gmail.com	75	SOHANA	PUNJAB	160034
70000009	SANJEEV	KUMAR	9813452966	sanjeev@gmail.com	56	MOHALI	PUNJAB	141404
70000010	RAJAT	BHARDWAJ	7685674893	rajat@gmail.com	65	PANCHKULA	HARAYANA	130106

Statement 39

select * from CUSTOMER_TABLE

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 40

select * from CUSTOMER_DETAILS


CUSTOMER_ID FNAME LNAME PHONE_NUMBER EMAIL_ID STREET CITY STATE_NAME PINCODE
70000001 KOMAL DHANJAL 7529810009 komaldhanjal@gmail.com 4 MOHALI PUNJAB 160047
70000002 ABHINAV NANDRAJOG 6284665396 abhinav@gmail.com 10 ZIRAKPUR PUNJAB 160104
70000003 ADITYA MOUDGIL 9814922983 aditya@gmail.com 40 SIRHIND PUNJAB 140406
70000004 SAHIL KUMAR 9888059745 sahilkumar@gmail.com 17 AMRITSAR PUNJAB 140047
70000005 HARSHIT SAINI 9530909795 hsaini@gmail.com 47 RAMGARH HARAYANA 140078
70000006 NAVYA ARORA 9813452983 navya@gmail.com 67 KHANNA PUNJAB 141401
70000009 SANJEEV KUMAR 9813452966 sanjeev@gmail.com 56 MOHALI PUNJAB 141404
70000010 RAJAT BHARDWAJ 7685674893 rajat@gmail.com 65 PANCHKULA HARAYANA 130106
70000008 VANSH BANSAL 7564897352 vanshbansal@gmail.com 75 SOHANA PUNJAB 160034
70000007 CHITRA KARAYAT 8427345558 chitra@gmail.com 78 CHANDIGARH CHANDIGARH 160089

10 rows selected.

CUSTOMER_ID	FNAME	LNAME	PHONE_NUMBER	EMAIL_ID	STREET	CITY	STATE_NAME	PINCODE
70000001	KOMAL	DHANJAL	7529810009	komaldhanjal@gmail.com	4	MOHALI	PUNJAB	160047
70000002	ABHINAV	NANDRAJOG	6284665396	abhinav@gmail.com	10	ZIRAKPUR	PUNJAB	160104
70000003	ADITYA	MOUDGIL	9814922983	aditya@gmail.com	40	SIRHIND	PUNJAB	140406
70000004	SAHIL	KUMAR	9888059745	sahilkumar@gmail.com	17	AMRITSAR	PUNJAB	140047
70000005	HARSHIT	SAINI	9530909795	hsaini@gmail.com	47	RAMGARH	HARAYANA	140078
70000006	NAVYA	ARORA	9813452983	navya@gmail.com	67	KHANNA	PUNJAB	141401
70000009	SANJEEV	KUMAR	9813452966	sanjeev@gmail.com	56	MOHALI	PUNJAB	141404
70000010	RAJAT	BHARDWAJ	7685674893	rajat@gmail.com	65	PANCHKULA	HARAYANA	130106
70000008	VANSH	BANSAL	7564897352	vanshbansal@gmail.com	75	SOHANA	PUNJAB	160034
70000007	CHITRA	KARAYAT	8427345558	chitra@gmail.com	78	CHANDIGARH	CHANDIGARH	160089

Statement 41

CREATE TABLE DRIVER_DETAILS 
( DRIVING_LICENSE VARCHAR2(20) NOT NULL, 
CAR_REGISTERTAION VARCHAR2(20) NOT NULL, 
FNAME VARCHAR(25) NOT NULL, 
LNAME VARCHAR(25) NOT NULL, 
PHONE_NUMBER NUMBER(10) NOT NULL, 
STREET VARCHAR(30) NOT NULL, 
CITY VARCHAR(20) NOT NULL, 
STATE_NAME VARCHAR(20) NOT NULL, 
PINCODE NUMBER(6) NOT NULL, 
PRIMARY KEY (DRIVING_LICENSE) 
)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 42

DESC CUSTOMER_DETAILS

TABLE CUSTOMER_DETAILS
Column Null? Type
CUSTOMER_ID NOT NULL NUMBER(8,0)
FNAME NOT NULL VARCHAR2(25)
LNAME NOT NULL VARCHAR2(25)
PHONE_NUMBER NOT NULL NUMBER(10,0)
EMAIL_ID NOT NULL VARCHAR2(30)
STREET NOT NULL VARCHAR2(30)
CITY NOT NULL VARCHAR2(20)
STATE_NAME NOT NULL VARCHAR2(20)
PINCODE NOT NULL NUMBER(6,0)

9 rows selected.

Column	Null?	Type
CUSTOMER_ID	NOT NULL	NUMBER(8,0)
FNAME	NOT NULL	VARCHAR2(25)
LNAME	NOT NULL	VARCHAR2(25)
PHONE_NUMBER	NOT NULL	NUMBER(10,0)
EMAIL_ID	NOT NULL	VARCHAR2(30)
STREET	NOT NULL	VARCHAR2(30)
CITY	NOT NULL	VARCHAR2(20)
STATE_NAME	NOT NULL	VARCHAR2(20)
PINCODE	NOT NULL	NUMBER(6,0)

Statement 43

DESC DRIVER_DETAILS

TABLE DRIVER_DETAILS
Column Null? Type
DRIVING_LICENSE NOT NULL VARCHAR2(20)
CAR_REGISTERTAION NOT NULL VARCHAR2(20)
FNAME NOT NULL VARCHAR2(25)
LNAME NOT NULL VARCHAR2(25)
PHONE_NUMBER NOT NULL NUMBER(10,0)
STREET NOT NULL VARCHAR2(30)
CITY NOT NULL VARCHAR2(20)
STATE_NAME NOT NULL VARCHAR2(20)
PINCODE NOT NULL NUMBER(6,0)

9 rows selected.

Column	Null?	Type
DRIVING_LICENSE	NOT NULL	VARCHAR2(20)
CAR_REGISTERTAION	NOT NULL	VARCHAR2(20)
FNAME	NOT NULL	VARCHAR2(25)
LNAME	NOT NULL	VARCHAR2(25)
PHONE_NUMBER	NOT NULL	NUMBER(10,0)
STREET	NOT NULL	VARCHAR2(30)
CITY	NOT NULL	VARCHAR2(20)
STATE_NAME	NOT NULL	VARCHAR2(20)
PINCODE	NOT NULL	NUMBER(6,0)

Statement 44

INSERT INTO DRIVER_DETAILS VALUES('PB70 20190001616','PB 65 AS 2020','RAJU','KUMAR','6852314523','90','RUPNAGAR','PUNJAB')

ORA-00947: not enough values

More Details: https://docs.oracle.com/error-help/db/ora-00947

Statement 45

INSERT INTO DRIVER_DETAILS VALUES('PB70 20190001616','PB 65 AS 2020','RAJU','KUMAR',6852314523,'90','RUPNAGAR','PUNJAB',160078)

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461075) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 46

SELECT * FROM DRIVER_DETAILS


DRIVING_LICENSE CAR_REGISTERTAION FNAME LNAME PHONE_NUMBER STREET CITY STATE_NAME PINCODE
PB70 20190001616 PB 65 AS 2020 RAJU KUMAR 6852314523 90 RUPNAGAR PUNJAB 160078
CH03 19200003656 CH 01 AK 3435 KRISHAN TIWARI 9865445623 9 CHANDIGARH CHANDIGARH 104952
PB80 20190002345 PB 65 BD 2010 ROHAN SHARMA 7529876542 19 MOHALI PUNJAB 160024
PB63 20198500003 PB 70 AB 6065 MOHAN BANSAL 8360534152 14 ZIRAKPUR PUNJAB 160049
CH06 20209800345 CH 01 BS 3286 RAM SHAM 9467876542 76 PANCHKULA HARAYANA 140014
HR06 20179802547 HR 03 AK 3215 AVTAR SINGH 6285642315 25 PANCHKULA HARAYANA 150023
PB60 10209845635 PB 06 CD 9332 SHEETAL ARORA 6547839872 6 AMBALA HARAYANA 165214
PB60 23459845635 CH 04 FD 4994 JAGJEET SINGH 9876543567 87 AMRITSAR PUNJAB 170145
HR07 19879844582 HR 01 VS 8585 GURTEZ BAHADUR 8452196523 12 CHANDIGARH CHANDIGARH 136014
PB50 10003434635 PB 09 UL 8765 GABRU SINGH 6543783567 22 PATIALA PUNJAB 170049

10 rows selected.

DRIVING_LICENSE	CAR_REGISTERTAION	FNAME	LNAME	PHONE_NUMBER	STREET	CITY	STATE_NAME	PINCODE
PB70 20190001616	PB 65 AS 2020	RAJU	KUMAR	6852314523	90	RUPNAGAR	PUNJAB	160078
CH03 19200003656	CH 01 AK 3435	KRISHAN	TIWARI	9865445623	9	CHANDIGARH	CHANDIGARH	104952
PB80 20190002345	PB 65 BD 2010	ROHAN	SHARMA	7529876542	19	MOHALI	PUNJAB	160024
PB63 20198500003	PB 70 AB 6065	MOHAN	BANSAL	8360534152	14	ZIRAKPUR	PUNJAB	160049
CH06 20209800345	CH 01 BS 3286	RAM	SHAM	9467876542	76	PANCHKULA	HARAYANA	140014
HR06 20179802547	HR 03 AK 3215	AVTAR	SINGH	6285642315	25	PANCHKULA	HARAYANA	150023
PB60 10209845635	PB 06 CD 9332	SHEETAL	ARORA	6547839872	6	AMBALA	HARAYANA	165214
PB60 23459845635	CH 04 FD 4994	JAGJEET	SINGH	9876543567	87	AMRITSAR	PUNJAB	170145
HR07 19879844582	HR 01 VS 8585	GURTEZ	BAHADUR	8452196523	12	CHANDIGARH	CHANDIGARH	136014
PB50 10003434635	PB 09 UL 8765	GABRU	SINGH	6543783567	22	PATIALA	PUNJAB	170049

Statement 47

INSERT INTO DRIVER_DETAILS VALUES('CH03 19200003656','CH 01 AK 3435','KRISHAN','TIWARI',9865445623,'9','CHANDIGARH','CHANDIGARH',104952)

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461075) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 48

INSERT INTO DRIVER_DETAILS VALUES('PB80 20190002345','PB 65 BD 2010','ROHAN','SHARMA',7529876542,'19','MOHALI','PUNJAB',160024)

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461075) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 49

INSERT INTO DRIVER_DETAILS VALUES('PB63 20198500003','PB 70 AB 6065','MOHAN','BANSAL',8360534152,'14','ZIRAKPUR','PUNJAB',160049)

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461075) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 50

INSERT INTO DRIVER_DETAILS VALUES('CH06 20209800345','CH 01 BS 3286','RAM','SHAM',9467876542,'76','PANCHKULA','HARAYANA',140014)

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461075) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 51

INSERT INTO DRIVER_DETAILS VALUES('HR06 20179802547','HR 03 AK 3215','AVTAR','SINGH',6285642315,'25','PANCHKULA','HARAYANA',150023)

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461075) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 52

SELECT * FROM DRIVER_DETAILS


DRIVING_LICENSE CAR_REGISTERTAION FNAME LNAME PHONE_NUMBER STREET CITY STATE_NAME PINCODE
PB70 20190001616 PB 65 AS 2020 RAJU KUMAR 6852314523 90 RUPNAGAR PUNJAB 160078
CH03 19200003656 CH 01 AK 3435 KRISHAN TIWARI 9865445623 9 CHANDIGARH CHANDIGARH 104952
PB80 20190002345 PB 65 BD 2010 ROHAN SHARMA 7529876542 19 MOHALI PUNJAB 160024
PB63 20198500003 PB 70 AB 6065 MOHAN BANSAL 8360534152 14 ZIRAKPUR PUNJAB 160049
CH06 20209800345 CH 01 BS 3286 RAM SHAM 9467876542 76 PANCHKULA HARAYANA 140014
HR06 20179802547 HR 03 AK 3215 AVTAR SINGH 6285642315 25 PANCHKULA HARAYANA 150023
PB60 10209845635 PB 06 CD 9332 SHEETAL ARORA 6547839872 6 AMBALA HARAYANA 165214
PB60 23459845635 CH 04 FD 4994 JAGJEET SINGH 9876543567 87 AMRITSAR PUNJAB 170145
HR07 19879844582 HR 01 VS 8585 GURTEZ BAHADUR 8452196523 12 CHANDIGARH CHANDIGARH 136014
PB50 10003434635 PB 09 UL 8765 GABRU SINGH 6543783567 22 PATIALA PUNJAB 170049

10 rows selected.

DRIVING_LICENSE	CAR_REGISTERTAION	FNAME	LNAME	PHONE_NUMBER	STREET	CITY	STATE_NAME	PINCODE
PB70 20190001616	PB 65 AS 2020	RAJU	KUMAR	6852314523	90	RUPNAGAR	PUNJAB	160078
CH03 19200003656	CH 01 AK 3435	KRISHAN	TIWARI	9865445623	9	CHANDIGARH	CHANDIGARH	104952
PB80 20190002345	PB 65 BD 2010	ROHAN	SHARMA	7529876542	19	MOHALI	PUNJAB	160024
PB63 20198500003	PB 70 AB 6065	MOHAN	BANSAL	8360534152	14	ZIRAKPUR	PUNJAB	160049
CH06 20209800345	CH 01 BS 3286	RAM	SHAM	9467876542	76	PANCHKULA	HARAYANA	140014
HR06 20179802547	HR 03 AK 3215	AVTAR	SINGH	6285642315	25	PANCHKULA	HARAYANA	150023
PB60 10209845635	PB 06 CD 9332	SHEETAL	ARORA	6547839872	6	AMBALA	HARAYANA	165214
PB60 23459845635	CH 04 FD 4994	JAGJEET	SINGH	9876543567	87	AMRITSAR	PUNJAB	170145
HR07 19879844582	HR 01 VS 8585	GURTEZ	BAHADUR	8452196523	12	CHANDIGARH	CHANDIGARH	136014
PB50 10003434635	PB 09 UL 8765	GABRU	SINGH	6543783567	22	PATIALA	PUNJAB	170049

Statement 53

INSERT INTO DRIVER_DETAILS VALUES('PB60 10209845635','PB 06 CD 9332','SHEETAL','ARORA',6547839872,'6','AMBALA','HARAYANA',165214)

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461075) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 54

INSERT INTO DRIVER_DETAILS VALUES('PB60 23459845635','CH 04 FD 4994','JAGJEET','SINGH',9876543567,'87','AMRITSAR','PUNJAB',170145)

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461075) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 55

SELECT * FROM DRIVER_DETAILS


DRIVING_LICENSE CAR_REGISTERTAION FNAME LNAME PHONE_NUMBER STREET CITY STATE_NAME PINCODE
PB70 20190001616 PB 65 AS 2020 RAJU KUMAR 6852314523 90 RUPNAGAR PUNJAB 160078
CH03 19200003656 CH 01 AK 3435 KRISHAN TIWARI 9865445623 9 CHANDIGARH CHANDIGARH 104952
PB80 20190002345 PB 65 BD 2010 ROHAN SHARMA 7529876542 19 MOHALI PUNJAB 160024
PB63 20198500003 PB 70 AB 6065 MOHAN BANSAL 8360534152 14 ZIRAKPUR PUNJAB 160049
CH06 20209800345 CH 01 BS 3286 RAM SHAM 9467876542 76 PANCHKULA HARAYANA 140014
HR06 20179802547 HR 03 AK 3215 AVTAR SINGH 6285642315 25 PANCHKULA HARAYANA 150023
PB60 10209845635 PB 06 CD 9332 SHEETAL ARORA 6547839872 6 AMBALA HARAYANA 165214
PB60 23459845635 CH 04 FD 4994 JAGJEET SINGH 9876543567 87 AMRITSAR PUNJAB 170145
HR07 19879844582 HR 01 VS 8585 GURTEZ BAHADUR 8452196523 12 CHANDIGARH CHANDIGARH 136014
PB50 10003434635 PB 09 UL 8765 GABRU SINGH 6543783567 22 PATIALA PUNJAB 170049

10 rows selected.

DRIVING_LICENSE	CAR_REGISTERTAION	FNAME	LNAME	PHONE_NUMBER	STREET	CITY	STATE_NAME	PINCODE
PB70 20190001616	PB 65 AS 2020	RAJU	KUMAR	6852314523	90	RUPNAGAR	PUNJAB	160078
CH03 19200003656	CH 01 AK 3435	KRISHAN	TIWARI	9865445623	9	CHANDIGARH	CHANDIGARH	104952
PB80 20190002345	PB 65 BD 2010	ROHAN	SHARMA	7529876542	19	MOHALI	PUNJAB	160024
PB63 20198500003	PB 70 AB 6065	MOHAN	BANSAL	8360534152	14	ZIRAKPUR	PUNJAB	160049
CH06 20209800345	CH 01 BS 3286	RAM	SHAM	9467876542	76	PANCHKULA	HARAYANA	140014
HR06 20179802547	HR 03 AK 3215	AVTAR	SINGH	6285642315	25	PANCHKULA	HARAYANA	150023
PB60 10209845635	PB 06 CD 9332	SHEETAL	ARORA	6547839872	6	AMBALA	HARAYANA	165214
PB60 23459845635	CH 04 FD 4994	JAGJEET	SINGH	9876543567	87	AMRITSAR	PUNJAB	170145
HR07 19879844582	HR 01 VS 8585	GURTEZ	BAHADUR	8452196523	12	CHANDIGARH	CHANDIGARH	136014
PB50 10003434635	PB 09 UL 8765	GABRU	SINGH	6543783567	22	PATIALA	PUNJAB	170049

Statement 56

INSERT INTO DRIVER_DETAILS VALUES('HR07 19879844582','HR 01 VS 8585','GURTEZ','BAHADUR',8452196523,'12','CHANDIGARH','CHANDIGARH',136014)

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461075) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 57

INSERT INTO DRIVER_DETAILS VALUES('PB50 10003434635','PB 09 UL 8765','GABRU','SINGH',6543783567,'22','PATIALA','PUNJAB',170049)

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461075) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 58

SELECT * FROM DRIVER_DETAILS


DRIVING_LICENSE CAR_REGISTERTAION FNAME LNAME PHONE_NUMBER STREET CITY STATE_NAME PINCODE
PB70 20190001616 PB 65 AS 2020 RAJU KUMAR 6852314523 90 RUPNAGAR PUNJAB 160078
CH03 19200003656 CH 01 AK 3435 KRISHAN TIWARI 9865445623 9 CHANDIGARH CHANDIGARH 104952
PB80 20190002345 PB 65 BD 2010 ROHAN SHARMA 7529876542 19 MOHALI PUNJAB 160024
PB63 20198500003 PB 70 AB 6065 MOHAN BANSAL 8360534152 14 ZIRAKPUR PUNJAB 160049
CH06 20209800345 CH 01 BS 3286 RAM SHAM 9467876542 76 PANCHKULA HARAYANA 140014
HR06 20179802547 HR 03 AK 3215 AVTAR SINGH 6285642315 25 PANCHKULA HARAYANA 150023
PB60 10209845635 PB 06 CD 9332 SHEETAL ARORA 6547839872 6 AMBALA HARAYANA 165214
PB60 23459845635 CH 04 FD 4994 JAGJEET SINGH 9876543567 87 AMRITSAR PUNJAB 170145
HR07 19879844582 HR 01 VS 8585 GURTEZ BAHADUR 8452196523 12 CHANDIGARH CHANDIGARH 136014
PB50 10003434635 PB 09 UL 8765 GABRU SINGH 6543783567 22 PATIALA PUNJAB 170049

10 rows selected.

DRIVING_LICENSE	CAR_REGISTERTAION	FNAME	LNAME	PHONE_NUMBER	STREET	CITY	STATE_NAME	PINCODE
PB70 20190001616	PB 65 AS 2020	RAJU	KUMAR	6852314523	90	RUPNAGAR	PUNJAB	160078
CH03 19200003656	CH 01 AK 3435	KRISHAN	TIWARI	9865445623	9	CHANDIGARH	CHANDIGARH	104952
PB80 20190002345	PB 65 BD 2010	ROHAN	SHARMA	7529876542	19	MOHALI	PUNJAB	160024
PB63 20198500003	PB 70 AB 6065	MOHAN	BANSAL	8360534152	14	ZIRAKPUR	PUNJAB	160049
CH06 20209800345	CH 01 BS 3286	RAM	SHAM	9467876542	76	PANCHKULA	HARAYANA	140014
HR06 20179802547	HR 03 AK 3215	AVTAR	SINGH	6285642315	25	PANCHKULA	HARAYANA	150023
PB60 10209845635	PB 06 CD 9332	SHEETAL	ARORA	6547839872	6	AMBALA	HARAYANA	165214
PB60 23459845635	CH 04 FD 4994	JAGJEET	SINGH	9876543567	87	AMRITSAR	PUNJAB	170145
HR07 19879844582	HR 01 VS 8585	GURTEZ	BAHADUR	8452196523	12	CHANDIGARH	CHANDIGARH	136014
PB50 10003434635	PB 09 UL 8765	GABRU	SINGH	6543783567	22	PATIALA	PUNJAB	170049

Statement 59

CREATE TABLE CAR_MODEL(CAR_REGISTERATION VARCHAR2(20) NOT NULL,MODEL_NAME VARCHAR2(15) NOT NULL,MODEL_YEAR NUMBER(4) NOT NULL,FUEL_TYPE VARCHAR2(10) NOT NULL,CAR_TYPE VARCHAR2(10),PRIMARY KEY(CAR_REGISTERATION))

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 60

DESC CAR_MODEL

TABLE CAR_MODEL
Column Null? Type
CAR_REGISTERATION NOT NULL VARCHAR2(20)
MODEL_NAME NOT NULL VARCHAR2(15)
MODEL_YEAR NOT NULL NUMBER(4,0)
FUEL_TYPE NOT NULL VARCHAR2(10)
CAR_TYPE  - VARCHAR2(10)

5 rows selected.

Column	Null?	Type
CAR_REGISTERATION	NOT NULL	VARCHAR2(20)
MODEL_NAME	NOT NULL	VARCHAR2(15)
MODEL_YEAR	NOT NULL	NUMBER(4,0)
FUEL_TYPE	NOT NULL	VARCHAR2(10)
CAR_TYPE	-	VARCHAR2(10)

Statement 61

INSERT INTO CAR_MODEL VALUES('CH 01 AK 3435','SWIFT','2018','PETROL','HATCHBACK')

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461081) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 62

INSERT INTO CAR_MODEL VALUES('PB 65 BD 2010','DUSTER','2018','DIESEL','SUV')

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461081) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 63

INSERT INTO CAR_MODEL VALUES('CH 01 BS 3286','SWIFT DZIRE','2015','CNG','SEDAN')

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461081) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 64

INSERT INTO CAR_MODEL VALUES('HR 03 AK 3215','ALTO','2011','PETROL','HATCHBACK')

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461081) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 65

INSERT INTO CAR_MODEL VALUES('PB 06 CD 9332','CELERIO','2017','PETROL','HATCHBACK')

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461081) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 66

INSERT INTO CAR_MODEL VALUES('HR 01 VS 8585','VERNA','2020','DIESEL','SEDAN')

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461081) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 67

INSERT INTO CAR_MODEL VALUES('PB 09 UL 8765','i20','2014','CNG','HATCHBACK')

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461081) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 68

INSERT INTO CAR_MODEL VALUES('PB 65 AS 2020','INDIGO','2009','DIESEL','SEDAN')

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461081) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 69

INSERT INTO CAR_MODEL VALUES('PB 70 AB 6065','INNOVA','2016','DIESEL','SUV')

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461081) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 70

INSERT INTO CAR_MODEL VALUES('CH 04 FD 4994','TAVERA','2013','DIESEL','SUV')

ORA-00001: unique constraint (SQL_WNYUOGFDNFPGXCXEAEZCKQLHP.SYS_C0070461081) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-00001

Statement 71

SELECT * FROM CAR_MODEL


CAR_REGISTERATION MODEL_NAME MODEL_YEAR FUEL_TYPE CAR_TYPE
CH 01 AK 3435 SWIFT 2018 PETROL HATCHBACK
PB 65 BD 2010 DUSTER 2018 DIESEL SUV
CH 01 BS 3286 SWIFT DZIRE 2015 CNG SEDAN
HR 03 AK 3215 ALTO 2011 PETROL HATCHBACK
PB 06 CD 9332 CELERIO 2017 PETROL HATCHBACK
HR 01 VS 8585 VERNA 2020 DIESEL SEDAN
PB 09 UL 8765 i20 2014 CNG HATCHBACK
PB 65 AS 2020 INDIGO 2009 DIESEL SEDAN
PB 70 AB 6065 INNOVA 2016 DIESEL SUV
CH 04 FD 4994 TAVERA 2013 DIESEL SUV

10 rows selected.

CAR_REGISTERATION	MODEL_NAME	MODEL_YEAR	FUEL_TYPE	CAR_TYPE
CH 01 AK 3435	SWIFT	2018	PETROL	HATCHBACK
PB 65 BD 2010	DUSTER	2018	DIESEL	SUV
CH 01 BS 3286	SWIFT DZIRE	2015	CNG	SEDAN
HR 03 AK 3215	ALTO	2011	PETROL	HATCHBACK
PB 06 CD 9332	CELERIO	2017	PETROL	HATCHBACK
HR 01 VS 8585	VERNA	2020	DIESEL	SEDAN
PB 09 UL 8765	i20	2014	CNG	HATCHBACK
PB 65 AS 2020	INDIGO	2009	DIESEL	SEDAN
PB 70 AB 6065	INNOVA	2016	DIESEL	SUV
CH 04 FD 4994	TAVERA	2013	DIESEL	SUV

Statement 72

desc CAR_MODEL

TABLE CAR_MODEL
Column Null? Type
CAR_REGISTERATION NOT NULL VARCHAR2(20)
MODEL_NAME NOT NULL VARCHAR2(15)
MODEL_YEAR NOT NULL NUMBER(4,0)
FUEL_TYPE NOT NULL VARCHAR2(10)
CAR_TYPE  - VARCHAR2(10)

5 rows selected.

Column	Null?	Type
CAR_REGISTERATION	NOT NULL	VARCHAR2(20)
MODEL_NAME	NOT NULL	VARCHAR2(15)
MODEL_YEAR	NOT NULL	NUMBER(4,0)
FUEL_TYPE	NOT NULL	VARCHAR2(10)
CAR_TYPE	-	VARCHAR2(10)

Statement 73

SELECT * FROM CAR_MODEL


CAR_REGISTERATION MODEL_NAME MODEL_YEAR FUEL_TYPE CAR_TYPE
CH 01 AK 3435 SWIFT 2018 PETROL HATCHBACK
PB 65 BD 2010 DUSTER 2018 DIESEL SUV
CH 01 BS 3286 SWIFT DZIRE 2015 CNG SEDAN
HR 03 AK 3215 ALTO 2011 PETROL HATCHBACK
PB 06 CD 9332 CELERIO 2017 PETROL HATCHBACK
HR 01 VS 8585 VERNA 2020 DIESEL SEDAN
PB 09 UL 8765 i20 2014 CNG HATCHBACK
PB 65 AS 2020 INDIGO 2009 DIESEL SEDAN
PB 70 AB 6065 INNOVA 2016 DIESEL SUV
CH 04 FD 4994 TAVERA 2013 DIESEL SUV

10 rows selected.

CAR_REGISTERATION	MODEL_NAME	MODEL_YEAR	FUEL_TYPE	CAR_TYPE
CH 01 AK 3435	SWIFT	2018	PETROL	HATCHBACK
PB 65 BD 2010	DUSTER	2018	DIESEL	SUV
CH 01 BS 3286	SWIFT DZIRE	2015	CNG	SEDAN
HR 03 AK 3215	ALTO	2011	PETROL	HATCHBACK
PB 06 CD 9332	CELERIO	2017	PETROL	HATCHBACK
HR 01 VS 8585	VERNA	2020	DIESEL	SEDAN
PB 09 UL 8765	i20	2014	CNG	HATCHBACK
PB 65 AS 2020	INDIGO	2009	DIESEL	SEDAN
PB 70 AB 6065	INNOVA	2016	DIESEL	SUV
CH 04 FD 4994	TAVERA	2013	DIESEL	SUV

Statement 74

CREATE TABLE BOOKING_DETAILS(BOOKING_ID VARCHAR2(15) NOT NULL,BOOKING_DATE VARCHAR2(15) NOT NULL,BOOKING_TIME VARCHAR2(15) NOT NULL,PICKUP_LOCATION VARCHAR2(15) NOT NULL,DROP_LOCATION VARCAHR2(15) NOT NULL,CAR_TYPE VARCHAR2(10) NOT NULL,CAR_REGISTERATION VARCHAR2(15) NOT NULL,PRIMARY KEY (BOOKING_ID))

ORA-00907: missing right parenthesis

More Details: https://docs.oracle.com/error-help/db/ora-00907

Statement 75

CREATE TABLE BOOKING_DETAILS(BOOKING_ID VARCHAR(15) NOT NULL,BOOKING_DATE VARCHAR(15) NOT NULL,BOOKING_TIME VARCHAR(15) NOT NULL,PICKUP_LOCATION VARCHAR(15) NOT NULL,DROP_LOCATION VARCHAR(15) NOT NULL,CAR_TYPE VARCHAR(10) NOT NULL,CAR_REGISTERATION VARCHAR(15) NOT NULL,PRIMARY KEY (BOOKING_ID))

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 76

INSERT INTO BOOKING_DETAILS VALUES('GLKMNT325','15-2-2021','4:00 P.M.','DHAKOLI','PANCHKULA','HATCHBACK','CH 01 AK 3435')

1 row(s) inserted.

Statement 77

INSERT INTO BOOKING_DETAILS VALUES('TYRFGD781','17-8-2021','9:00 P.M.','RAJPURA','PHASE-6','SUV','PB 65 BD 2010')

1 row(s) inserted.

Statement 78

INSERT INTO BOOKING_DETAILS VALUES('GURDVT985','10-08-2020','11:32 P.M.','MOHALI','SECTOR-17,CHD','SEDAN','CH 01 BS 3286')

1 row(s) inserted.

Statement 79

INSERT INTO BOOKING_DETAILS VALUES('HRSCJT790','03-09-2018','8:14 P.M.','DERABASSI','RAJPURA','HATCHBACK','HR 03 AK 3215')

1 row(s) inserted.

Statement 80

INSERT INTO BOOKING_DETAILS VALUES('GTJDYU864','01-1-2020','4:08 P.M.','PANCHKULA','BALTANA','HATCHBACK','PB 06 CD 9332')

1 row(s) inserted.

Statement 81

INSERT INTO BOOKING_DETAILS VALUES('KTECHY865','18-04-2021','5:00 P.M.','DHAKOLI','SECTOR-22,CHD','SEDAN','HR 01 VS 8585')

1 row(s) inserted.

Statement 82

INSERT INTO BOOKING_DETAILS VALUES('SRHBUG794','15-11-2021','6:11 P.M.','SECTOR-22,CHD','SECTOR-15,PKL','HATCHBACK','PB 09 UL 8765')

1 row(s) inserted.

Statement 83

INSERT INTO BOOKING_DETAILS VALUES('JEXVUY478','24-10-2021','11:22 P.M.','NEW CHANDIGARH','RAMGARH','SEDAN','PB 65 AS 2020')

1 row(s) inserted.

Statement 84

INSERT INTO BOOKING_DETAILS VALUES('HTDVYR799','05-12-2020','3:17 P.M.','SECTOR-33,CHD','SECTOR-13,PKL','SUV','PB 70 AB 6065')

1 row(s) inserted.

Statement 85

INSERT INTO BOOKING_DETAILS VALUES('GYJNGY890','10-51-2021','9:08 P.M.','AEROCITY','PINJORE','SUV','CH 04 FD 4994')

1 row(s) inserted.

Statement 86

SELECT * FROM BOOKING_DETAILS


BOOKING_ID BOOKING_DATE BOOKING_TIME PICKUP_LOCATION DROP_LOCATION CAR_TYPE CAR_REGISTERATION
GLKMNT325 15-2-2021 4:00 P.M. DHAKOLI PANCHKULA HATCHBACK CH 01 AK 3435
TYRFGD781 17-8-2021 9:00 P.M. RAJPURA PHASE-6 SUV PB 65 BD 2010
GURDVT985 10-08-2020 11:32 P.M. MOHALI SECTOR-17,CHD SEDAN CH 01 BS 3286
HRSCJT790 03-09-2018 8:14 P.M. DERABASSI RAJPURA HATCHBACK HR 03 AK 3215
GTJDYU864 01-1-2020 4:08 P.M. PANCHKULA BALTANA HATCHBACK PB 06 CD 9332
KTECHY865 18-04-2021 5:00 P.M. DHAKOLI SECTOR-22,CHD SEDAN HR 01 VS 8585
SRHBUG794 15-11-2021 6:11 P.M. SECTOR-22,CHD SECTOR-15,PKL HATCHBACK PB 09 UL 8765
JEXVUY478 24-10-2021 11:22 P.M. NEW CHANDIGARH RAMGARH SEDAN PB 65 AS 2020
HTDVYR799 05-12-2020 3:17 P.M. SECTOR-33,CHD SECTOR-13,PKL SUV PB 70 AB 6065
GYJNGY890 10-51-2021 9:08 P.M. AEROCITY PINJORE SUV CH 04 FD 4994

10 rows selected.

BOOKING_ID	BOOKING_DATE	BOOKING_TIME	PICKUP_LOCATION	DROP_LOCATION	CAR_TYPE	CAR_REGISTERATION
GLKMNT325	15-2-2021	4:00 P.M.	DHAKOLI	PANCHKULA	HATCHBACK	CH 01 AK 3435
TYRFGD781	17-8-2021	9:00 P.M.	RAJPURA	PHASE-6	SUV	PB 65 BD 2010
GURDVT985	10-08-2020	11:32 P.M.	MOHALI	SECTOR-17,CHD	SEDAN	CH 01 BS 3286
HRSCJT790	03-09-2018	8:14 P.M.	DERABASSI	RAJPURA	HATCHBACK	HR 03 AK 3215
GTJDYU864	01-1-2020	4:08 P.M.	PANCHKULA	BALTANA	HATCHBACK	PB 06 CD 9332
KTECHY865	18-04-2021	5:00 P.M.	DHAKOLI	SECTOR-22,CHD	SEDAN	HR 01 VS 8585
SRHBUG794	15-11-2021	6:11 P.M.	SECTOR-22,CHD	SECTOR-15,PKL	HATCHBACK	PB 09 UL 8765
JEXVUY478	24-10-2021	11:22 P.M.	NEW CHANDIGARH	RAMGARH	SEDAN	PB 65 AS 2020
HTDVYR799	05-12-2020	3:17 P.M.	SECTOR-33,CHD	SECTOR-13,PKL	SUV	PB 70 AB 6065
GYJNGY890	10-51-2021	9:08 P.M.	AEROCITY	PINJORE	SUV	CH 04 FD 4994

F.A.4. DBMS

Additional Information