Read structure of a table. / Generate txt file.

[recruta0]

Guys, I'm new to SQLPlus and the forum as well.
How do I read the structure of a table?
Already with the query ready how to generate a txt file?

[Trevisolli]

Brother,

Would you need the structure with constraints or, just the fields?

If it is only the fields, take a look at the User_Tab_Columns (or ALL_TAB_COLUNS).

If this needs, give a spool on SQL * Plus of this content.

[dr_gori]

Just to see the structure, in SQL * Plus there is the DESC command.
Just put desc and table name.

[recruta0]

Thomas worked. Vlw.
Trevisolli, the 1st OP said there was no selected line and 2nd OP that there was no table.

Thanks staff.
Thank you very much.
I still have much to learn from you.

[recruta0]

And the txt file?

[dr_gori]

Is that it is all_tab_columns, the trevis wrote wrong (all_tab_coluns)

on generating the txt, did not work make a spool?
or do you want to make a program that generates file?

[recruta0]

Just generate TXT.

In the case of Spool, set the file, executed the query and the spool command.

SQL> Spool
Unloading spool at the time to test.lst
SQL>

I took time and opened the file with notepad, but remains blank.

[recruta0]

OK. Spool worked.

But the query header repeated several times.
How do I do not happen?

[dr_gori]

SET PAGESIZE 2000

also has
set HEAD OFF
Read about SQL * Plus sets and you will discover a new world!

[recruta0]

Thank you very much.
SDS.