Skip to content

Instantly share code, notes, and snippets.

@noncreature0714
Last active June 5, 2016 19:45
Show Gist options
  • Save noncreature0714/8f80049e7e37db9ccaaaf7559dd130cb to your computer and use it in GitHub Desktop.
Save noncreature0714/8f80049e7e37db9ccaaaf7559dd130cb to your computer and use it in GitHub Desktop.
Exploring why column headers are absent
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