Common SQL statements in Oracle

1. Check which users are in the database?
Select username from all_users;
2. Check which DBA users are in the database?
Select username from dba_users;
3. view the tables owned by the current user?
Select table_name from user_tables;
4. How do I create a tablespace in Oracle and create a user?
A. Create a tablespace.
Create tablespace blueskydb datafile 'd: \ oracle \ product \ 10.2.0 \ oradata \ bluesky \ blueskydb. dbf' size 500 m;
B. Create a user
Create user bluesky identified by bluesky;
C. user authorization
Grant resource, connect, recovery_catalog_owner to bluesky;
Grant create table to bluesky;
Alter user bluesky quota unlimited on blueskydb;
Alter user bluesky default tablespace blueskydb;
D. You can try using sqlplus or other tools!