Advertisement
Guest User

Untitled

a guest
Mar 27th, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. Goal: Output Columns for Name, Nullable, Type, Comments
  2.  
  3. describe office
  4. Name Null Type
  5. ------------ -------- ----------
  6. OFFICEID NOT NULL NUMBER(4)
  7. OFFICENUMBER NUMBER(5)
  8. OFFICEPHONE NUMBER(11)
  9. FACULTY NUMBER(4)
  10.  
  11.  
  12. SELECT column_name, nullable, data_type
  13. FROM USER_TAB_COLUMNS
  14. WHERE table_name=upper('OFFICE');
  15.  
  16. SELECT column_name, comments
  17. FROM user_col_comments
  18. WHERE table_name=upper('OFFICE');
  19.  
  20. // JOIN ATTEMPT
  21.  
  22. SELECT a.column_name, a.NULLABLE, a.data_type, b.comments
  23. FROM USER_TAB_COLUMNS a, user_col_comments b
  24. WHERE a.column_name = b.column_name;
  25. AND a.table_name = "OFFICE"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement