Re: Demo Tables

Connect as SCOTT/TIGER to access demo table. (you are lucky your name is already in every oracle database).

Connect as SYSTEM/MANAGER to access all tables (prefix with owner to access tables in other schma e.g. SELECT * FROM SCOTT.DEPT)

regards,
M. Armaghan Saqib

• SQL PlusPlus : Add power to SQL Plus command line
• SQL Link for XL : Integrate Oracle with XL
• Oracle CBT with sample GL (Triggers and Forms Source Code included. Download free: http://www.geocities.com/armaghan/

  ---

  <sboucher_at_msn.com> wrote in message news:83fn44$a72$1_at_nnrp1.deja.com...
  > I just installed Oracle8i and used the Web Assistant to generate a web
  > page based on tables under demos folder. This seems to be the only
  > area I can see these tables. How can I make these tables available
  and
  > visible to other tasks such as SQL Plus. I am used to SQL server where
  > all database objects are visible in the management console
  >
  > Thanks
  > Scott
  

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Dec 18 1999 - 06:38:34 CST