Home » SQL & PL/SQL » SQL & PL/SQL » Connect by clause
Connect by clause [message #325399] Fri, 06 June 2008 02:18 Go to next message
preeti_khurana
Messages: 15
Registered: May 2008
Location: Gurgaon
Junior Member
Hi
Please let me know if there is any possibility that the connect by clause in a SQL will give different results in oracle 9i then in oracle 10g.
I am case it is giving diffrent results in 9i and different in 10g.

Regards
Preeti
Re: Connect by clause [message #325414 is a reply to message #325399] Fri, 06 June 2008 02:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes it is possible because there are some bugs in new connect by algorithm in 10.2.0.1 (and may be higher or 10.1 but I didn't check this version).

Regards
Michel
Re: Connect by clause [message #325430 is a reply to message #325414] Fri, 06 June 2008 03:30 Go to previous messageGo to next message
preeti_khurana
Messages: 15
Registered: May 2008
Location: Gurgaon
Junior Member
Hi

Can u give me some examples how the reults will vary. Also can you please illustrate the kind og bugs that are there in the algorithms.

Regards
Preeti
Re: Connect by clause [message #325433 is a reply to message #325430] Fri, 06 June 2008 03:32 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Why don't you offer your case. I expect you have a reason for asking this, so show us your testcase.
Re: Connect by clause [message #325435 is a reply to message #325430] Fri, 06 June 2008 03:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I found many and the one I found may not be the one you encounter so it may not help you.
It is better if YOU post a test case of what you see and what is wrong.

Regards
Michel
Re: Connect by clause [message #325447 is a reply to message #325435] Fri, 06 June 2008 04:14 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
check this link:-

http://www.orafaq.com/forum/t/119921/121416/


It might help you out.
Re: Connect by clause [message #325449 is a reply to message #325447] Fri, 06 June 2008 04:20 Go to previous messageGo to next message
preeti_khurana
Messages: 15
Registered: May 2008
Location: Gurgaon
Junior Member
Actually i have already read that but that dosnt seem useful to me.I will post the use case as soon as i get it and probably that will help me get a better solution from you guys.

Thanks a lot.

regards
Preeti
Re: Connect by clause [message #325456 is a reply to message #325449] Fri, 06 June 2008 04:38 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Actually i have already read that but that dosnt seem useful to me

This exactly why it is useless for us to post all examples we have. You'll just reply each time, it is not useful for me.

Quote:
I will post the use case

Make it as simple and short as possible.
Take the original, remove part, see if there is still the difference, if yes remove other part of query, table columns, or data and so on. If no difference, put back the last change and remove other part, till you can't remove anything.

Regards
Michel

[Updated on: Fri, 06 June 2008 04:39]

Report message to a moderator

Previous Topic: Index's are not properly using
Next Topic: ORA-01502: index in unstable state
Goto Forum:
  


Current Time: Sun Dec 04 06:56:48 CST 2016

Total time taken to generate the page: 0.39874 seconds