My SQL

View All Public Scripts Login to Run Script

Script Name My SQL
Visibility Unlisted - anyone with the share link can access
Description Index Match Oracle SQL Ask: 2 tables related created
Area SQL General / SQL Query
Contributor mary.yan@experianinteractive.com
Created Monday January 14, 2019

Statement 1

CREATE TABLE table_1 
(cid VARCHAR(25), 
 cname varchar(25), 
 age varchar(25), 
 height varchar(25) 
 ) 
  
 INSERT INTO table_1 
 VALUES  
 ("001","Mary", "E40", "E22" 
 "002", "Cat", "E22", "E40") 
  
 SELECT * FROM table_1

ORA-00922: missing or invalid option

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

Statement 2

CREATE TABLE table_1 
(cid VARCHAR(25), 
 cname varchar(25), 
 age varchar(25), 
 height varchar(25) 
 )

Table created.

Statement 3

 INSERT INTO table_1 
 VALUES  
 ("001","Mary", "E40", "E22" 
 "002", "Cat", "E22", "E40")

ORA-00917: missing comma

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

Statement 4

 INSERT INTO table_1 
 VALUES  
 ("001", "Mary", "E40", "E22"), 
( "002", "Cat", "E22", "E40")

ORA-00933: SQL command not properly ended

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

Statement 5

 INSERT INTO table_1 
 VALUES  
 ("001", "Mary", "E40", "E22"), 
( "002", "Cat", "E22", "E40")

ORA-00933: SQL command not properly ended

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

Statement 6

 INSERT INTO table_1 
 VALUES  
 ('001', 'Mary', 'E40', 'E22'), 
 ('002', 'Cat', 'E22', 'E40')

ORA-00933: SQL command not properly ended

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

Statement 7

 INSERT INTO table_1 
 VALUES  
 ('001', 'Mary', 'E40', 'E22'), 
 ('002', 'Cat', 'E22', 'E40')

ORA-00933: SQL command not properly ended

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

Statement 8

INSERT INTO table_1 
VALUES ('001', 'Mary', 'E40', 'E22'), 
 ('002', 'Cat', 'E22', 'E40')

ORA-00933: SQL command not properly ended

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

Statement 9

INSERT INTO table_1 
VALUES ('001', 'Mary', 'E40', 'E22'), ('002', 'Cat', 'E22', 'E40')

ORA-00933: SQL command not properly ended

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

Statement 10

INSERT INTO table_1 
VALUES ('001', 'Mary', 'E40', 'E22'), ('002', 'Cat', 'E22', 'E40')

ORA-00933: SQL command not properly ended

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

Statement 11

INSERT INTO table_1 
VALUES ('001', 'Mary', 'E40', 'E22'), ('002', 'Cat', 'E22', 'E40')

ORA-00933: SQL command not properly ended

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

Statement 12

INSERT INTO table_1 
VALUES ('001', 'Mary', 'E40', 'E22'), ('002', 'Cat', 'E22', 'E40')

ORA-00933: SQL command not properly ended

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

Statement 13

INSERT INTO table_1 
VALUES ('001', 'Mary', 'E40', 'E22'), ('002', 'Cat', 'E22', 'E40')

ORA-00933: SQL command not properly ended

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

Statement 14

INSERT INTO table_1 
VALUES ('001', 'Mary', 'E40', 'E22')

1 row(s) inserted.

Statement 15

INSERT INTO table_1 
VALUES ('002', 'Cat', 'E22', 'E40')

1 row(s) inserted.

Statement 16

INSERT INTO table_1 
VALUES ('002', 'Cat', 'E22', 'E40')

1 row(s) inserted.

Statement 17

 SELECT * FROM table_1


CID CNAME AGE HEIGHT
001 Mary E40 E22
002 Cat E22 E40
002 Cat E22 E40

3 rows selected.

Statement 18
```
DROP TABLE table_1
```
```
Table dropped.
```

CID	CNAME	AGE	HEIGHT
001	Mary	E40	E22
002	Cat	E22	E40
002	Cat	E22	E40

Statement 19

CREATE TABLE table_1 
(cid VARCHAR(25), 
 cname varchar(25), 
 age varchar(25), 
 height varchar(25) 
 ) 
  
