I guess what ravi is asking goes in the same line with my earlier question. I guess he is asking how to read long into a variable. Not just to display in sql*Plus. Am i right ravi ?