unable to insert column from other table [message #196556] |
Thu, 05 October 2006 21:48  |
ashish_pass1
Messages: 114 Registered: August 2006 Location: delhi
|
Senior Member |
|
|
sir,
i unable to insert the column from other table.
what are the following steps to insert column.
SQL>SELECT * FROM CLIENT_MASTER;
CLIENT NAME STATE BAL_DUE
------ ---------------- ------ ----------
C00001 Ivan Bayross Maharastra 15000
C00002 Vandana Saitwal Tamil Nadu 0
C00003 Paramada Jaguste Maharastra 5000
C00004 Basu Navindgi Maharastra 0
C00005 Ravi Sreedharan delhi 2000
C00006 Rukmini Maharastra 0
SQL>SELECT * FROM RAJ;
CLIENT NAME STATE BAL_DUE
------ ---------------- ------ ----------
C00001 Ivan Bayross Maharastra
C00002 Vandana Saitwal Tamil Nadu
C00003 Paramada Jaguste Maharastra
C00004 Basu Navindgi Maharastra
C00005 Ravi Sreedharan delhi
C00006 Rukmini Maharastra
SQL>
1* INSERT INTO RAJ SELECT BAL_DUE FROM CLIENT_MASTER
INSERT INTO RAJ SELECT BAL_DUE FROM CLIENT_MASTER
*
ERROR at line 1:
ORA-00947: not enough values
[Updated on: Thu, 05 October 2006 22:06] Report message to a moderator
|
|
|
|
|
Re: unable to insert column from other table [message #196664 is a reply to message #196660] |
Fri, 06 October 2006 07:43   |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
And when you tried the previous posters suggestion ofupdate raj r set BAL_DUE = (select BAL_DUE from CLIENT_MASTER where CLIENT = r.CLIENT) , did it do what you wanted? If not, what errors did you encounter?
|
|
|
|
|
|