Skip to Main Content
Forums

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!

Update all nulls with non-null values in all tables

user12050217Aug 27 2014 — edited Aug 29 2014

Hi,

Oracle 11.2.0.1

Windows

I am searching one function or PL/SQL package by running that there should not be any non null value in any column of all the tables (Except SYS and SYSTEM users).  I tried by querying user_tab_columns where nullable='Y', this can I know the null rows in the table, but data type can be of any type.  So as per data type there should replacement of be non null values for those rows who have null values in the columns.

Thank you.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 26 2014
Added on Aug 27 2014
28 comments
11,322 views