SQL> l
1 select
2 substr(abbreviation,1,10)
3 ,substr(codelevel,1,10)
4 from
5 ad_trackable_entities
6 where
7 abbreviation in( 'ad','txk','fnd','fwk','atg_pf','icx' )
8 order by
9* abbreviation
SQL> /
SUBSTR(ABB SUBSTR(COD
---------- ----------
ad C.10
atg_pf C.7
fnd C.7
fwk C.7
icx D.3
txk C.10
6 rows selected.
1 select
2 substr(abbreviation,1,10)
3 ,substr(codelevel,1,10)
4 from
5 ad_trackable_entities
6 where
7 abbreviation in( 'ad','txk','fnd','fwk','atg_pf','icx' )
8 order by
9* abbreviation
SQL> /
SUBSTR(ABB SUBSTR(COD
---------- ----------
ad C.10
atg_pf C.7
fnd C.7
fwk C.7
icx D.3
txk C.10
6 rows selected.
No comments:
Post a Comment