COUNT can be COUNT(*) or COUNT (DISTINCT expression) but not COUNT(expression). ... going wrong on this. My eyes are starting to glaze over staring at it and...
actually, count() can count an expression (john, you may be thinking of something else?) SQL> select count(*), count(empno), count(decode(sal,0,null,sal)) as...
Mark C. Stock
mcstock@...
Jul 4, 2005 5:25 pm
759
Hi Mark, Thanks for getting back to me. I had the feeling that something was not right with that syntax. I have yet to put my finger on it. I have to dwell on...
Prescribed@...
Jul 6, 2005 4:30 pm
760
I have developed a form application built of two blocks on two different canvases. How do I set it up so that when double-clicked, the block will bring up the...
Phillip
psmall57@...
Jul 6, 2005 4:30 pm
761
Hello, My issue is dealing with forms and I want to have a page or tab listing of records in one tab. log#, disp, descr,...
Phillip
psmall57@...
Jul 6, 2005 4:30 pm
762
I tried to do this but in the drop down on the 'Synchronize with Item' option, the description for the other table is not one of the list. Are you referring...
Phillip
psmall57@...
Jul 6, 2005 7:42 pm
763
'mirror item' is a concept -- i think oracle may have used the term in its documentation at one point the idea of a 'mirror item' is that it is a 2nd occurence...
Mark C. Stock
mcstock@...
Jul 6, 2005 10:37 pm
764
I have an Oracle form that is a single block at the top of the page and at the bottom the 2nd block is a multi-record block. I went back and added a scrollbar...
in your w-m-d trigger go_block('< detail block name >'); execute_query; If you use the datablock wizard and set up your relationships correctly then you...
as far as i can recall (don't have a working forms installation right now) what you are describing is normal behavior -- the scroll bar will scroll the set of...
Mark C. Stock
mcstock@...
Jul 8, 2005 3:06 pm
767
Hi, Would anyone shed some light on this... 1) If 98% system availability of Oracle (11 modules) is considered industry standard for an SLA. If so, does IT...
Hi Phillip, You need two datablocks based upon the same table with a one to one relationship between them. use the tabular layout as the master block and the...
from just a quick look i think you can probably solve this without triggers -- assuming you have a multi-row block that displays a short single-line version of...
Mark C. Stock
mcstock@...
Jul 8, 2005 3:07 pm
770
block coordination should be done with a Relations object, not with EXECUTE_QUERY in a trigger navigation (in your WHEN-MOUSE-DOUBLECLICK) can be done with the...
Mark C. Stock
mcstock@...
Jul 8, 2005 3:07 pm
771
In Forms, how do you perform an insert into a table without getting the error 'Identifier table_name must be declared' ? I know there is a way to do inserts in...
Tarveen, I can not speak to Oracle 11. Ping of 120 milliseconds does not sound good. From a cable modem/ISDN/LAN connection 120 milliseconds is very bad. You...
Allen Shepard
ashepard@...
Jul 11, 2005 6:53 pm
773
Hi, Well I am still at it. Would someone out there please explain what I am doing wrong. I provided a substitution variable in a pl/sql block as part of a...
Prescribed@...
Jul 18, 2005 1:26 pm
774
+ Interjection by listserv moderator: + Several helpful replies to this posting, below... ... From: "TNL Technologies, Inc." <subscription@...> Al, I...
I am currently working on a Project with Oracle Forms 9i at front end and Microsoft SQL server at back end. Could Any one please recommand me the steps to...
Hi Everyone, I want to thank you for being so helpful. You don't even know how much you are helping. Even though this question is old I had already finished...
Prescribed@...
Jul 26, 2005 1:48 pm
778
Hi, Would someone take a look at this statement? I can't seem to locate the error and another pair of eyes may help. EXECUTE IMMEDIATE ?INSERT INTO tt_table...
Prescribed@...
Jul 29, 2005 3:01 pm
779
Does Oracle provide any best practice means of dealing with Daylight Savings Time issues for remote servers in multiple locations? If so, what are the details?...
Usually this is an issue handled by the OS ( OpenVMS, Linux, Unix, Windows, Mac, etc etc). With the "new" daylight savings law that passed in the US, ...
Dr Robert Young
rcyoung@...
Aug 9, 2005 5:23 pm
781
There may be platform differences that I'm not aware of, but for the most part, Oracle picks up its clock information from the underlying operating system. So...
Oracle 9IR2.06 I'm looking for a method to create a reproducible database clone for use within a development test lab. I used to use the Export/Import ...
Use a backup of the database and simply restore it. ================================================== gofftfln <goffd@...> wrote: Oracle 9IR2.06 I'm...
Brett Ogletree
bretto97@...
Aug 9, 2005 11:15 pm
784
I forgot to mention my environment does not allow using RMAN. Darrell...
Hi Everybody, We have data in Oracle 9i data base. Users want to pull the data in Excel spreadsheet format through web. They like to download the data into...
+ Interjection by listserv moderator: + Several helpful replies to this posting, below... ... From: "I. Michael Snyder" <i.michael.snyder@...> Ram, ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