INSERT INTO table_1 
VALUES ('001', 'Mary', 'E40', 'E22'),('002', 'Cat', 'E22', 'E40')

ORA-00922: missing or invalid option

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

Statement 20

CREATE TABLE table_1 
(cid VARCHAR(25), 
 cname varchar(25), 
 age varchar(25), 
 height varchar(25) 
 )

Table created.

Statement 21

INSERT INTO table_1 
VALUES ('001', 'Mary', 'E40', 'E22'),('002', 'Cat', 'E22', 'E40')

ORA-00933: SQL command not properly ended

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

Statement 22

INSERT ALL 
  INTO table_1 VALUES ('001', 'Mary', 'E40', 'E22') 
  INTO table_1 VALUES ('002', 'Cat', 'E22', 'E40')

ORA-00928: missing SELECT keyword

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

Statement 23

INSERT ALL 
  INTO table_1 (cid, cname, age, height) VALUES ('001', 'Mary', 'E40', 'E22') 
  INTO table_1 (cid, cname, age, height) VALUES ('002', 'Cat', 'E22', 'E40')

ORA-00928: missing SELECT keyword

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

Statement 24

INSERT ALL 
  INTO table_1 (cid, cname, age, height) VALUES ('001', 'Mary', 'E40', 'E22') 
  INTO table_1 (cid, cname, age, height) VALUES ('002', 'Cat', 'E22', 'E40')

ORA-00928: missing SELECT keyword

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

Statement 25

INSERT ALL 
  INTO table_1 (cid, cname, age, height) VALUES ('001', 'Mary', 'E40', 'E22') 
  INTO table_1 (cid, cname, age, height) VALUES ('002', 'Cat', 'E22', 'E40')

ORA-00928: missing SELECT keyword

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

Statement 26

INSERT INTO table_1 (cid, cname, age, height) VALUES ('001', 'Mary', 'E40', 'E22') 
INSERT INTO table_1 (cid, cname, age, height) VALUES ('002', 'Cat', 'E22', 'E40')

ORA-00905: missing keyword

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

Statement 27

INSERT INTO table_1 VALUES ('001', 'Mary', 'E40', 'E22')

1 row(s) inserted.

Statement 28

INSERT INTO table_1 VALUES ('002', 'Cat', 'E22', 'E40')

1 row(s) inserted.

Statement 29

SELECT * FROM table_1


CID CNAME AGE HEIGHT
001 Mary E40 E22
002 Cat E22 E40

2 rows selected.

CID	CNAME	AGE	HEIGHT
001	Mary	E40	E22
002	Cat	E22	E40

Statement 30

CREATE TABLE table_2 
(dfield VARCHAR(25), 
 code varchar(25), 
 meaning varchar(25) 
 )

Table created.

Statement 31

INSERT INTO table_2 VALUES ('Age','E40','40 years old') 
INSERT INTO table_2 VALUES ('Age', 'E22', '22 years old')  
INSERT INTO table_2 VALUES ('Height', 'E22', '5"2') 
INSERT INTO table_2 VALUES ('Height', 'E40', '5"4')

ORA-00905: missing keyword

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

Statement 32

INSERT INTO table_2 VALUES ('Height', 'E22', '5"2')

1 row(s) inserted.

Statement 33

INSERT INTO table_2 VALUES ('Age','E40','40 years old') 
INSERT INTO table_2 VALUES ('Age', 'E22', '22 years old')

ORA-00905: missing keyword

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

Statement 34

INSERT INTO table_2 VALUES ('Age','E40','40 years old')

1 row(s) inserted.

Statement 35

INSERT INTO table_2 VALUES ('Age', 'E22', '22 years old')

1 row(s) inserted.

Statement 36

INSERT INTO table_2 VALUES ('Height', 'E40', '5"4')

1 row(s) inserted.

Statement 37

SELECT * FROM table_2


DFIELD CODE MEANING
Height E22 5"2
Age E40 40 years old
Age E22 22 years old
Height E40 5"4

4 rows selected.

DFIELD	CODE	MEANING
Height	E22	5"2
Age	E40	40 years old
Age	E22	22 years old
Height	E40	5"4

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database