0 pts.
 oracle quires
while executing the following qurie 'inser into custmaster select * from tnjcust where seccode='431';' answer is not enough valus

Software/Hardware used:
ASKED: October 26, 2007  1:36 PM
UPDATED: October 29, 2007  3:12 PM

Answer Wiki:
Your target (custmaster) and source (tnjcust) must have the same number and types of columns when you construct an INSERT statement this way. Frankly, this construction is not a good programming practice. Instead you should list the columns: INSERT INTO custmaster(x,y,z) SELECT seccode,b,c FROM tnjcust WHERE seccode='431'
Last Wiki Answer Submitted:  October 29, 2007  3:12 pm  by  Tudz Drkl   0 pts.
All Answer Wiki Contributors:  Tudz Drkl   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _