APEX

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!

Deleting empty rows on Apex 5.04

3474044Jul 27 2017 — edited Jul 27 2017

Hi all,

I created a table with my database. On the data, there is not any empty rows. But when I show it as IR on the application, it created so many (up to 500) empty rows. Please see the attached screenshots for more clarification. How can i solve this problem?

This post has been answered by 3474044 on Jul 27 2017

Jump to Answer

3474044

Answer

SOLVED:

Solution:

Add the following to SQL Workshop ---> SQL SCRIPTS ---> CREATE --> RUN

DELETE YOURS_TABLE_NAME WHERE EMTY_COLUMN_NAME IS NULL;

Marked as Answer by 3474044 · Sep 27 2020

1 - 1

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 24 2017

Added on Jul 27 2017

#apex, #apex-discussions, #delete, #on, #query, #sql

1 comment

341 views

APEX

Deleting empty rows on Apex 5.04

Comments

Post Details