Ciberterminal Wiki

User Tools

Site Tools

Trace:
dba:oracle:oracle_sql_querys:users

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Next revisionBoth sides next revision
oracle:oracle_sql_querys:users [2020/10/29 11:30] – [Listar] dodgerdba:oracle:oracle_sql_querys:users [2022/02/11 11:12] – ↷ Page moved from oracle:oracle_sql_querys:users to dba:oracle:oracle_sql_querys:users dodger
Line 3: Line 3:
 =====Listar===== =====Listar=====
   * Todos:   * Todos:
-<code sql>SELECT USERNAME, PASSWORD, PROFILE, ACCOUNT_STATUS from dba_users ;</code>+<code sql>SELECT USERNAME, PASSWORD, PROFILE, ACCOUNT_STATUS from dba_users order by 1 ;</code>
   * Activos:   * Activos:
 <code sql>SELECT USERNAME, PASSWORD, PROFILE, ACCOUNT_STATUS from dba_users WHERE ACCOUNT_STATUS LIKE 'OPEN';</code> <code sql>SELECT USERNAME, PASSWORD, PROFILE, ACCOUNT_STATUS from dba_users WHERE ACCOUNT_STATUS LIKE 'OPEN';</code>