Hi, Just try this below query INSERT INTO TABLE2 ( SELECT * FROM SAMPLE A, SAMPLE B WHERE A.COLUMN <> B.COLUMN1 AND A.COLUMN1 < B.COLUMN1)
Regards Yuvaraj S On Fri, Oct 7, 2011 at 4:04 AM, ddf <[email protected]> wrote: > > > On Oct 6, 4:52 am, SANDEEP REDDY <[email protected]> wrote: > > Hi Friends Here Is The Solution For Ur Question > > > > select a.name NAME1, b.name NAME2 > > FROM SAMPLE a, SAMPLE b > > where a.name<b.name > > > > Enjoyyyyy > > & > > All The Best > > > > On Sep 1, 7:59 pm, ddf <[email protected]> wrote: > > > > > > > > > On Sep 1, 2:46 am, Siva <[email protected]> wrote: > > > > > > Hi All, > > > > > > In Table1 I have data like this. > > > > > > Column1 > > > > ----------------- > > > > > > Record1 > > > > Record2 > > > > Record3 > > > > Record4 > > > > > > And in Table 2 the data has to be inserted in below manner. > > > > > > Column1 Column2 > > > > ------------------------------- > > > > Record1 Record2 > > > > Record1 Record3 > > > > Record1 Record4 > > > > Record2 Record3 > > > > Record2 Record4 > > > > Record3 Record4 > > > > > > Please let me know how to achieve this. > > > > > > Regards. > > > > > You logically think through the problem and arrive at a solution. > > > Since this is probably homework you should post what you've done to > > > achieve these results. Once we see your work we can correct areas, as > > > necessary, to lead you to the answer. > > > > > David Fitzjarrell- Hide quoted text - > > > > - Show quoted text - > > I think not since the question asks how to INSERT data into a table in > that order. As far as we know there is no d > > -- > 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 > -- 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
