Home » SQL & PL/SQL » SQL & PL/SQL » I need an Example on this
I need an Example on this [message #329589] Wed, 25 June 2008 23:51 Go to next message
renu4dwh
Messages: 24
Registered: April 2008
Location: Pune
Junior Member
I need an example on this following thing.

How can i achieve the same results using a CROSS JOIN and a CASE expression, what we get using UNION of columns from the same table?
Re: I need an Example on this [message #329592 is a reply to message #329589] Wed, 25 June 2008 23:52 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
renu4dwh wrote on Wed, 25 June 2008 21:51
I need an example on this following thing.

How can i achieve the same results using a CROSS JOIN and a CASE expression, what we get using UNION of columns from the same table?


I am sorry to see/hear that both the Search button of this forum & GOOGLE are broken for you.

Please be patient while repairs are completed.
Additional information will follow.


Re: I need an Example on this [message #329596 is a reply to message #329592] Thu, 26 June 2008 00:01 Go to previous messageGo to next message
renu4dwh
Messages: 24
Registered: April 2008
Location: Pune
Junior Member
anacedent wrote on Wed, 25 June 2008 23:52
renu4dwh wrote on Wed, 25 June 2008 21:51
I need an example on this following thing.

How can i achieve the same results using a CROSS JOIN and a CASE expression, what we get using UNION of columns from the same table?


I am sorry to see/hear that both the Search button of this forum & GOOGLE are broken for you.

Please be patient while repairs are completed.
Additional information will follow.





I did make a search at both the places, but unfortunately could not get the exact result what i was looking for.
Re: I need an Example on this [message #329597 is a reply to message #329589] Thu, 26 June 2008 00:04 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
> unfortunately could not get the exact result what i was looking for.
How would you or others know EXACTLY what that may be?
Re: I need an Example on this [message #329600 is a reply to message #329597] Thu, 26 June 2008 00:09 Go to previous messageGo to next message
renu4dwh
Messages: 24
Registered: April 2008
Location: Pune
Junior Member
anacedent wrote on Thu, 26 June 2008 00:04
> unfortunately could not get the exact result what i was looking for.
How would you or others know EXACTLY what that may be?


If you are able to understand my question and you know any example to give, then please do it. No need to reply in a sarcastic way. Dont waste your time making creepy replies and my time too and all those people who are reading the thread. Thank you
Re: I need an Example on this [message #329603 is a reply to message #329589] Thu, 26 June 2008 00:27 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Be careful for what you ask.
The silence can be defining.

Re: I need an Example on this [message #329604 is a reply to message #329589] Thu, 26 June 2008 00:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Post a test case: create table and insert statements along with the result you want with these data.

Also always post your Oracle version (4 decimals).

Regards
Michel
Re: I need an Example on this [message #329748 is a reply to message #329603] Thu, 26 June 2008 07:29 Go to previous messageGo to next message
renu4dwh
Messages: 24
Registered: April 2008
Location: Pune
Junior Member
anacedent wrote on Thu, 26 June 2008 00:27
Be careful for what you ask.
The silence can be defining.




Thank you for the vital information.You know, I just love quotations. Thank you for this two line quotation. Keep them with you, more handy for you.
Re: I need an Example on this [message #329752 is a reply to message #329748] Thu, 26 June 2008 07:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
And what about what has been asked to you?

Regards
Michel
Re: I need an Example on this [message #329790 is a reply to message #329752] Thu, 26 June 2008 09:48 Go to previous message
renu4dwh
Messages: 24
Registered: April 2008
Location: Pune
Junior Member
Michel Cadot wrote on Thu, 26 June 2008 07:34
And what about what has been asked to you?

Regards
Michel



After trying for couple of hours i was able to formulate an example for my own understanding. Thank you Michael for your kind gesture.
Previous Topic: how to display row to column ..
Next Topic: Any idea why INTERSECT ALL is not working here
Goto Forum:
  


Current Time: Tue Dec 03 21:23:32 CST 2024