Is it possible by querying system tables to find all sql-statements that
have been run from one session?
What tables/views should I look into to find this?
Thanks for your help,

I am about to start the fall semester in an Oracle DBA certificate
program in the Dallas, Texas area. I have no prior experience and would
like to know when I finish would my prospects of getting a job be good?
And if experience is a major issue how could I get experience in the

Hi list
I'm looking  for a mecano like this.
mySQL_String := 'select count(*) from table A'
FOR tempData IN (mySQL_String)

I have a question. Browsed the Internet but was unsuccessfull in
finding the answer. So hopefully you can help?
Given a UI connecting to an Oracle database. Currently, this UI
provides users the ability do searches on the database using only an

I am trying to set up an instrumentation strategy for our application.
The instrumentation pieces will be in the production environment as
well to help diagnosing. What we have so far used is a table and an
autonomous procedure to write into the table. Some developers use it,

I am a 36 year old stay at home mom, with eight years paid work
experience working with Oracle databases at the user level and
analyzing data, and bachelors degrees in economics and mathematics.
I am considering re-entering the workforce as a database administrator.

I'm starting to work with RMAN on my 10g DB.
I found that it was pretty easy to use it to backup my database.
How do I use it to toss EXPIRED BACKUPSETs in the trash?
For example:

I have a query such as:
select *
from mtl_material_transactions m
, po_headers_all ph

Oracle's Password Transform
Goals:
- Authentication information ("encrypted password") shall be portable
  between machines with different character sets (ebcdic and ascii).

Is this OT here? Can anyone recommend or suggest any companies that they
jknow provide a fully managed hosting environement for Oracle-based
apps?
UK preferred but international considered.

Is there any Oracle guy who knows Delphi? I need help in calling oracle
stored procedures by  delphi application.My procedure is simple:
[code]CREATE OR REPLACE PROCEDURE test_proc2(p_result OUT sys_refcursor) AS
BEGIN

Dear Sir/Madam & others
i have one simple procedure to get some code  if a string match exists.
written procedure to achive this. but feel it is not an efficient one.
can any one give altenative approch to this problem if any.

oracle : 9.2.0.6 (not RAC)
AIX    : 5.3 (64 Bit) (HACMP)
On a system of a customer I typed : ps -ef | grep oracle
The follwing is the first lines of output.

For testing, we want to open one of our Oracle 9i database to the internet.
Therefore we opened the port 1521 and forwarded the port to our local pc.
Now we can do a tnsping from outside, but we cannot connect to this
database. The Error 12541 : TNS Kein Listener is coming. But ...

Hi to All experts in areana
when i run this script
BEGIN
  DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(