RE: :what is the meaning of "ad hoc query"?

From: Suri, Deepak <DSuri_at_oxhp.com>
Date: Wed, 15 Nov 2000 10:14:15 -0500
Message-Id: <10681.122115@fatcity.com>

Zhuchao,
Ad Hoc basically means unplanned, or in other words "on the spur of the momment".
By extention an Ad hoc query would mean an unplanned query that might be run by a user against a database to get a quick response. The query may not be the ideal query for deployment without further tuning, formating etc.

For example you might want to just get a feel for the type of data stored in a table by selecting just the first 10 rows, but it makes no sense (for almost all scenarios I can think of) to put this query into a production job, application as it cannot be guaranteed to provide consistent results.

Hope this explanation helps !

deepak

-----Original Message-----
From: zhuchao [mailto:zhuchaopku_at_263.net] Sent: Wednesday, November 15, 2000 2:50 AM To: Multiple recipients of list ORACLE-L Subject: :what is the meaning of "ad hoc query"?

hi,all

i am reading Oracle Discoverer handbook and see a word "ad hoc query". but i don't know the exact meaning of this, nor can i find the meaning in dictionary. i am a non-native english speaker, and hope the list can explain it to me.

	thanks a lot.
	if any chinese here, would you kind to give a chinese translation of
this?
	regards.
            zhuchao
            zhuchaopku_at_263.net

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: zhuchao
INET: zhuchaopku_at_263.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Nov 15 2000 - 09:14:15 CST