Question

What would happen when a null value would be attempted to load into a required field?

Answer 1

Answer:

YOUR ANS WILL BE LIKE THIS

REATE TABLE pledge

(

   pledge_ID            NUMBER NOT NULL ,

   pledge_endDate       DATE NULL ,

   pledge_startDate     DATE NULL  ,

   pledge_amount        DECIMAL(9,2) NULL  CONSTRAINT  Currency_1322638346 CHECK (pledge_amount >= 0),

   artist_userID        NUMBER NOT NULL,

   follower_userID      NUMBER NOT NULL,  

CONSTRAINT  XPKPledge PRIMARY KEY (pledge_ID),

CONSTRAINT gets FOREIGN KEY (artist_userID) REFERENCES ArtistMember (user_ID),

CONSTRAINT makes FOREIGN KEY (follower_userID) REFERENCES FollowerMember (user_ID)

);

When I try to insert a null value I get the error below.

INSERT INTO pledge VALUES(559, 'null','1-FEB-2016', 3850, 85275, 88128);

Error report -

SQL Error: ORA-00904: : invalid identifier

00904. 00000 -  "%s: invalid identifier"

*Cause:    

*Action:

Error starting at line : 209 in command -

INSERT INTO pledge VALUES(559, 'NULL','1-FEB-2016', 3850, 85275, 88128)

Error at Command Line : 209 Column : 13

Error report -

SQL Error: ORA-00942: table or view does not exist

00942. 00000 -  "table or view does not exist"

*Cause:    

*Action: