15 lines
334 B
SQL
Executable File
15 lines
334 B
SQL
Executable File
SET PAGESIZE 100
|
|
SET LINESIZE 200
|
|
|
|
ALTER SESSION SET CURRENT_SCHEMA = ADMIN;
|
|
|
|
PROMPT Query base table
|
|
SELECT account_id, account_name, owner_name, region, balance
|
|
FROM dds_mac_accounts
|
|
ORDER BY account_id;
|
|
|
|
PROMPT Query view
|
|
SELECT account_id, account_name, owner_name, region, balance
|
|
FROM dds_mac_accounts_view
|
|
ORDER BY account_id;
|