Can anyone tell me why this statement is not working. I keep getting a
ORA-01427: single-row subquery returns more than one row
SET mnth_sales_amt =
(SELECT SUM (dlycsh.sales_amt)
FROM tmx.dlycsh, chgdata.tmp10110191
WHERE dlycsh.tran_dt >= TO_DATE ('01/01/03', 'MM/DD/YY')
AND dlycsh.tran_dt <= TO_DATE ('10/22/03', 'MM/DD/YY')
GROUP BY dlycsh.site_no)
Your subquery is returning multiple rows, maybe you should test first the subquery alone and see how many rows it retrieves you, if you receive more than one row you have to use an "any" or "all" clause
This exercise is about for the following scenario:
Dmgr and One node with 2 application server.
Each application server contains it owns application.
Application server name as follows
server1 contains app1
server2 contains app1
There are numerous questions about how to setup an IBM HTTP Server to be administered from WebSphere Application Server administrative console. I do hope this article will wrap things up and become a reference for this task.
You need three things…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA).
For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651
If you want to manage em…