Write a code to add two rows of data


Discuss the below:

CREATE TABLE contacts

(Con_id NUMBER(4),
Company_name VARCHAR2(30) not null,
E_mail VARCHAR2(30),
Last_date DATE DEFAULT SYSDATE,
Con_cnt NUMBER(3) CHECK (Con_cnt > 0),
PRIMARY KEY (Con_id));

Q. Write a code to add two rows of data to the table that was created using the command above. Ensure the default option on the LAST_DATE column is used in the second row added. Also, issue a command to permanently save the data to the table.

 

Solution Preview :

Prepared by a verified Expert
PL-SQL Programming: Write a code to add two rows of data
Reference No:- TGS01939040

Now Priced at $20 (50% Discount)

Recommended (98%)

Rated (4.3/5)