oracle quires
Oracle, SELECT statement
while executing the following qurie 'inser into custmaster select * from tnjcust where seccode='431';' answer is not enough valus Question
Oracle, SELECT statement
while executing the following qurie 'inser into custmaster select * from tnjcust where seccode='431';' answer is not enough valus 
Subscribe to Alerts! Get questions and answers delivered to your Inbox.
Answer Wiki (Improve, edit or add to this answer)
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
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'
Browse more Questions and Answers on Oracle and Database.
Looking for relevant Oracle Whitepapers? Visit the SearchOracle.com Research Library.
