ahhh..yes. Found it. Thanks
> -----Original Message-----
> From: Fong, Anna [mailto:anna@;water.ca.gov]
> Sent: Thursday, November 14, 2002 12:55 PM
> To: Kipp, James; Jacqui Caren
> Cc: [EMAIL PROTECTED]
> Subject: RE: Trying to get LIKE to work
>
>
> Assuming you have a SID of MYDB, you would find the
> initMYDB.ora in $ORACLE_BASE/admin/MYDB/pfile/
>
>
> --------------------------------------------------------
>
> Anna Q. Fong, Webmaster
> California Data Exchange Center
>
> > -----Original Message-----
> > From: Kipp, James [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, November 14, 2002 9:41 AM
> > To: 'Jacqui Caren'
> > Cc: [EMAIL PROTECTED]
> > Subject: RE: Trying to get LIKE to work
> >
> > > >
> > > > If I do it from DBI I get:
> > > > 11/14/2002 10:11:41 AM
> > >
> > > what is the NLS_DATE_FORMAT in your initSID.ora?
> > >
> > > I assume the sqlplus is doing an alter session for some reason.
> > >
> > > I know toad by default does not do an alter session.
> > >
> > > Jacqui
> > >
> >
> > I can't find seem to find that file. Found all types of
> .ora files, but not
> > that one. I think our DBA has it set per database.
> >
> >
>
