SERPland Oracle, PL/SQL, PHP, Autos, Bungalow-Hotels and more …

30Apr/070

Toad 9 default options which should be changed


With Toad 9.0 for Oracle, some Toad options do have changed default values against older Toad versions.
To change Toad options in top menu: VIEW - TOAD OPTIONS

I changed following options :

Editor - Display - Hightlight View Names: from unchecked to checked.

Because I like to see View names the same as Table names in a sql statements and pl/sql programs.

Editor - Open/Save - Opening Files: from "prompt to split files" to "never split files".

Because all my sources are saved as files in a filebased source management system. On check out I don't want Toad to split my files.

24Apr/072

Oracle Reports Query not linkable: REP-20147 error (group link)


In Oracle Report you can not link query blocks on items when you see this No-Link Item:

Cannot implement column link for this detail SQL query. Converting to group link.

oracle reports query item not linkable picture

This means you can link block, but you can not link specific item as you would usually like to do.