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

Home -> Community -> Usenet -> c.d.o.server -> Re: challenge: v7 DBA script --> 8i, 9i, 10g

Re: challenge: v7 DBA script --> 8i, 9i, 10g

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Thu, 5 Feb 2004 21:58:54 -0000
Message-ID: <4022bca2$0$32$cc9e4d1f@news.dial.pipex.com>


I thought in v11x the query was

<resultset>
return what i want here without any sql just xml ta </resultset>

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message
news:aa2dnVmvtr6GJb_dRVn-vw_at_comcast.com...

> you forgot the hint:
>
> | I'm going to present this to my students tonight at class.
> |
> | But in version 11x the syntax is:
> |
> | SELECT --+ faster_than_a_greased_pig
> whatiwant
> | FROM whereeveritis
> |
> | --
> | Daniel Morgan
> | http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> | http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> | damorgan_at_x.washington.edu
> | (replace 'x' with a 'u' to reply)
> |
>
>
Received on Thu Feb 05 2004 - 15:58:54 CST

Original text of this message

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