Errores #156
Updated by Jesús Freire almost 7 years ago
Update mandatory attributes in each design class using the following SQL sentence modifing the word ATCL by ecah name of the design class: <pre> update atcl set oblig=true where coinob='00000053' and subcla='CD' and vaclob='ATCL' and codatr in (select codatr from atcl where coinob='00000053' and subcla='CL' and vaclob in (select coobme from objm where tiobme='CL' and coobpa in (select coinob from objm where tiobme='CD' and coobme='ATCL'))); </pre> Actually, there are 85 design classes. Update mandatory attributes in each unique key of each design class. Upload PL/SQL procedures to test resources directory class