EA2 - strange column order in "Columns" tab

Advertisement

Hi,
when I click on a table in the left panel, I'd expect the columns in the "Columns" tab appear in the same order as the table has been defined (i.e. ordered by column id). But instead the columns are ordered by primary key. Of course I can doubleclick the column id heading to get the correct order, but when I switch to another table the columns are again sorted by primary key.
If I didn't miss a preference, I'd suggest to change this behaviour to column id sorting by default.

Advertisement

Sorry I missed that. Here's the query we use on that:
with pri_cols as ( SELECT cols.column_name column_name, cols.position column_position
                                                       FROM all_constraints cons, all_cons_columns cols
                                                       WHERE cons.constraint_type = 'P'
                                                       AND cons.constraint_name = cols.constraint_name
                                                       AND cons.owner = cols.owner
                                                       and cols.table_name = :OBJECT_NAME
                                                       and cons.owner = :OBJECT_OWNER
                                                       ORDER BY cols.table_name, cols.position )
select c.column_name, case when data_type = 'CHAR' then data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'
                                   when data_type = 'VARCHAR' then data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'
                                   when data_type = 'VARCHAR2' then data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'
                                   when data_type = 'NCHAR' then data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'
                                   when data_type = 'NUMBER' then
                                             case when c.data_precision is null then 'NUMBER'
                                             else data_type||'('||c.data_precision||','||c.data_SCALE||')' end
                                   when data_type = 'NVARCHAR' then data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'
                                   when data_type = 'NVARCHAR2' then data_type||'('||c.char_length||decode(char_used,'B',' BYTE','C',' CHAR',null)||')'
                                   else data_type end data_type,
decode(nullable,'Y','Yes','No') nullable,
c.DATA_DEFAULT,column_id, sub.column_position pk,com.comments     
from sys.all_tab_Columns c,
sys.all_col_comments com,
pri_cols sub
where c.column_name = sub.column_name(+)
and 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     
order by sub.column_position nulls last,column_id
It's supposed to place the pk columns in order followed by the other columns by column_id.

November 30, -0001

EA2 - strange column order in "Columns" tab

Hi, when I click on a table in the left panel, I'd expect the columns in the "Columns" tab appear in the same order as the table has been defined (i.e. ordered by column id). But instead the columns are ordered by primary key. Of course I can do

Export TO XXL from ALV Grid - Column order mismatch

Hi All, The user is trying to download data from Option -> Export -> Spreadsheet which will create XXL. But while downloading there is mismatch in the order of columns displayed on the alv grid & columns downloaded. All character fields are disp

How to change the order of columns in a speadsheet?

It seems this would be completely straight-forward. However I can find nothing in help to tell me how to do this. I am using a spreadsheet for data so want to be able to rearrange in the order of the columns. How does one do this? Thanks. JohnI don't

Where TableModel stores the columns ordering?

Hi, In my JTable i allow columns reordering (setReorderingAllowed(true)). I want to write to a file the new order of the columns and the next time i will run the program, i want to have the columns displayed just like in the file. Any ideas? Thanks,

I am unable to get order by column name in oracle report parameter form

i created query like following in query builder SELECT CASE_NO, COURT_ID, CASE_TYPE, INITCAP(PLAINTIFF) PLAINTIFF,INITCAP( DEFENDENT) DEFENDENT, INITCAP(COUNSEL) COUNSEL, START_DATE, PREVIOUS_HEARING_DATE, NEXT_HEARING_DATE,INITCAP( DESCRIPTION) DESC

Changing the order of columns in a table

Can anyone tell me how to change the order of column in a table. I want a new column to be added in a table in 2nd position. Is there any way out for it?1) Does this have something to do with security? If not, it really ought to be posted in a more a

IDOC order of columns not same as the data source

Hi, I am from non SAP background. We are using Informatica to pull data from SAP ECC using the Business Content for Integration by pulling data from IDOCS. Here is my problem: 1) We identified a particular data source (0FI_GL_4) for full mode data pu

Change column order updateable sql query report APEX 4

Hi all, I have a master detail page. Detail is SQL Query (updateable report) I want to change the column order but seems not possiible anymore in A4. In A3... on the right side of the report attributes it was possible to move columns up or down. path

Query Result Column Order

I'm working with an embedded db query that specifies columns by name in the result set, i.e., no *. However, the order of the columns in the result set seem to be quite random - or at least dependent on which column is being searched. I'm showing the

Headings of columns in the responses tab

I can not see field names at the title of columns in the responses tab, the headings are empty. The same in Excel download, thi first row is empty. Why, and how can I fix the problem?Hi, Open the form and select "View Responses" tab, on your low

SQL Query to re-order the columns

Hello All, I want to know if it is possible to re-order the columns of a table once the rows has been inserted in all the columns. So for e.g I have initially a table containing 3 columns COL1, COL2 & COL3. Now after data has been inserted into the t

Is that important column order in a query with row_number function

Hi folks, I am using Oracle 11g R2 on HP-UX machine. I have 2 types of query with row_number and I think they are same but output of each of them are different. I changed only column order in query2. Query 1 : (SELECT "LOOKUP_INPUT_SUBQUERY".&qu

Datagrid Column Ordering from Recordset?

I often populate my datagrids with a recordset, an array of record objects, by passing the recordset in the dataprovider constructor. However, this results in unpredictable column ordering i.e. it doesn't correspond to the order of the fields in the

How to arrange month in order in cross tab in crystal report

Hi all,       we are using cross tab to arranging the data (month wise)  in crystal report. we have month in string format like jan2008. this field is in column of the cross tab. now we need to arrange the month in sorted order. At Present , the mont

[LV2013SP1] Strange cluster ordering from a database

Hello, I'm not an expert in LabView since I come from the embedded world (C/C++) yet I found something quite strange when reading from a database. Here's attached some screen captures of the database content and structure, then the LabView diagram wi

Set Variable column in the Column page?

Hi, I try to do this exercise but I facing some understanding problem, please guide me. This is BIEE example to do Oracle BI publisher and Dashboard. 1. Create a dashboard prompt for the region and state to filter the BI publisher report results on t

Splitting one column into 4 columns

Hi,   I want to split one column into 4 columns as shown below. parameters PanelPanel=MP01110201&YearYear=2013&Source=1&UserID=aad2779 PanelPanel=MP12100173&YearYear=2013&Source=1&UserID=aac6440 it should be display as  panel      

Multiple values from same column in diffetent columns in same row??

Hi all, I am wondering how you can display different values from the same column into different columns on same row. For example using a CASE statement I can: CASE WHEN CODE IN ('1', '3') THEN COUNT( ID) END as "Y" CASE WHEN CODE NOT IN ('1', 'M

Table control-change the output of a column. My column shows numbers (char)

Hello Friends, I have in the table control a table. This table show varoius columns , but one column shows numbers. My boss detected that there are showed the numbres but without decimals . for example 10 is showed instead of 10.35. The format of the

Split char. Column to 2 columns in BEx

Hi Friends, is this possible in BEx? I have data in DSO like this Acc. Doc   G/L Account    Amount 101            41000001         $10 101            41000001         $20 101            71000001         $30 101            71000001         $40 In my B