Search results for query: *

I have a block based on a table. When the user enters data into a control field and presses a save button. The data is transferred to a field in the block table. This works quickly and as expected; however, when I change the block to be based on a view (select * from table), there is a...

I have a block based on a table. When the user enters data into a control field and presses a save button. The data is transferred to a field in the block table. This works quickly and as expected; however, when I change the block to be based on a view (select * from table), there is a...

I have a report in Oracle Reports that has 3 levels of groups for a group above report. I wanted to add a new group between the first and second group but can't figure out how. I could recreate the entire report with the new field and rerun report wizard, but that seems like too much work for...

I'm rather new to Oracle Reports and am trying to create a drill down report. I have a first report that is a summary list of all outstanding issues by their age. I want to be able to click on the age and have that pull up my second report that gives the detail behind the summary report. How...

I want to create a record type that is global to my application. Is this possible and what is the syntax? This way I can pass a variable that is the record type between procedures rather then having to pass a large list of parameters. Thanks HS

I haven’t worked with Forms very long and am trying to figure out the best way to approach the following: I have a 3 level selection choice. The user selects NAME, LOCATION, VERSION. At the first level the user uses a list item to select a NAME. At the list item the user selects the...

Is it possible to expand a volume with an existing drive under RAID 5? I have a volume that I want to expand, but I don't want to have to backup the entire volume, reset the size, and then restore. Is there a simplier way? Thanks HS

Does anyone know anything about integrating Oracle and Outlook? I am trying to create an application in Oracle Forms, but I want to be able to use Outlook for email, tasks, calendar, and contacts. Thanks HS

I am trying to dynamically access the data in :old and :new fields without having to use the literal :old.field and :new.field. The trigger below shows 2 ways of calling the p_addnote procedure. The first, now commented out, works by making a direct call of p_addnote with the literal data...

If I was using Oracle 8 would you still suggest staying with varchar2? We will probably be migritating to Oracle 8 within the next year.

I am using Oracle 7.3. In my current system, notes for an account are entered in a separate table over as many rows as required using a varchar2(60). Sometimes a user needs to find specific words within these rows and to that end we have a query built in that searches for the users word by...