update a field from a file with a field from a selection from two files
Hi!When I try this:update fileD d set d.value = (select c.value from (select b.key, b.value from fileB b where b.key not in (select a.key from fileA a)) c where d.key = c.key)I get the message "Null values not allowed in column or variable VALUE."on the other hand, when I do this selection:(select...
View Answer
| Apr 29 2008 11:03 AM GMT
| asked by
Mr.
Update, SELECT, SQL
Using SELECT statements
Can we get the number of saturdays in any month using a SELECT statement(i.e without creating a table or function)? If so, can you give me the logic?
View Answer
| Feb 27 2008 9:48 PM GMT
| asked by
OracleATE
Oracle, Oracle development, SELECT
Showing all records
DATA SET:Table1XID YID WRKDATE--- --- ------- 1 NOR 2007-012 SOU 2007-03Table2XID ZID QTY --- --- --- 1 PEN 10 1 PAP 202 PAP 51 PEN 102 PAP 5ResultXID YID WRKDATE ZID QTY--- --- ------- --- ---1 NOR 2007-01 PAP 201 NOR 2007-01 PEN 101 NOR 2007-01 PEN 102 SOU 2007-03...
View Answer
| Nov 27 2007 2:58 AM GMT
| asked by
TeamJR3
SELECT, JOIN
oracle quires
while executing the following qurie 'inser into custmaster select * from tnjcust where seccode='431';' answer is not enough valus
View Answer
| Oct 26 2007 1:36 PM GMT
| asked by
Balachander k
Oracle, SELECT
Nested Selects in CLLE
I am attempting to palce Nested Select Statements within a CLLE program and it will not accept the process.ie:SELECTwHEN a=B THEN(DO)PROCESS....ENDDOWHEN C=D THEN(DO)PROCESSeNDDOWHEN (X=Y) tHEN(DO)selectwHEN X1 = A tHEN(dO)PROCESSeNDDOwHEN X1 = b THEN(DO)PROCESSeNDDOeNDselectwHEN X=z ...
View Answer
| Oct 16 2007 7:11 PM GMT
| asked by
Wmfsr
NESTED, SELECT, CLLE
Select from table where data row missing
I have a table with the main fields being BU, ASSET, BOOKfor any BU and ASSET combination, there should be two to four rows of data, with just the BOOK value being different. Data corruption has caused us to find all BU-ASSET combinations missing the value 'AMT' for BOOK. I need to join the table...
View Answer
| Oct 15 2007 9:34 PM GMT
| asked by
Jej1216
SELECT, Outer Join
