Recent content by Laura Birch

Hello, Maxim. The "outputing 81 characters" refers to the column width. If I specify SUBSTR(xxx,1,30), I expect to get a column that is 30 characters wide. Instead, I'm getting a column width that is wider than the actual table column; there appears to be a default set somewhere, and I don't...

Also, I need to be able to manipulate each field individually. By using SET COLWIDTH, all subsequent columns are defaulted to the specified single column width; for example, I need to be able to pull 30 characters of the last name and 20 characters of the first name, all in one query. How is...

Thanks for your input, Maxim. Just to clarify, here is an example of the issue I am experiencing: A table has a field that is defined as 60 characters...VARCHAR2(60). In PL/SQL Worksheet, I was able to use the following command to pull a portion of that field (ie: the first 30 characters)...

Hello. I'm new to PL/SQL Developer (v 10.0.5.1710); I previously used PL/SQL Worksheet. I find that I am unable to do simple data manipulation, such as a SUBSTR function; it is simply ignored. I'm using the Command Window. Also, the field width in the output/Dialog window does not correspond...