GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  SQL
Go To First  |  Previous Question  |  Next Question 
 SQL  |  Question 107 of 171    Print  
how to find number of user in the database.

  
Total Answers and Comments: 5 Last Update: September 25, 2007     Asked by: Debi Prasad Maharana 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
November 08, 2006 05:48:43   #1  
rameshr        

RE: how to find number of user in the database.

hi....

select * from all_users;

....this will give all the users created

select count(*) from all_users;

....this will give u no of user


 
Is this answer useful? Yes | No
November 20, 2006 02:51:07   #2  
deepak sony        

RE: how to find number of user in the database.
thanks for giving me answers.
 
Is this answer useful? Yes | No
November 20, 2006 05:47:56   #3  
aaa        

RE: how to find number of user in the database.
all_users may not give you correct results... dba_users should be used
 
Is this answer useful? Yes | No
January 06, 2007 07:27:31   #4  
Kannan        

RE: how to find number of user in the database.

Sybase:

sp_who will help to find the available users.....

select * from sysusers - it used to find the no.of users in ur DB


 
Is this answer useful? Yes | No
September 25, 2007 12:02:43   #5  
kowmudiswarna Member Since: September 2007   Contribution: 21    

RE: how to find number of user in the database.

select count(*) from all_users;

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape