Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Goal: Output Columns for Name, Nullable, Type, Comments
- describe office
- Name Null Type
- ------------ -------- ----------
- OFFICEID NOT NULL NUMBER(4)
- OFFICENUMBER NUMBER(5)
- OFFICEPHONE NUMBER(11)
- FACULTY NUMBER(4)
- SELECT column_name, nullable, data_type
- FROM USER_TAB_COLUMNS
- WHERE table_name=upper('OFFICE');
- SELECT column_name, comments
- FROM user_col_comments
- WHERE table_name=upper('OFFICE');
- // JOIN ATTEMPT
- SELECT a.column_name, a.NULLABLE, a.data_type, b.comments
- FROM USER_TAB_COLUMNS a, user_col_comments b
- WHERE a.column_name = b.column_name;
- AND a.table_name = "OFFICE"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement