Magnus Titho schrieb am 08.06.2012 um 08:24 (+0200): > Am 08.06.2012 02:51, schrieb ehaerim: > > SQL> select substring(data_feed_name from 1 for 10) dfn from test; > > > [...] > > I want the ============================= to be shortened to 15 so > > that it looks like > > > > DFN > > =============== > > InvestWare
> Anyway, you could use cast to shorten the field. Note however, that > the seperating line is always at least 6 characters long. I think ehaerim is referring to the row separators in ISQL, not to any data items. There's a special SET instruction for that: SQL> help set; … SET WIDTH <col> [<n>] -- set/unset print width to <n> for column <col> SQL> set width abc 5; SQL> select * from T; -- now column ABC displays with a width of five This won't cast the data, but rather truncate it for display, including the ============== row separator. One thing to note is that the display width depends on the character set chosen for the ISQL session. See below. Michael -- D:\temp :: isql eins Database: eins SQL> show table kader; NAME VARCHAR(12) CHARACTER SET UTF8 Not Null SQL> select * from kader; NAME ================================================ Müller Özil Höwedes Götze Schürrle Gündogan SQL> set width name 10; SQL> select * from kader; NAME ========== Müller Özil Höwedes Götze Schürrle Gündogan SQL> quit; D:\temp :: isql -ch win1252 eins Database: eins SQL> select * from kader; NAME ============ Müller Özil Höwedes Götze Schürrle Gündogan SQL>
