How to remove bevels, spaces and box shadows from OBIEE Dashboard?
By default, dashboard sections are visually separated from each other using spaces, borders, bevels and box shadows. Also the default color of dashboard background is light blue. We may want to remove it to get a cleaner dashboard display.
How to create sub folders in Presentation Layer?
This can be done in Oracle BI Administration Tool by adding them in Child Presentation Tables tab in presentation layer table Properties.
How to enable word wrap in Toad?
To do that we will need to set the right margin position and enable the word wrap in Toad options.
Go to View / Toad Options:
First go to Editor / Display to modify the position of right margin. Set Visible right margin to the position you want.
Select Editor / Behavior and check the Word wrap option:
Query that was going outside the margin before the changes:
After changes are applied, query is wrapped to the right margin:
See the post on how to enable the word wrap feature in Oracle SQL Developer.
How to enable word wrap in Oracle SQL Developer?
Actually there is no such option in Oracle SQL Developer as of version 4.02 (this may be changed in further releases). To enable similar feature you’ll need to set a line break at some line width and format the text using CTRL + F7 key combination. Here’s how to do it:
To set maximum line width in characters go to Tools / Preferences:
Choose Database / SQL Formatter / Oracle Formatting. Choose a profile to edit (default is Old Preferences) and click Edit:
Set Max Line Width up to as many characters you want (here 80):
Query is still unformatted and some lines are outside the grey right margin line set at 80 characters:
Press CTRL and F7 to format the query. In result the text will be wrapped to the right margin:
Note that as of Oracle SQL Developer 4.02 the right margin line will be always set at 80 characters line width, even if you change that. So if you set Max Line Width at more than 80, the query will be formatted and wrapped up to that width, but the right margin line will be visible after 80 characters.
See the post on how to enable the word wrap feature in Toad.