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. > >
