Is there any way to dynamically change the sql field width for a field other than dbtool while users accessing the database.
Not in 11.5 as far as I know, but it's possible in 11.6 to set things to auto-adjust IIRC.
Yes, starting from 11.6 OE SQL has new feature called ASU (Autonomous Schema Update). When ASU is enabled, it auto adjusts SQL column widths.
Thanks James for your response
Thanks Dileep for your response