Re: using departments table
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Fri, 4 Mar 2011 10:13:47 -0800 (PST)
Message-ID: <f439458b-06df-4c7a-95a8-9f36ff719776_at_d12g2000prj.googlegroups.com>
On Mar 4, 9:53 am, happy <ehabaziz2..._at_gmail.com> wrote:
> How can I use the departments table ? Should I use the HR,oracle login
> or with scott,tiger login ?
> Thanks
Date: Fri, 4 Mar 2011 10:13:47 -0800 (PST)
Message-ID: <f439458b-06df-4c7a-95a8-9f36ff719776_at_d12g2000prj.googlegroups.com>
On Mar 4, 9:53 am, happy <ehabaziz2..._at_gmail.com> wrote:
> How can I use the departments table ? Should I use the HR,oracle login
> or with scott,tiger login ?
> Thanks
I believe that departments would be the modern HR version as the older table was called dept.
As a DBA you could query all_ or dba_tables and check the owner.
HTH -- Mark D Powell -- Received on Fri Mar 04 2011 - 12:13:47 CST