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 <orat...@msn.com> wrote:
> On Sep 1, 2:46 am, Siva <cs.prasad...@gmail.com> 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

-- 
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en

Reply via email to