Last active
June 5, 2016 19:45
-
-
Save noncreature0714/8f80049e7e37db9ccaaaf7559dd130cb to your computer and use it in GitHub Desktop.
Exploring why column headers are absent
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SQL> DESC customer; | |
Name Null? Type | |
------------ -------- ------------ | |
CUST_ID NOT NULL NUMBER(5) | |
CUST_NAME VARCHAR2(15) | |
ACCOUNT_ID VARCHAR2(10) | |
ACCOUNT_TYPE VARCHAR2(2) | |
STATE VARCHAR2(2) | |
SQL> SELECT cust_id, cust_name, account_id, account_type, state FROM customer; | |
90001 B and B A-11101 PR AK | |
90002 XYZ A-11102 CM NJ | |
90003 JJ Sons A-11103 CM NJ | |
90004 Exxon A-11104 PR NY | |
90005 ABC A-11105 CM NY | |
90006 Smith Co. A-11106 CM MD | |
90007 Brown Co. A-11107 CM MD | |
90008 Cooper Inc. A-11108 PR MD | |
8 rows selected. | |
SQL> DESC customer; | |
Name Null? Type | |
------------ -------- ------------ | |
CUST_ID NOT NULL NUMBER(5) | |
CUST_NAME VARCHAR2(15) | |
ACCOUNT_ID VARCHAR2(10) | |
ACCOUNT_TYPE VARCHAR2(2) | |
STATE VARCHAR2(2) | |
SQL> SELECT * FROM customer; | |
90001 B and B A-11101 PR AK | |
90002 XYZ A-11102 CM NJ | |
90003 JJ Sons A-11103 CM NJ | |
90004 Exxon A-11104 PR NY | |
90005 ABC A-11105 CM NY | |
90006 Smith Co. A-11106 CM MD | |
90007 Brown Co. A-11107 CM MD | |
90008 Cooper Inc. A-11108 PR MD | |
8 rows selected. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment