How to export the column information viewed via Schema Browser | Table | Column tab?
SOLUTION #1:
In version 10.0 and newer:
1) Right click on the grid in the schema browser's Columns tab.
2) Select "Export Dataset..." in the list.
3) Complete the wizard to export.
SOLUTION #2:
1) Select all the rows in the schema browser's columns tab.
2) Use Ctrl+C to copy the information.
3) Paste it into a file.
SOLUTION #3:
1. Open the SQL Editor.
2. Type in DESC <table name>;
e.g. DESC EMPLOYEES;
3. Select F5 function key or "Execute as script" tool bar button.
4. The Output tab of Script Output window will generate the result of the Describe query.
e.g. EMAIL NOT NULL VARCHAR2(25)
PHONE_NUMBER VARCHAR2(20)
HIRE_DATE NOT NULL DATE
JOB_ID NOT NULL VARCHAR2(10)
SALARY NUMBER(8,2)
COMMISSION_PCT NUMBER(2,2)
MANAGER_ID NUMBER(6)
DEPARTMENT_ID NUMBER(4)
5. From the Output tab, right click and select "Save to file..." option.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center