OraFAQ Forum: SQL & PL/SQL » user sys to query tables created by other user

Home » SQL & PL/SQL » SQL & PL/SQL » user sys to query tables created by other user

Tue, 03 December 2002 04:45

Armando
Messages: 6
Registered: December 2002

Junior Member

being a user sys(dba) how can i query tables created by other user

Tue, 03 December 2002 05:01

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

SQL> connect sys/sys
Connected.
SQL> select count(*) from mag.emp;

  COUNT(*)
----------
        14

Wed, 04 December 2002 02:27

Armando
Messages: 6
Registered: December 2002

Junior Member

thank you for your reply

regards,
armando

Previous Topic:	How to generate a number......
Next Topic:	After delete of all rows from a table, update another table, HOW?

Goto Forum:

]

Current Time: Wed May 15 10:34:34 CDT 2024