Home » SQL & PL/SQL » SQL & PL/SQL » How To Select Other user's Table
How To Select Other user's Table [message #206481] Thu, 30 November 2006 04:44 Go to next message
ramjidas
Messages: 2
Registered: November 2006
Location: India
Junior Member
hi
dear all

How the sys user can fire a select query on the tables created by other users in other schemas.

ramji
Re: How To Select Other user's Table [message #206494 is a reply to message #206481] Thu, 30 November 2006 05:18 Go to previous message
Littlefoot
Messages: 20894
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
By preceding table name with user name, such as

SELECT * FROM user.table_name;
Previous Topic: regarding to database session
Next Topic: Query optimization
Goto Forum:
  


Current Time: Mon Dec 05 08:55:07 CST 2016

Total time taken to generate the page: 0.27225 seconds