gohar

Tuesday, 14 May 2013

Query to get list of Oracle Users ans status

SELECT username,account_status FROM dba_users;

Posted by https://ansgohar.blogspot.com/ at 06:09
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Database, Oracle, Oracle users, SQL

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ▼  2013 (38)
    • ►  September (1)
    • ►  August (12)
    • ►  July (2)
    • ►  June (6)
    • ▼  May (16)
      • Find a constraint in ORACLE Database
      • how to retrieve total row count for each oracle table
      • 16 SQL commands
      • Users and Schemas
      • HR Schema
      • Creating an Oracle Database Connection
      • SQL Developer
      • SQL*Plus
      • Procedure vs Package
      • Stored Procedures, Functions and Packages
      • Anonymous PL/SQL Blocks versus Stored Procedures
      • Tom Cargill Quote
      • Changing host name inside Oracle XE configuration ...
      • How do I find duplicate values in a table in Oracle?
      • Query to get list of Oracle Users ans status
      • Java labeled Break Statement
    • ►  March (1)

About Me

https://ansgohar.blogspot.com/
View my complete profile
Simple theme. Powered by Blogger.