In that scenario, you have several options for storing the data: For a text data type, you can specify the "text in row" option to store the data in the row with the rest of the data, or you can turn off that option and have the data stored in a separate area.
Either way, you can get the exact length of the data in the column using the DATALENGTH function (for example, DATALENGTH(pubbame)). Then you could use the SUBSTRING function to return only the part of the column that contains data.
If you are using a text (or ntext for Unicode) data type, the column is variable length and the "empty spaces" should not be stored.
If you are using a char data type, consider switching to text (or perhaps varchar) to implement a variable length column.
Hope this helped.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.