Collections:
Show All Columns in an Existing Table in Oracle
How To View All Columns in an Existing Table in Oracle?
✍: 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
⇒ Recover a Dropped Table in Oracle
⇐ Delete a Column in an Existing Table in Oracle
2019-05-14, 1606🔥, 0💬
Popular Posts:
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...