PL/SQL (MOSC)

MOSC Banner

Some issues in column names in select request headers

edited Jul 2, 2015 10:00AM in PL/SQL (MOSC) 3 commentsAnswered

Is there a way to influence the format of the column name descriptions that are written on top of the result of a select request?

We rely on the tablenames written in front of the column names.

In a foreign database (SQLBASE) we get :

select ident_daten.sys_id,ident_daten.sach_nr,bm_f_k.maschinen_gruppe from ident_daten, bm_f_k where ident_daten.sys_id = bm_f_k.sys_id and ident_daten.sach_nr like '1221%';

IDENT_DATEN.SYS_ID IDENT_DATEN.SACH_NR                      BM_F_K.MASCHINEN_GRUPPE
================== ================================================== =======================
    1116068256 1221.01                          1221
    1116068315 1221.02                          1221

2 ROWS SELECTED

while the same request under Oracle (11g) yields:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center