Some Important Sql Queries in Oracle


To know the current user in Oracle

select user from dual;

Steps to know list of users in the Oracle database.

Connec to dba user

conn sys/password as sysdba;

execute below query to get list of users

select * from dba_users;

To select only user names:

select username from dba_users;

To know the full details about the user:

select * from dba_users where username=’scott’;

To get the Table space name:

select tablespace_name from dba_tablespaces;

To list the username and size of the user:

select owner,sum(bytes) from dba_segments group by owner;

Advertisements
About

I born in Good cultural place called India. My family is traditional family. We fallow all Indian traditions.

Tagged with: , , , , , ,
Posted in Oracle
One comment on “Some Important Sql Queries in Oracle

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 678 other followers

Calendar
September 2010
M T W T F S S
« Aug   Oct »
 12345
6789101112
13141516171819
20212223242526
27282930  
Mallikarjun Gunda

This is Mallikarjun Gunda, I am working as a software professional. Blogging is my Passion. This blog contains the posts on Java related technologies and programming languages. I am happy to share my knowledge through the blogs.

Blog Stats
  • 265,564 hits
IndiBlogger
malliktalksjava.wordpress.c...
70/100