hey what sql command is used to insert values in a table from another table
On 9/5/11, Rob Wolfe <[email protected]> wrote: > This really strikes me as a homework question (and not one with a lot > of utility in the real world) > > Can we see what you have come up with so far? We are happy to help > someone that is stuck but we don't particularly like to do someone's > homework for them. After all, we might have to work with you out here > in the real world and it would be nice to know that you did some of > your work for yourself before asking your coworker. > > Rob > > On Sep 4, 9:02 am, Siva <[email protected]> wrote: >> Hi, >> >> I have data in *Table 1 *as below. >> >> Column1 Column2 >> ------------ ------------- >> A 10 >> D 78 >> C 08 >> B 90 >> E 05 >> >> and this information has to be inserted into* Table 2* as shown below. >> >> Column1 Column2 Column3 >> ------------- ------------- ------------- >> A D 10 >> A C 10 >> A B 10 >> A E 10 >> D C 78 >> D B 78 >> D E 78 >> C B 08 >> C E 08 >> B E 90 >> >> Please help me how to code this. >> >> Regards, >> Siva > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en > -- *Kishor N. Mali,* * *Student of MCA, * *Department of Computer Science, North Maharashtra University, Jalgaon.(MS) MOB :8390933252 -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
