Window list and window title problem

[Jean-Paul Finne]

I don't like the way the text is changed in the window list and the window title.

I have several tables containing the same columns : id, create_time, create_user timestamp, xml_data

Xml_data is a sys.xmltype column.

When I query a table, the text is "S - query data of table MY_TABLE@ORCL"

When I change the query (by adding a where clause for example), the title changes into "S - select id, create_time, create_user timestamp, xml_data.getclobval() ...".

If I do the same with an other table OTHER_TABLE@ORCL, I get exactly the same title ("S - select id, create_time, create_user timestamp, xml_data.getclobval() ...").

After a while, most windows have the same title. I can't see the difference between one query and the other.

I think it is better to leave the original text (S - query data of table MY_TABLE@ORCL).

Jean-Paul

 

[Marco Kalter]

Do you think this is always the preferred behavior? What if you change the select statement to an insert statement for a another table? The title would no longer be correct.

I assume we could make it smarter, so that the title will change if the statement is no longer a select statement on the original table.

------------------
Marco Kalter
Allround Automations

 

[Jean-Paul Finne]

Being smarter is the best:

for example the title for :
select a.mylongcolumn1, a.mylongcolumn2, a.mylongcolumn3, b.mylongcolumn3 from mytable1 a, mytable2 b

could be :
SELECT:mytable1 mytable2

insert into mytable(mylongcolumn1, mylongcolumn2, mylongcolumn3) values ('hip','hip', 'houra')

INSERT:mytable (3 columns)

 

[cassiusdrow]

I have found it best to put a one line comment as the first line, such as:

-- sys.xmltype: all records

This will become the new title of the window.

New question: How do I make the Short Text option in the window list the default behavior?

[This message has been edited by cassiusdrow (edited 12 February 2003).]

 

[Jean-Paul Finne]

it has the same effect as renaming the title (popup item "rename..." in the window list).

I want something more automatic.

 

[Marco Kalter]

Originally posted by cassiusdrow:
New question: How do I make the Short Text option in the window list the default behavior?

You can use the Save Layout item from the Window menu after selecting the Short Text format.

------------------
Marco Kalter
Allround Automations