Hi, Would it be possible to generate numbering in simple select statement ? For example : No Name Descripton 1 APPLE FRUITS 2 ORANGE FRUITS 3 PINE FRUITS 4 MELONG FRUITS The "No column" is not stored in the database. It just dispay the number for better viewing purposes. Thank YOU JK __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- //www.freelists.org/webpage/oracle-l