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
--
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
