Re: query on project
Date: Tue, 20 May 2008 23:45:01 -0700 (PDT)
Message-ID: <1827cf93-7693-408a-b037-6cda88591928@79g2000hsk.googlegroups.com>
On 21 Mag, 08:13, ellen.van.ha..._at_gmail.com wrote:
> Hi there,
>
> I'm designin a query. I want to join the invoice to a project. In the
> table invoices are record with no project_id or task_id; however when
> i'm looking in the form i see invoices on a project. I can find the
> invoice in the table but with no relation to the project. Can anybody
> shed some light on this relation??
Hi, have you looked for a third relation table that links Projects and
Invoices?
There is no documentation?
I suggest you to see the sessions' queries into cache with a statement
like this:
select sesion.sid,
sql_text, program, username
from v$sqltext sqltext, v$session sesion
where sesion.sql_hash_value = sqltext.hash_value
and sesion.sql_address = sqltext.address
and sesion.username is not null
order by sesion.sid, sqltext.piece
otherwise make statement auditing and see the dba_audit_trail view.
Regards,
Fabio Zanotti
Received on Wed May 21 2008 - 01:45:01 CDT