Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Inserting null rows to a table

Sunny86Jan 20 2020 — edited Jan 30 2020

Hello,

We are inserting a record to dB table from an external application.

Table

Create table test(id number, insert_date date)

Insert statement like below

Insert into test values(10,sysdate);

We need to insert another null record to test table after insert completes automatically.

Insert into test values(null,null);

Can it be done ..

This post has been answered by BluShadow on Jan 21 2020
Jump to Answer
Comments
Post Details
Added on Jan 20 2020
22 comments
3,370 views