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, 7822👍, 0💬
Popular Posts:
Can you explain what is “AutoPostBack” feature in ASP.NET ? If we want the control to automatically ...
Example of using Regular Expressions for syntax checking in JavaScript ... var re = new RegExp("^(&a...
What is CMM and different levels? explain? The Capability Maturity Model (CMM) is a process capabili...
What are different properties provided by Objectoriented systems ? Following are characteristic’s of...
How can you enable automatic paging in DataGrid ? Following are the points to be done in order to en...