RE: Things I didn't know about Oracle column aliases

From: Mark W. Farnham <>
Date: Wed, 14 Dec 2011 12:43:19 -0500
Message-ID: <01f401ccba87$df2ea870$9d8bf950$>

  1. What Jonathan wrote already and Tanel's cool thing about tokenization and why some pretty weird things end up as legal syntax.
  2. Of course no one is advocating obscuring the meaning of the sql by leaving out the optional spaces.
  3. Chapter 3 of the SQL reference manual has all the documentation about specification of numeric literals.


I get the impression that a trailing F or D on a number means "display as floating point or decimal" then the F/D is dropped and the A used as a label. I can't find this in the docs though.

Works with strings as well but the F/D thing doesn't appear with strings. Doesn't work - for obvious reasons - with column names.

Online also as



Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767

-- Received on Wed Dec 14 2011 - 11:43:19 CST

Original text of this message