Solved

display

Posted on 2014-02-26
4
139 Views
Last Modified: 2014-10-15
SYS@sprefuat1> select * from dba_directories;

OWNER                          DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
SYS                            DUMP_FILES2
/backup/ora_export

SYS                            DATA_PUMP_DIR
/ora102_home/app/oracle/product/10.2.0/rdbms/log/

SYS                            DUMP_FILES
/ora_export


OWNER                          DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
SYS                            WORK_DIR
/ora102_home/app/oracle/product/10.2.0/work

SYS                            ARROWGB
/local/apps/cmp01/ext_link

SYS                            FDE_DS
/glpfeeds/input


OWNER                          DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
SYS                            SNP_MANUFACTURE
/glpfeeds/output

SYS                            GLP_MANUFACTURE
/glpfeeds/output

SYS                            GLP_DATA_LOAD
/glpfeeds/input


OWNER                          DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
SYS                            DUMP_EXADATA
/backup6

SYS                            ORACLE_OCM_CONFIG_DIR
/ora_home/app/oracle/product/10.2.0/ccr/state

SYS                            TMP
/tmp


12 rows selected.

SYS@sprefuat1>




How will I format this display..

In a viewable format..
0
Comment
Question by:thomasliju
4 Comments
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 500 total points
ID: 39889486
Try:
SET LIN 120 PAGES 49999
COL OWNER FOR a20
COL DIRECTORY_NAME FOR a32
COL DIRECTORY_PATH FOR a58 WRA
SELECT * FROM Dba_Directories;

Open in new window

0
 
LVL 74

Expert Comment

by:sdstuber
ID: 39889490
set linesize 1000
column directory_path format a50

then run your query
0
 
LVL 22

Expert Comment

by:Steve Wales
ID: 39889651
The above advice works fine for this specific query (where the output isn't really that wide).

Sometimes you'll query views or tables with lots of columns that you just can't get to display  "neatly" on a screen.

If you want to get information out in a more legible format, you would need to use a third party tool.

You can use MS Excel to query a database and return the rows into the spreadsheet.
You could use SQL Developer (free, from Oracle Corp)
You could use PL/SQL Developer (paid, form Allround Automations)
WinSQL is also an option (I believe there is a free Lite version, or there used to be at least - but it's mainly a paid product).

Depending upon your needs, one of these options might work (although each requires some level of configuration on your client platform in order to make the connection to the database).
0
 

Author Closing Comment

by:thomasliju
ID: 40383669
yes this really helped.


Thank you
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
data lookup in Oracle - need suggestions 55 121
Oracle Listener Not Starting 11 53
oracle DR - data guard failover. 18 48
update statement in oracle 9 29
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

827 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question