If that takes to long, you can limit the search, if you have a table with an indexed column where you know that there is certain id
SELECT 1 FROM <TABLE> WHERE <ID> = <known id> (We always have such tables) > --- Allistair Crossley <[EMAIL PROTECTED]> > wrote: > > i think you could use anything .. maybe > > > > SELECT COUNT(*) FROM table > > > > The dual table is an oracle dummy table and is quite > > handy, but I think the validation query can just be > > any old select statement that should return true a > > result always. > > > > ADC --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
