If we want to display all user in Oracle Database we can use the following command :
SQL> SELECT * FROM ALL_USERS; USERNAME USER_ID CREATED --------------------- ------- --------- XDB 59 13-NOV-10 TESTING 64 05-JAN-11 DODOL 60 13-NOV-10 EXPORTADMIN 58 12-NOV-10 TEDY 56 06-NOV-10 SCOTT 54 30-JUN-05 MGMT_VIEW 53 30-JUN-05 RMAN 61 14-NOV-10 MDDATA 50 30-JUN-05 SYSMAN 51 30-JUN-05 MDSYS 46 30-JUN-05 SI_INFORMTN_SCHEMA 45 30-JUN-05 ORDPLUGINS 44 30-JUN-05 ORDSYS 43 30-JUN-05 OLAPSYS 47 30-JUN-05 ANONYMOUS 39 30-JUN-05 CTXSYS 36 30-JUN-05 EXFSYS 34 30-JUN-05 WMSYS 25 30-JUN-05 DBSNMP 24 30-JUN-05 TSMSYS 21 30-JUN-05 DMSYS 35 30-JUN-05 DIP 19 30-JUN-05 OUTLN 11 30-JUN-05 SYSTEM 5 30-JUN-05 SYS 0 30-JUN-05 26 rows selected. SQL>
Or this command :
SQL> SELECT USERNAME FROM DBA_USERS; USERNAME ------------------------------ MGMT_VIEW SYS SYSTEM DBSNMP SYSMAN EXPORTADMIN TESTING DODOL TEDY RMAN OUTLN MDSYS ORDSYS EXFSYS DMSYS WMSYS CTXSYS ANONYMOUS ORDPLUGINS SI_INFORMTN_SCHEMA OLAPSYS SCOTT TSMSYS MDDATA DIP XDB 26 rows selected. SQL>
siang pak
oh ya pak,jika ada rekan2 yg membutuhkan produk server yg berhubungan dengan oracle,silahkan menhubungi kami, kami menyediakan server sun,primepower dll semua eks.import dengan harga yg murah,trims