PL/SQL Developer 5.1.1

[CTucker]

I just downloaded this new release and am curious how the following new features work:

* New SQL Window preference: Show Dictionary Info In Result Grid:
> Column data type, optionality, and comment displayed
> Lookup for check constraints (col in (value1, value2, ...))
> Lookup for single column foreign key constraints to small tables of less
than 1000 rows

Note that the help that was released with version 5.1.1.672 has not been updated to include the use of these features.

Thanks,

 

[Marco Kalter]

A picture says more than 1000 words:

Note the column information on the status line, and the lookup for the deptno column based on the foreign key between the emp and dept table.

------------------
Marco Kalter
Allround Automations

 

[CTucker]

Is there a preference you have to set to make this work? It does not seem to work for me? I'm assuming that check constraints are supposed to have a drop list as well? If so this does not apprear to work for me either.

Using Oracle 8.1.7 and PL/SQL Developer 5.1.1.627.

Thanks,

 

[CTucker]

No sooner than I sent my last reply - I tried once again an now everything works as advertised. I guess I was not entering the "edit data" mode properly.

Thanks,

 

[ghyland]

Isn't this a fantastic feature. Full marks to the product designers.

One slight extension though:

You could apply the same logic with drop down for foreign keys and check constraints to providing options in QBE.

Regards
Grant

 

[Marco Kalter]

We'll add this for QBE in the next patch release.

------------------
Marco Kalter
Allround Automations