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, 8255👍, 0💬
Popular Posts:
I have 5 questions please give me the answer ,explanation,suggestions if any?? what is PMP(project m...
Would I use print "$a dollars" or "{$a} dollars" to print out the amount of dollars in this example?...
What are the different accessibility levels defined in .NET ? Following are the five levels of acces...
How To Create an Add-to-Google-Reader Button on Your Website? - RSS FAQs - Adding Your Feeds to RSS ...
How do we access attributes using “XmlReader”? Below snippets shows the way to access attributes. Fi...