Forum Stats

  • 3,734,283 Users
  • 2,246,937 Discussions
  • 7,857,218 Comments

Discussions

Unable to see column meta data on a view

451050
451050 Member Posts: 47
edited Sep 8, 2008 10:03AM in SQL Developer
In the 1.5.1 Build MAIN-5440 when we select a view from the views branch, then the column tab from the tabs tool bar, no field data about the view is displayed. This was a feature in 1.2.0. Is this a bug or a feature that has been removed? We really use that meta view frequently.

OS:
WinXP Pro SP2

Java:
java version "1.6.0_10-beta"
Java(TM) SE Runtime Environment (build 1.6.0_10-beta-b14)
Java HotSpot(TM) Client VM (build 11.0-b11, mixed mode, sharing)
Tagged:

Answers

  • -K-
    -K- Member Posts: 6,171
    Happens with all views or just that one?
    Can you see the header with Column Name, Data Type, etc?
    The query used is:
    select c.column_name,  
             decode(data_type,'CHAR'    ,data_type||'('||c.data_length||')',    
                              'VARCHAR' ,data_type||'('||c.data_length||')',    
                              'VARCHAR2',data_type||'('||c.data_length||')'    ,
                              'NCHAR'   ,data_type||'('||c.data_length||')'    ,
                      'NUMBER'  ,decode(c.data_precision,null,'NUMBER', data_type||'('||c.data_precision||','||c.data_SCALE||')'),
                      'NVARCHAR'  ,data_type||'('||c.data_length||')'    ,
                              'NVARCHAR2' ,data_type||'('||c.data_length||')'    ,
                              data_type) data_type,
                decode(nullable,'Y','Yes','No') nullable,  
                c.DATA_DEFAULT,
                column_id,   
                com.comments,
    			(SELECT 1
    			  FROM all_constraints, all_cons_columns
    				WHERE all_constraints.constraint_type = 'P'
    				AND all_constraints.constraint_name = all_cons_columns.constraint_name
    				AND all_constraints.owner = all_cons_columns.owner
    				and all_cons_columns.table_name = c.table_name and c.column_name=all_cons_columns.column_name) Primary_Key,
    			c_update.insertable,
                c_update.updatable,
                c_update.deletable  
          from sys.all_tab_Columns c, 
               sys.all_col_comments com,
               sys.user_updatable_columns c_update
          where c.owner      = :OBJECT_OWNER  
          and   c.table_name =  :OBJECT_NAME   
          and   c.table_name = com.table_name
          and   c.owner = com.owner
          and   c.column_name = com.column_name
          and c_update.column_name = com.column_name
          and c_update.table_name = com.table_name
    What happens if you issue it through a worksheet?
    Also note that using a beta JDK is really not recommended. In fact it might very well cause the UI to behave incorrectly.

    K.
  • 561237
    561237 Member Posts: 1,067
    There is a known problem with columns not being shown in the Columns sub-tab of the View tab for views owned by other schemas (due to the use of sys.user_updatable_columns as can be seen in the query -K- posted). Hopefully this will be getting fixed in SQL Dev 1.5.2, but we will have to wait and see.

    theFurryOne
  • 451050
    451050 Member Posts: 47
    Happens in every view of a view.
    Yes, I see the header column.
    Same as the view.
  • 451050
    451050 Member Posts: 47
    edited Sep 8, 2008 10:03AM
    Thanks the furry one...I was hoping it was a bug and not just me.

    Edited by: SK Jennings on Sep 8, 2008 9:03 AM
This discussion has been closed.