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

> in other words "on the spur of the momment"

Sounds like a demand for a hand count in Florida... :-)

Chad

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Suri, Deepak Sent: Wednesday, November 15, 2000 7:16 AM To: Multiple recipients of list ORACLE-L Subject: RE: :what is the meaning of "ad hoc query"?

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-----
Sent: Wednesday, November 15, 2000 2:50 AM To: Multiple recipients of list ORACLE-L

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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Suri, Deepak
  INET: DSuri_at_oxhp.com

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