Search results for query: *

Oops. Should be CREATE TABLE MASTER_NIIN ("NIIN" VARCHAR2(10 byte) NOT NULL, "NSN" VARCHAR2(20 byte), CONSTRAINT "PK_NIIN" PRIMARY KEY("NIIN")) TABLESPACE "EVS" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL...

I have tried running this query in two different places: sql-plus and enterprise manager. I can compile the MDR_view with no problem. When I try to show the contents, it hangs. When I copy this query to sql-plus, it also hangs. Could it be a problem with the source table? This is my ddl...

Can anyone tell me what is wrong with this sql statement. Everytime I try to execute it, it hangs up. CREATE OR REPLACE VIEW "MDR_VIEW" ("NIIN","D_DDR", "D_MDR","R_DDR","R_MDR","MDR","MDR_SOURCE") AS...

Is is possible to open a Forms 9i module with Forms 6i? I have a module in 9i that I am going to have another developer modify, etc, but all he has is 6i. Is this going to create a problem? It is a simple module.

Can I reference "EXCESS"(g.FUD-NVL((e.total_needs +m.mdr*6),0)) as "EXCESS" anywhere else in this query? I need to reference this number and another calculated number to derive 23 other fields.

CREATE OR REPLACE VIEW EXCESS_VIEW (NIIN,EXCESS) AS SELECT g.niin, CASE when (e.total_needs + (m.mdr*6)) is null THEN g.FUD ELSE (g.FUD - (e.total_needs + m.mdr*6)) END CASE FROM G072_VIEW g, EXPRESS e, MDR_VIEW m WHERE g.niin = e.niin AND g.niin = m.niin...

Can you reference a calculated field in the same view that it was calculated? SELECT g.niin, CASE when (e.total_needs + (m.mdr*6)) is null THEN g.FUD ELSE (g.FUD - (e.total_needs + m.mdr*6)) END CASE FROM G072_VIEW g, EXPRESS e, MDR_VIEW m WHERE g.niin = e.niin AND g.niin = m.niin

I am trying to run a select statement that includes multiple if statements when populating a field. Is it possible to put an IF inside a SELECT clause? Here is the code. It says that FROM keyword not found where expected (line 7). SELECT m.niin, d.ddr, d.d200_mdr, r.ddr...

Setting a default email account is not an option in Outlook 2000.

I am using Outlook 2000 on Windows ME. I have set up 5 email addresses which I must check everyday. However, I only want one of the email addresses to be used on outgoing email. I can't figure out how to set this default email address.

I have installed Oracle 9i on my C: drive and Developer Suite on my D: drive successfully. Yesterday, I got in and created some tables in the database, but today, I can't even log on correctly. I haven't been able to connect to the database through Forms either. Does anyone have a...

I installed 9i Lite on my C: drive and 9i Developer Suite on my D: drive. Now, what do I need to do to get them to work together? I am learning, so I am not sure what to do first.

That worked. Thanks for your help.

That worked. Thanks for your help.

There are no add-ins in the box.

Whenever I start Outlook 2000, I get this error: 'C:\Windows\Application Data\Microsoft\AddIns' is not a valid Office add-in. I go to my add-ins and there are none there. I go to this folder and there is nothing there. How can I get this error to stop coming up?

I can't figure out why my Excel 2000 user settings keep changing. I set up my toolbars the way I like them and in the position I want them. I also set the recently used file list to 9. But whenever I close down Excel and reopen it, all the settings are back the way they were (default...

I need to do a batch update on a database, but I can't figure out how to do it. I am pulling multiple records from the database according to a specific string, but I want to do a batch update on those records according to a key field in the query. Here is my script (I am pulling according to...

I have a page that self closes onBlur (not the problem). The problem lies in that I have a hyperlink to an anchor that exists on that page. Whenever I click on the anchor hyperlink, it closes the window. Does anyone have any idea for a work around???

I am trying your script, because I need the same functionality, but I keep getting syntax errors. Here is my code (I am getting a syntax error on '%"&prob_Array(0)"%'": Dim sql_prob sql_prob="Select * from problems where " Dim pFlag, i, nFlag, j, sFlag, k...