RE: Statement to check the last actions done.Urgent!

2002-08-22 Thread Simplicio Noronha, Savio
Hi tia, You can see it through the V_$SQL table. For this you need to get the Last_SQL_Address and Last_SQL_HASH value from the v_SEssion table. Once you have these just query v_$SQL table with the 2 params. Regards Savio -Original Message- Sent: Donnerstag, 22. August 2002 13:33 To:

Re: Statement to check the last actions done.Urgent!

2002-08-22 Thread dizzy74
V$SQL Beatriz Martínez Jiménez wrote: >Hello, is there any SQL statement to see what SQL have been performed >over a database??? >Inserts, deletes, etc. >TIA > > -- Date: Wednesday, Aug 21,2002 !! !! ! For pe

RE: :STATEMENT

2002-08-21 Thread Bob Metelsky
Title: Message Yes, I thougt the same thing... here is a site that will give clear direction of installing modules   http://perl.about.com/library/weekly/aa030500a.htm   They cover ppm and  perl -MCPAN -e shell     check out all the links on this page  bob 

RE: :STATEMENT

2002-08-21 Thread Brooks, Russ
s.perl.org/showlist.cgi?name=dbi-users Jared "Bob Metelsky" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/21/2002 08:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: :

RE: :STATEMENT

2002-08-21 Thread Brooks, Russ
Title: Message Thanks Bob.  I thought if you pulled the module through ppm that was not necessary.   Russ -Original Message-From: Bob Metelsky [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 21, 2002 11:24 AMTo: Multiple recipients of list ORACLE-LSubject: RE: :STATEMENT

RE: :STATEMENT

2002-08-21 Thread Jared . Still
e respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: :STATEMENT Did you run the perl makefile.pl cd dir\downloaded\fromppm\eg\.cpan\source\mymodule make make test make install For win32 you have to

RE: :STATEMENT

2002-08-21 Thread Bob Metelsky
Title: Message Did you run the perl makefile.pl   cd dir\downloaded\fromppm\eg\.cpan\source\mymodule   make make test   make install     For win32 you have to download and use nmake from microsoft   bob     Hi,   Has anyone played with Perl's SQL::STATEMENT?  I pulled it down with

Re: statement for directory objects

2001-07-25 Thread Igor Neyman
You should be able to see the one you created in dba_directories: select * from dba_directories; Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 25, 2001 1:10

Re: statement for directory objects

2001-07-25 Thread Beatriz Martínez Jiménez
Hello again, Before sending this email,I have done some intents to get this information. One of this was through this view (user_objects) but there is no object directories in it. The way in which I have created it is 'create directory XX AS 'E:\XXX';, and I get no error, the one I think is the c

RE: statement for directory objects

2001-07-25 Thread Gogala, Mladen
select * from user_objects; > -Original Message- > From: Beatriz Martínez Jiménez [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 25, 2001 7:35 AM > To: Multiple recipients of list ORACLE-L > Subject: statement for directory objects > > > Hello List, > I would like to know any statem