oracle sql + output

I have an oracle DBA exporting a querys results from an 11g database and the format it is outputting in is far from user freindly. i.e. its been output in a txt file but its not in any sort of tabular format.

I beleive the default tool to retreive rows is sql + in oracle (you may correct me), is there an easy way to export the rows in something that will be easily imported to excel, i.e. csv format, or at least a tabular format.

One last question in 11g, which table will list all database accounts, account status, password last set dates etc.
LVL 3
pma111Asked:
Who is Participating?
 
Praveen Kumar ChandrashekatrDatabase Analysist Senior Commented:
You can use SQL Developer to connect to oracle database 11g which free tool from oracle, using this you can export the table data into excel,CSV or Text in tabular form.

http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

Here is the stepts to use

http://www.oracle.com/technetwork/developer-tools/sql-developer/export-intro-1-161239.html#exp
0
 
Praveen Kumar ChandrashekatrDatabase Analysist Senior Commented:
you can get the account details in dba_users, all_users and sys.user$ tables but the password is encrypted in the DB.
0
 
pma111Author Commented:
Is there anywhere to see a list of fields per each of the tables/views you mention..
0
Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

 
pma111Author Commented:
No way to do this in sql+ or sql* or whatever its called...
0
 
Gerwin Jansen, EE MVETopic Advisor Commented:
For tables, have a look in ALL_TAB_COLUMNS - like this:

select
OWNER
,table_name
,column_NAME
,data_type
,data_length
from
 all_tab_columns
where
 OWNER not in ('SYS','SYSTEM')
order by owner,table_name, column_name;
0
 
flow01Commented:
In sqlplus try if

set colsep ";"

gets what you want
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.