v9.0: Table column names now lowercase

[ageno]

When we look at the table SQL, the column names are now lower-cased. It used to be upper-case. We've committed (Subversion) table scripts using upper-cased column names. How can we make the table SQL scripts upper-case again?

 

[Marco Kalter]

In 8.0 the column names were also in lower case. What was your previous PL/SQL Developer version?

 

[ageno]

Thanks for the reply.

Our version is "8.0.1.1502". Below is an example of what we get right now when we click the View SQL button on an Edit Table window. Using "Export User Objects..." does the same thing.

-- Create table
create table TT_CHARGE_TYPE
(
CHARGE_TYPE_ICODE NUMBER(2) not null,
CHARGE_TYPE VARCHAR2(50) not null,
CHARGE_DESC VARCHAR2(2000) not null,
CREATION_DATE TIMESTAMP(3) not null,
UPDATE_DATE TIMESTAMP(3) not null,
LAST_UPDATE_USER VARCHAR2(8) not null,
LAST_UPDATE_APPLICATION VARCHAR2(20) not null
)

We need to be able to configure PSD 9 to do the same.

 

[Marco Kalter]

There are currently no configuration options for this.

 

[ageno]

Kindly add an option in future versions where users can make the column names uppercase. It would be a huge job for us (University of Otago) to update our scripts to make them consistent with what PSD automatically generates for us.

Thanks and more power.

 

[Marco Kalter]

I have added this to the list of enhancement requests.