Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Retrieving a set of randomly chosen records (Oracle 9i)

Re: Retrieving a set of randomly chosen records (Oracle 9i)

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Fri, 18 Feb 2005 15:48:43 GMT
Message-ID: <Xns96014F7823E23SunnySD@68.6.19.6>


"andreas.krisor_at_gmx.net" <andreas.krisor_at_gmx.net> wrote in news:1108737915.215801.132860_at_f14g2000cwb.googlegroups.com:

> Hi David,
>
> thank you for this hint, it works partly:
>
> my SELECT-statements refer to tables via a db-link and using SAMPLE
> results in an error.
>
> Do you know how I can use SAMPLE with db-links?
>

I can't say that I've tried this, but does it work to create a VIEW in the remote DB which contains the SAMPLE clause?

SELECT * FROM REMOTE_VIEW_at_OTHER_DB; Received on Fri Feb 18 2005 - 09:48:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US