oracle quires
while executing the following qurie 'inser into custmaster select * from tnjcust where seccode='431';' answer is not enough valus
Software/Hardware used:
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'
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
