sqlplus

user notice: The _custom_breadcrumbs_get_breadcrumb() function called token replacement with an array rather than a string for $text in /mnt/webc/60/17/52309417/htdocs/drupal/sites/all/modules/token/token.module on line 263.
user notice: The _custom_breadcrumbs_get_breadcrumb() function called token replacement with an array rather than a string for $text in /mnt/webc/60/17/52309417/htdocs/drupal/sites/all/modules/token/token.module on line 263.

Oracle: SQLplus Scripting

To show only data in SQLplus and no header or other stuff, enter the following:

SET NEWPAGE 0
SET SPACE 0
SET LINESIZE 80
SET PAGESIZE 0
SET ECHO OFF
SET FEEDBACK OFF
SET VERIFY OFF
SET HEADING OFF
SET MARKUP HTML OFF SPOOL OFF

Tags:

To list all accounts (users) the objects (like tables), you can query them with:

SELECT DISTINCT OWNER FROM DBA_OBJECTS ORDER BY OWNER;

If you want to list all accounts, you can query them with:

SELECT USERNAME FROM ALL_USERS ORDER BY USERNAME;

Or, if you only want the DBAs:

SELECT USERNAME FROM DBA_USERS ORDER BY USERNAME;

Tags: