this is the code i run in sql developer CREATE TABLE MARKETING_CAMPAIGN( MACampID int,
this is the code i run in sql developer
CREATE TABLE MARKETING_CAMPAIGN(
MACampID int,
MACampName varchar(30) not null,
MACampDescr varchar(100) not null,
DiscountType varchar(100) not null,
MACampStartDate char(10) not null,
MACampEndDate char(10) not null,
PRIMARY KEY (MACampID)
)
INSERT INTO MARKETING_CAMPAIGNVALUES (1111,'discount','This is discount', 'discount type1' ,'12-02-2021', '02-22-2022')
SELECT * FROM dual;
----------
Error starting at line : 1 in command -
CREATE TABLE MARKETING_CAMPAIGN(
MACampID int,
MACampName varchar(30) not null,
MACampDescr varchar(100) not null,
DiscountType varchar(100) not null,
MACampStartDate char(10) not null,
MACampEndDate char(10) not null,
PRIMARY KEY (MACampID)
)
INSERT INTO MARKETING_CAMPAIGNVALUES (1111, 'discount','This is discount', 'discount type1' ,'12-02-2021', '02-22-2022')
SELECT * FROM dual
Error report -
ORA-00922: missing or invalid option
00922. 00000 - "missing or invalid option"
*Cause:
*Action:
whats this error for ?
Step by step
Solved in 2 steps with 2 images
