Hello, I'm trying to format output exactly as defined in Oracle table columns with sqlplus.
Example: col1 VARCHAR (15); col2 NUMBER(8); col3 NUMBER(15); I want col1 to be output on 15 characters, col2 on 8 characters and col3 on 15 characters. Indeed for column col1 it works but for col2 and col3, the output is on 10 characters. I can't set a default output length for NUMBER because I have NUMBER of different lengths. And when I have more than 10 digits in a number in col3, the output is in scientific number format. I tried to set format with 99999999 but it didn't work. I tried to modify my sql request to set to_char(col2) but it then takes the char default length (40 on my system). Has someone idea to achieve this goal ? Thanx for any suggestion. Bye --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
