HI,
Is there a usage for something like this:
Select MyColumn
From MyTable
Start with MyCol = aNumber
Connect By MyCol = MyOtherCol
If not, its a bit weird that Oracle does not raise an error since the
keyword PRIOR is not used like this:
Select MyColumn
From MyTable
Start with MyCol = aNumber
Connect By Prior MyCol = MyOtherCol
Thank you,
Christian Cote 2 8089
"Christian" <cc*******@yahoo.com> wrote in message
news:99**************************@posting.google.c om...
| HI,
| Is there a usage for something like this:
|
| Select MyColumn
| From MyTable
| Start with MyCol = aNumber
| Connect By MyCol = MyOtherCol
|
| If not, its a bit weird that Oracle does not raise an error since the
| keyword PRIOR is not used like this:
|
| Select MyColumn
| From MyTable
| Start with MyCol = aNumber
| Connect By Prior MyCol = MyOtherCol
|
| Thank you,
| Christian Cote
no reasonable usage that i can see, but it does appear that the where-as the
syntax is not checked, any statement that leaves out the PRIOR (cannot leave
out the CONNECT BY) will either return no rows or will raise 'ORA-01436:
CONNECT BY loop in user data'
++ mcs
"Mark C. Stock" <mcstockX@Xenquery .com> wrote in message news:<_u********************@comcast.com>... "Christian" <cc*******@yahoo.com> wrote in message news:99**************************@posting.google.c om... | HI, | Is there a usage for something like this: | | Select MyColumn | From MyTable | Start with MyCol = aNumber | Connect By MyCol = MyOtherCol | | If not, its a bit weird that Oracle does not raise an error since the | keyword PRIOR is not used like this: | | Select MyColumn | From MyTable | Start with MyCol = aNumber | Connect By Prior MyCol = MyOtherCol | | Thank you, | Christian Cote
no reasonable usage that i can see, but it does appear that the where-as the syntax is not checked, any statement that leaves out the PRIOR (cannot leave out the CONNECT BY) will either return no rows or will raise 'ORA-01436: CONNECT BY loop in user data'
select rownum from dual connect by rownum < 100
I'm not sure about the earlier versions but since 9.2 it certainly
won't give you 'ORA-01436'. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: mayamorning123 |
last post by:
A comparison among six VSS remote tools including SourceOffSite ,
SourceAnyWhere, VSS Connect, SourceXT, VSS Remoting, VSS.NET
To view the full article, please visit...
|
by: vikas.bhatia |
last post by:
Is this still true?
http://groups.google.com/group/comp.databases.ibm-db2/browse_thread/thread/58c6c36ce9006d50/778f98749d8e2983?lnk=st&q=DB2+Connect+product+license&rnum=6#778f98749d8e2983
would...
|
by: RdS |
last post by:
hi,
#1 i am looking through some code and have a question. The class I am
looking at is a derived class that has one constructor (new). it is coded
as:
public sub new ()
..
..
..
end sub
|
by: shorti |
last post by:
db2 8.1 fix pack 12 on AIX 5.3
This is a newly configured HADR machine. The HADR was up and running.
I was 'playing' around some on the standby and did a db2 deactivate and
things sort of went...
|
by: Ehsan |
last post by:
hi
coulde any one show me the usage of "yield" keyword specially in this
example:
"""Fibonacci sequences using generators
This program is part of "Dive Into Python", a free Python book for...
|
by: Adisc |
last post by:
Hi,
How can I run a query to fetch the hierarchy without using the command - connect by prior?
I want to use this query by BO, which does not support the connect byqstart with option.
thanks
|
by: Vinod Sadanandan |
last post by:
Fast-Start Failover An Overview In Dataguard Environment
=============================================================================
This article describes the automatic fast start failover...
|
by: Christian |
last post by:
HI,
Is there a usage for something like this:
Select MyColumn
From MyTable
Start with MyCol = aNumber
Connect By MyCol = MyOtherCol
If not, its a bit weird that Oracle does not raise an...
|
by: iahamed |
last post by:
Hi Everyone,
I got two parts of my advance search to work, I am running out of Logic to
connect the third. My mind is in swing! Pleaseeeeeeeee Help me.
I have 3 Fiels to search, the First two...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |