• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 507
  • Last Modified:

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.
3 Solutions
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.


Here is the stepts to use

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.
pma111Author Commented:
Is there anywhere to see a list of fields per each of the tables/views you mention..
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

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

 OWNER not in ('SYS','SYSTEM')
order by owner,table_name, column_name;
In sqlplus try if

set colsep ";"

gets what you want
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.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now