display

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..
thomaslijuAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MikeOM_DBACommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sdstuberCommented:
set linesize 1000
column directory_path format a50

then run your query
0
Steve WalesSenior Database AdministratorCommented:
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
thomaslijuAuthor Commented:
yes this really helped.


Thank you
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.