Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To View All Columns in an Existing Table
How To View All Columns in an Existing Table? - Oracle DBA FAQ - Managing Oracle Database Tables
✍: FYIcenter.com
If you have an existing table and want to know how many columns are in the table and how they are defined, you can use the system view USER_TAB_COLUMNS as shown in the following tutorial exercise:
SQL> COL data_type FORMAT A12; SQL> SELECT column_name, data_type, data_length FROM user_tab_columns WHERE table_name = 'EMPLOYEES'; COLUMN_NAME DATA_TYPE DATA_LENGTH ------------------------------ ------------ ----------- EMPLOYEE_ID NUMBER 22 FIRST_NAME VARCHAR2 20 LAST_NAME VARCHAR2 25 EMAIL VARCHAR2 25 PHONE_NUMBER VARCHAR2 20 HIRE_DATE DATE 7 JOB_ID VARCHAR2 10 SALARY NUMBER 22 COMMISSION_PCT NUMBER 22 MANAGER_ID NUMBER 22 DEPARTMENT_ID NUMBER 22
2007-05-03, 7688👍, 0💬
Popular Posts:
What are the high-level thread states? The high-level thread states are ready, running, waiting, and...
How can I include comments in HTML? An HTML comment begins with "<!--", ends with "-->...
Is There Any XSD File to Validate Atom Feed Files? - RSS FAQs - Atom Feed Introduction and File Gene...
How to set a HTML document's background color? document.bgcolor property can be set to any appropria...
what are the advantages of hosting WCF Services in IIS as compared to self hosting? There are two ma...