Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!wuarchive!gem.mps.ohio-state.edu!ginosko!aplcen!uakari.primate.wisc.edu!ames!uhccux!munnari.oz.au!murtoa.cs.mu.oz.au!ditmela!mark
From: mark@ditmela.oz (Mark Blakey)
Newsgroups: comp.databases
Subject: ORACLE: PRO*C: dynamic sql specifications sought
Keywords: Dynamic SQL, nested where clauses, subqueries
Message-ID: <7111@ditmela.oz>
Date: 19 Sep 89 06:05:36 GMT
Reply-To: mark@ditmela.UUCP (Dr Mark Blakey)
Organization: CSIRO, Division of Information Technology, Australia
Lines: 18

We are currently using ORACLE's (V5) Pro*C embedded SQL
product (V1.1). We're looking at implementing a particularly ugly selection 
filter using dynamic sql. The where clause will contain a logical combination
of smaller filter items. Can anyone enlighten me on the following:

1.	how long may a  'where' clause be (in characters)?

2.	how many levels of nesting of logical expressions are
	permitted in the 'where' clause?

3.	how deep may sub-queries be nested?

Is any of this configurable? I cant find it in the manuals 
and ORACLE wont/cant tell me.

Thanks in Advance.

Mark Blakey