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.

Tagged as: , , , , , , , , , , , , , , , , , , , Continue reading
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.

Tagged as: , , , , , Continue reading
   
Custom Search

Recent Posts

Tags

Abstract Als Amp Carpal Tunnel Syndrome Cast Application Chf Compendium Computer Mouse Der Schweiz Ein Fiat Fiat Ulysse Google Google Maps Hotels Ins Kriterien legoland Legoland Park Lt Mail Medical History Mit Nun oracle Oracle 7 Oracle Database Oracle Forms Oracle Sql Oracle Toad Peugeot Php Pl Sql Repetitive Strain Injury RSI Schweiz Solution Number Sql Code Sql Oracle Sql Statement Switzerland Toad Toad Oracle Wikipedia Wrist Pain

Recent Comments

Categories

Blogroll