I have a emp table in which i have a do a validation check after loading data into table.
Emp Table:-
eid int,
ename varchar,
desig varchar,
sal number,
validation_error varchar
for Example after imporing/loading data if i have eid not null, ename not null, desig not null, sal not null, then it should log the error into the validation error column...
o/p:-
empid, ename desig sal validation_error
1 - IT 2000 Ename should not be null
2 - - 4000 Ename should not be null | desig should not be null
3 - - - Ename should not be null | desig should not be null | sal should not be null
- - - - Empid should not be null | Ename should not be null | desig should not be null | sal should not be null
As am learning sql on my own, am unable to get it.pls help. thanks.