| There are no upcoming events |
| Don't have an account yet? Sign up as a New User
|
|
|
Warning: fopen(/var/www/gurtlush.org.uk/web/lib/logs/error.log) [function.fopen]: failed to open stream: Permission denied in /var/www/clients/client3/web9/web/lib-common.php on line 1440
| Author: |
Ben |
| Dated: |
Friday, September 23 2005 @ 01:13 PM BST |
| Viewed: |
403 times |
|
 To get a sum of a column in sql plus you need to use compute and break. Without the break it will not work.
|
| Author: |
Ben |
| Dated: |
Friday, September 16 2005 @ 02:41 PM BST |
| Viewed: |
365 times |
|
| Normaly SQL*Plus varables must be passed in through the command line (and referenced as &1, &2 etc.) or types in interactivley. There is however a way of setting varables using a SELECT statement in a simeler way to using INTO in PL/SQL.
|
| Author: |
Ben |
| Dated: |
Monday, October 18 2004 @ 12:05 PM BST |
| Viewed: |
1286 times |
|
| Having Excel launch after a report is run with the report in it is quite useful if the report was designed to be loaded by Excel. This obviously had to be a character mode report designed to be saved as a Comma Separated File (.csv). This article mainly deals will using Object Linking and Embedding (OLE2) to pass the report but also outlined issues involved in developing reports designed to be exported as .csv.
|
| Author: |
Ben |
| Dated: |
Wednesday, May 26 2004 @ 04:40 PM BST |
| Viewed: |
1016 times |
|
| The above 'striping' is usefull to help users 'scan' across the page, especialy when the report has a lot of white space. It is done by including the rownum and using mod to get every other row. Below is an example of the code.
|
| Author: |
Ben |
| Dated: |
Thursday, April 22 2004 @ 02:10 PM BST |
| Viewed: |
1074 times |
|
| One of the really infuriating things about Oracle Forms 6i (and possibly other versions) is that when you set a visual attribute for a item the prompt, as well ad field, takes that background colour. Seing it is common to have the field background white and the canvas background gray this is a paid. The following procedure sets the background colour for all prompts to the background colour of the canvas the prompts field sites on - i.e. it automaticaly sorts out the problem.
|
| Author: |
Ben |
| Dated: |
Wednesday, April 21 2004 @ 04:01 PM BST |
| Viewed: |
799 times |
|
| This uses a procedure which takes the field name and sql. The SQL returns description, code and they must both be of type char. The field must be set a list type field. It is also nessesery to put go into the property sheet for the field and in 'Functional' section use 'Elements in List' to set up a single dummy value. There must not be a default value defined in the property sheet for this to work and the field can not be required (i.e. manditory validation has to be programed later.
|
|
|
How often do you reed non-corporate news media (not-for profit publications/websites)
30 votes | 0 comments
|
STORIES
No new stories
COMMENTS last 48 hrs
No new comments
LINKS last 2 wks
No recent new links
|
|
